ADD TO CART Stopped working

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.

Hi there,

The button didn't "stopped working" and there is probably a reason for that .
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.

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?

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.

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.

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 ignore the last error re: loadSetupFile() - has been fixed. Still having a problem with Hikashop cart.

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.

SQL error is gone. I sent you a link via Contact Us.

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.

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.

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
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

Thanks very much for the suggestions.