hikashop_cart

  • Posts: 210
  • Thank you received: 4
  • Hikashop Business
2 months 3 weeks ago #358912

-- HikaShop version -- : 5.0.2
-- Joomla version -- : 5.0.1
-- PHP version -- : 8.2.14

There is the period of time during which the cart will be kept in the database in Hikashop configuration
After that, the cart data will be cleaned to avoid having too much data.

Today we found what hikashop_cart and hikashop_cart_product tables inculdes a lot of records more
than 2 years old even period of time setted to 12 hours and frequency of check time is 1 hour

How to check this work of this feature and how to erase unneccesaty old data from this tables?

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
2 months 3 weeks ago #358913

Hi,

This means that you need to increase the check frequency a lot more. Instead of 1 hour, make it 1 minute.

Here is a post with more information about this situation:
www.hikashop.com/support/forum/orders-ma...er-carts.html#356638

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

  • Posts: 210
  • Thank you received: 4
  • Hikashop Business
2 months 3 weeks ago #358934

I increased frequency to 1 minute but it didn't make any effect, so deleted all records from hikashop_cart and hikashop_cart_product with user_id = 0.

Thanks fot the bots threads links. Bots are constantly putting items in the carts and some of the bots go to the checkout page after that and create a user accounts at various email addresses. This behavior of bots will lead to nothing good. Captcha does not protect against such registration. The registration form needs to be made more secure.

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
2 months 2 weeks ago #358936

Hi,

Changing the frequency won't delete the carts. But it will avoid the problem to come back in the future.

Regarding bots, I would recommend using OSpam-a-not :
extensions.joomla.org/extension/ospam-a-not/
Captcha are not good anymore because of the progress of AI in the past few years.

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

Time to create page: 0.059 seconds
Powered by Kunena Forum