Table_orders crash sometimes

-- HikaShop version -- : 4.6.1
-- Joomla version -- : 3.10.10

Hi!

Sometimes when i go to orders i get the error message that the table_orders is crashed and i have to go repair the database.
Any ideas why this is happening?

Thank you

Hi,

Tables can crash. You can find extensions on the JED to repair crashed tables.
Also, most often, tables crash because of lack of memory or or resources for MySQL:
stackoverflow.com/questions/10984639/joo...-session-table-crash
So it after the repair, the table crash often, I would recommend talking with your hosting to see what can be done.

I saw that the website that crashed are these with thousands of rows. How are these rows created in hikashop_cart table.
I have an installation with 100 orders and 100.000 carts.
Is it safe to truncate hikashop_cart table? Is it like session?
Thanks

Hi,

It's not really a matter of a lot of rows in the table but of memory of MySQL itself. So if MySQL runs one of memory it can't create new rows in the table (the number of rows already in the table is irrelevant).
Now bear in mind that I'm no MySQL server expert.
If you truncate the hikashop_cart table, please also do it for the hikasohp_cart_product table.
Also, that means that all your users will loose their carts and wishlists. But there won't be a problem with it besides that.

Sorry Nicolas again. But will this bother orders?
I mean truncating these tables cart and cart_products will affect existing orders?
Because we re talking about a bear metal server with 2gb ram per account. It shouldn t be doing this because of recources.
Thanks

Hi,

No. It won't affect orders.

Regarding the "why", I don't know. It would require analyzing the logs of the MySQL server.