Virtuemart error

Hi
I just installed the template and wanted to configure virtuemart, but I found several errors when trying to view the categories, products, manufacturers, orders, etc. that will not let me do anything.
This occurs only in the backend. I installed the quickstart template with sample data, where the categories and the rest will look great in front, but no in the backend.

For example, the categories error is:

vmError: exeSortSearchListQuery Table 'miraelmu_imagen13.ucj85_virtuemart_categories_es_es' doesn't exist SQL=SELECT c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `ucj85_virtuemart_categories_es_es` l JOIN `ucj85_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `ucj85_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name DESC

The products error is:
vmError: exeSortSearchListQuery Table 'miraelmu_imagen13.ucj85_virtuemart_products_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `ucj85_virtuemart_products_es_es` as l JOIN `ucj85_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 20

Is this a problem with language? I unpublish spanish language and published english in backend bit the error remains.

I would guess, problem has its source in hosting company. Our template don't modify backend, so it should work fine.

First thing I would suggest to do is to run quickstart installation in subfolder and carefully check, if all requirements of Jooomla are met. Here is a screenshot of J3.x screen that confirms 100% compatibility:

I installed a J2.5 versión because Virtuemart is only for this. I have other J2.5 sites with this hosting, for this I know is not a problem with J2.5 in the hosting.
Now the virtuemart examples in front are not, And the error is a large text...(I have not touched virtuemart! I've only changed things in K2!)

vmError: vmTable load xTable 'miraelmu_imagen13.ucj85_virtuemart_vendors_es_es' doesn't exist SQL=SELECT `ucj85_virtuemart_vendors_es_es`.* ,`ucj85_virtuemart_vendors`.* FROM `ucj85_virtuemart_vendors_es_es` JOIN ucj85_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE ucj85_virtuemart_vendors_es_es.`virtuemart_vendor_id` = "1"
vmError: exeSortSearchListQuery Table 'miraelmu_imagen13.ucj85_virtuemart_products_es_es' doesn't exist SQL=SELECT l.`virtuemart_product_id` FROM `ucj85_virtuemart_products_es_es` as l JOIN `ucj85_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `ucj85_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_categories_es_es` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ucj85_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `ucj85_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) AND p.`product_special`="1" ) group by p.`virtuemart_product_id` ORDER BY RAND()ASC LIMIT 0, 3
vmError: exeSortSearchListQuery Table 'miraelmu_imagen13.ucj85_virtuemart_products_es_es' doesn't exist SQL=SELECT l.`virtuemart_product_id` FROM `ucj85_virtuemart_products_es_es` as l JOIN `ucj85_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `ucj85_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_categories_es_es` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ucj85_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `ucj85_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) AND p.`created_on` > "2013-10-22 22:24:33" ) group by p.`virtuemart_product_id` ORDER BY p.`created_on`DESC LIMIT 0, 3
vmError: exeSortSearchListQuery Table 'miraelmu_imagen13.ucj85_virtuemart_products_es_es' doesn't exist SQL=SELECT l.`virtuemart_product_id` FROM `ucj85_virtuemart_products_es_es` as l JOIN `ucj85_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `ucj85_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_categories_es_es` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ucj85_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `ucj85_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `ucj85_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `ucj85_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) AND pp.`product_price`>"0.0" ) group by p.`virtuemart_product_id` ORDER BY p.`product_sales` DESC LIMIT 0, 3

Hi
While I was waiting for your reply, I called the hosting to explain what you say in your post. They recognized that virtuemart needed MySQL 5.5 and this had MySQL 5.1.68. For this they changed the site to another server with MySQL 5.5.
But this has not improved things. Virtuemart keeps throwing the error and I do not know what it is.
Other parameters for joomla 2.5're all correct.

I have two ideas.
1. Please change default template to Beeze to check if its template or installation related.
2. Probably while You had older PHP compiler, data in mysql base was corrupted. If changing to Beeze doesn't help there might be only one solution now - reinstalling of quickstart .

Thanks, I changed the template and the error are still on it. I will reinstall it.

Reinstalling is one solution, the second would be to ask hosting company for support, as it might be some configuration problems as well.
Please share what solution helped when you will deal with that problem.

Hi
I reinstalled all the quickstart package of storebox template. I had it without problems, and I also installed spanish language package...then I realized that virtuemart demo information dissapeared. then I thought that the joomlaspanish.org language pack could be corrupted so I installed it again with language files from joomla.org., but virtuemart behavior is the same, simply disappears. I know that after the system will show me the same errors.
This seems to be a language error.
I need your help.

Could you point me to exact language package you have used - Ill check it out.