No products visible on front-end

Hi again,

I'm getting the following error on VM2:

vmError: exeSortSearchListQuery Table 'qa9dx_virtuemart_products' is marked as crashed and should be repaired SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `qa9dx_virtuemart_products` as p group by p.`virtuemart_product_id` ORDER BY p.`created_on` DESC LIMIT 0, 20

And no products are visible on front-end (they are visible on back-end though).

Could you somehow direct me as to how to fix the database and where to search for the error? What may be the reason of such and error?

Thank for your help.

It looks like something is wrong with VirtueMart database tables. I think you should start from VM reinstallation and if this problem come back probably the only way is to restore website from backup copy.

Thanks, I'll try that.

Did you resolve your problem?

Supposedly, there is one product added to VM which crashes the whole database. It is added to "virtuemart_products" with no data, I mean no name, no description, no alias and so on. It's like a ghost product. My "virtuemart_products" database doesn't open in the row where it is placed. As far as the backup is concerned, it just copied the data up to this product. I've got also "virtuemart_products_en_gb" database and it seems to be allright.
Do you think there is any solution to that?

It was clean installation? Maybe in database there are some old entries. Did you also try to repair database via phpMyAdmin like it is described here » Repair and Optimize MySQL Databases with PhpMyAdmin Tutorial

Actually a person who was adding products to VM added such an entry. As I'm not keen in databases, I'm a bit afraid of picking "Repair table" action in PhpMyAdmin, as I'm worried that it will delete the products that are added after the one which is causing the crash. Is it possible that it will happen or should I not be worried?

I've got one more question about the VM database. There was a mistake made during the installation and the shop is now multilingual with English set up as language. In the database all the products, categories and so on are added to the en_gb databases. All the pl_pl databases are clear. Actually, I do not need the mulilinguality. I just need it to be Polish. Can it be somehow changed right now?

There is no way to remove english tables because this ones are default. You probably need to fix the database to make it working in right way I don't see any other solution for this.

Thatnks for your help. I've fixed the database in phpmyadmin.

If it is possible please describe your solution, for sure it will be helpful for other forum members.

Actually I've just asked the database provider to take a look at it and supposedly he just run the repair table programme via phpmyadmin. The invalid entry is now gone and all the other entries stayed in the database so everything works just fine.