Error message after installation site - error 500

Hi,

I have e-sport virtuemart quickstart. I uploaded this package on my server, after installation site work fine but after some time there is an error like Oops, you've encountered an error 500. and given below error.

JDatabaseMySQLi::query: 1146 - Table 'webartma_noteb.vy8t0_vm_product' doesn't exist SQL=SELECT content.product_id AS id, COUNT(comments.product_id) AS count FROM vy8t0_vm_product AS content LEFT JOIN vy8t0_vm_product_reviews AS comments ON comments.product_id = content.product_id WHERE comments.published AND ( content.product_id = 40 OR content.product_id = 58 OR content.product_id = 57 OR content.product_id = 24 OR content.product_id = 56 OR content.product_id = 23 OR content.product_id = 22 OR content.product_id = 55 OR content.product_id = 21 OR content.product_id = 54 OR content.product_id = 34 OR content.product_id = 53 OR content.product_id = 49 OR content.product_id = 52 OR content.product_id = 19 OR content.product_id = 51 OR content.product_id = 50 OR content.product_id = 18 OR content.product_id = 48 OR content.product_id = 32 OR content.product_id = 47 OR content.product_id = 31 OR content.product_id = 25 OR content.product_id = 46 ) GROUP BY
comments.product_id ;

Please do needful help asap.

Thanks
Priyali

Hi

Have You installed any additional extensions like languages, plugins, modules ? Looks like script is trying to pull informations from not existing table. Unfortunately I do not know if it's because script is using wrong name or something happened to this table. Please try reinstalling VM.

Hi,

Thanks for reply, I have installed languages from install language tab from joomla setup, but after that site was working fine. now i uploaded new setup again but not installed languages and site is working fine. so, is that means we are not able to upload any languages, modules, plugins ?

further as you told to reinstalling VM, then what about existing product data? It will be lost if i reinstall VM.

Please give me wright suggestion what i have to do for upload modules, plugins etc.

Hi


VM creates only language tables for languages which are installed, so the order should be to install languages first and than VM. Normaly i fix it by reinstalling VM, but I'm not sure if products will not be lost. Please search VM setting and check if it's possible to update database in case of different language tables.

Hi,

Thanks for help. my site is working right now. i will try to reinstalling VM if any issue.
Thanks a lot.

Hi

Just so I learn it for myself. Have You found this option to update database language tables without reinstalling VM ? I think I've seen such option in Tools sectio of VM menu.