[Skip to main content](#vessel-content) # ADD TO CART Stopped working ## - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142600](#142600) by [beck](/forum/user/5262-beck "View beck's Profile") *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142600 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* was created by *[beck](/forum/user/5262-beck "View beck's Profile")* Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table db1_db2.j25_hikashop_badge' doesn't exist SQL=SELECT a.* FROM j25_hikashop_badge AS a WHERE a.badge_start <= 1391652301 AND ( a.badge_end >= 1391652301 OR a.badge_end =0 ) AND a.badge_published=1 AND (badge_discount_id=0 OR badge_discount_id=0 )AND ((badge_category_childs = 0 AND (badge_category_id = 0 OR badge_category_id = 12))OR (badge_category_childs = 1 AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 12))) ORDER BY a.badge_ordering ASC,a.badge_id ASC Can you please help with this? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#142611](#142611) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142611 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* Hi there, The button didn't "stopped working" and there is probably a reason for that ![:)](/media/kunena/emoticons/3.png ":)"). According to the error it looks like the table db1_db2.j25_hikashop_badge is not in your database anymore. You may have removed it or renamed it. Try to look at your DB and see if there is something similar. You can also reinstall Hikashop to get this table back. It shouldn't affect your shop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142737](#142737) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142737 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* If you think this shouldn`t prevent Hikashop from working, maybe there is a different reason. Can someone please take a look? Can I submit a link in private? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 12 years 9 months ago [\#142752](#142752) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142752 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* As Eliot said, the table of the badges is missing in your database. So you will need to add it back. Look in the file administrator/components/com_hikashop/tables.sql for that table creation query and run it in your database with phpmyadmin after changing the prefix to your table prefix and that will solve the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142753](#142753) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142753 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* I added a new table as suggested. The issue still exists - can`t add anything to the cart, page only refreshes and tells me the cart is empty. There is one more degub message: Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() Please assist. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142754](#142754) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142754 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* I should`ve mentioned, the original message re: badge table being missing is now gone. Thanks for helping with this. Add to Cart still doesn`t work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142755](#142755) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142755 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* Please ignore the last error re: loadSetupFile() - has been fixed. Still having a problem with Hikashop cart. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 12 years 9 months ago [\#142761](#142761) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142761 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* If you still have the SQL error with the table missing, it means that the table has not been added properly. Otherwise, then we would need a link to the page in order to look at the issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142769](#142769) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142769 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* SQL error is gone. I sent you a link via Contact Us. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 12 years 9 months ago [\#142779](#142779) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142779 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* The add to cart is working "fine" for me on your website. However, you have a caching issue on your website since you don't see the modifications on the cart unless you go to a new URL. You would have to turn off the joomla caching option of the joomla configuration, and the joomla cache plugin and potentially your template's caching option, or any kind of CDN if any and that should help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#142781](#142781) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142781 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* Thanks, Nicolas! Is there a reasonable solution - our host starts to throttle us if we don`t cache, but our shopping cart doesn`t work if we do? Do you have any suggestions? Your help is very much appreciated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 12 years 9 months ago [\#142972](#142972) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#142972 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* Caching a shopping cart is not possible, otherwise it cannot update the information on the interface when you do an action like add something in the cart. So you should use a more fine grained caching system so that you can exclude the shopping cart from the cache while still cache the rest of the website. HikaShop has an integration with Varnish for such things: [ massivescale.net/varnish-joomla.html](http://massivescale.net/varnish-joomla.html) But otherwise, you can fine more fine grained solutions than the default joomla caching system on the JED: [ extensions.joomla.org/extensions/core-en...ts/performance/cache](http://extensions.joomla.org/extensions/core-enhancements/performance/cache) The following user(s) said Thank You: [beck](/forum/user/5262-beck "View beck's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[beck](/forum/user/5262-beck "View beck's Profile")** - [![beck's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5262-beck "View beck's Profile") Topic Author - [ Offline](/forum/user/5262-beck) Less More - Posts: 22 - Thank you received: 0 - - 12 years 9 months ago [\#143059](#143059) by [beck](/forum/user/5262-beck "View beck's Profile") Replied by *[beck](/forum/user/5262-beck "View beck's Profile")* on topic *[ADD TO CART Stopped working](/forum/27-checkout/865615-add-to-cart-stopped-working#143059 "Hello: Our ADD TO CART button stopped working. I click, the page refreshes but the cart is empty. After I turned the debug mode, I got this error: 500 - JDatabaseMySQLi::query: 1146 - Table...")* Thanks very much for the suggestions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTYxNS1hZGQtdG8tY2FydC1zdG9wcGVkLXdvcmtpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.070 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)