Welcome, Guest
Username: Password: Remember me
Use this Category for your support questions about Joomla Virtuemart Template - DarkMart (SKU# FLEX-00011)

TOPIC: Russian language is set, an error in the database

Russian language is set, an error in the database 11 years 4 hours ago #4296

QuickStart
I'm from Russia after the Russian language is set to VM, there is such a mistake in the categories in admin:
vmError: exeSortSearchListQuery Table 'uvelir.ib39x_virtuemart_categories_ru_ru' 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 `ib39x_virtuemart_categories_ru_ru` l JOIN `ib39x_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `ib39x_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

and that such a product:

vmError: exeSortSearchListQuery Table 'uvelir.ib39x_virtuemart_products_ru_ru' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `ib39x_virtuemart_products_ru_ru` as l JOIN `ib39x_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 20
vmError: exeSortSearchListQuery Table 'uvelir.ib39x_virtuemart_categories_ru_ru' 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 `ib39x_virtuemart_categories_ru_ru` l JOIN `ib39x_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `ib39x_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 ORDER BY category_name ASC


how to fix?)
Last Edit: 11 years 3 hours ago by Anton Kudryashev.
The administrator has disabled public write access.

Russian language is set, an error in the database 10 years 11 months ago #4304

Hi,

This has nothing to do with our template - it doesn't affect the tables or data of VM in any way...

This is something to do with your language configuration of VM - your russian product and cat tables are missing..

Check your VM language configuration..

If you google - vmError: exeSortSearchListQuery Table _virtuemart_categories doesn't exist -- you will see many entries..

Cheers
The administrator has disabled public write access.
Time to create page: 0.064 seconds

MaterialMart

for Virtuemart 3

Google's Material Design has finally arrived to Virtuemart

Virtumart Template - MaterialMart Virtumart Template - CleanMart Virtumart Template - CleanMart Virtumart Template - CleanMart

Fully responsive!

Buy Now   |   Live Demo