ADD TO CART Stopped working

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #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 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 or Create an account to join the conversation.

  • Posts: 2334
  • Thank you received: 403
11 years 4 months ago #142611

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.

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142737

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 or Create an account to join the conversation.

  • Posts: 83933
  • Thank you received: 13588
  • MODERATOR
11 years 4 months ago #142752

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 or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142753

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 or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142754

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 or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142755

Please ignore the last error re: loadSetupFile() - has been fixed. Still having a problem with Hikashop cart.

Please Log in or Create an account to join the conversation.

  • Posts: 83933
  • Thank you received: 13588
  • MODERATOR
11 years 4 months ago #142761

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 or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142769

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

Please Log in or Create an account to join the conversation.

  • Posts: 83933
  • Thank you received: 13588
  • MODERATOR
11 years 4 months ago #142779

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 or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 4 months ago #142781

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 or Create an account to join the conversation.

  • Posts: 83933
  • Thank you received: 13588
  • MODERATOR
11 years 4 months ago #142972

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

The following user(s) said Thank You: beck

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
11 years 3 months ago #143059

Thanks very much for the suggestions.

Please Log in or Create an account to join the conversation.

Time to create page: 0.095 seconds
Powered by Kunena Forum