[Skip to main content](#vessel-content)

#   Table\_orders crash sometimes

##

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

4 years 4 months ago [\#343101](#343101) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343101 "-- 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&#95;orders is crashed and i have to go repair the database. Any ideas why this is happening?  Thank you")* was created by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 4 months ago [\#343105](#343105) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343105 "-- 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&#95;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](https://stackoverflow.com/questions/10984639/joomla-jos-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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

4 years 4 months ago [\#343176](#343176) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343176 "-- 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&#95;orders is crashed and i have to go repair the database. Any ideas why this is happening?  Thank you")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 4 months ago [\#343179](#343179) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343179 "-- 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&#95;orders is crashed and i have to go repair the database. Any ideas why this is happening?  Thank you")*

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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

4 years 4 months ago [\#343197](#343197) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343197 "-- 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&#95;orders is crashed and i have to go repair the database. Any ideas why this is happening?  Thank you")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

4 years 4 months ago [\#343200](#343200) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table\_orders crash sometimes](/forum/3-bug-report/904710-table-orders-crash-sometimes#343200 "-- 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&#95;orders is crashed and i have to go repair the database. Any ideas why this is happening?  Thank you")*

Hi,

No. It won't affect orders.

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC85MDQ3MTAtdGFibGUtb3JkZXJzLWNyYXNoLXNvbWV0aW1lcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.064 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
