Using v1.5.0 and in the past year, have experienced some type of corruption of our products table several times. We have about 5300 items and have not modified the products table in any way. The corruption messes up any orders and eventually causes the program page-loading queries to spin out of control, locking up the entire site. Then we get our host yelling at us for overloading their server.

To fix it, we delete the table and simply copy the old table. But phpMyAdmin will not allow us to delete it. It just hangs. So we have to call the webhost's tech support. They also cannot delete it, so they send it to someone higher up.

Once deleted and the backup table copied in, everything is perfect again for a couple of months until it repeats.

This is driving us and our webhost crazy, though our webhost has been extremely nice and helpful and patient and who's tech and customer support is unbeatable.

Any ideas out there? Thanks in advance.

Matt