I'm not sure what your host is referring to by "reindexed".
If they mean your database might need to be repaired or optimized, you should be able to do a repair from your hosting control panel, or do optimization of individual tables via phpMyAdmin's Operations tab.
When did this start happening?
What has been happening on the server around that time?
You might need to compare your site's code against the original code and see what customizations may have busted things.
http://www.zen-cart.com/wiki/index.p...Obscure_Issues
If it's hanging during checkout and orders are getting saved but the screen is not completing, then maybe the email step is failing? Has anything changed for your email settings lately? Passwords? Server changes? php upgrades?




