When I install spanish VirtueMart articles dissape

Hello,

I install the template by means hotstart and everything was well but then I install spanish languaje and all articles disappear from virtuemart.

I revert languaje settings to English and virtuemart appear again.

What should I do in order to make virtuemart run spanish languaje?

Regards,

Susana Garduño

My site is here:

recordarte.turismonegocios.biz/index.php

Check this, under Extension Manager in Database tab see if there is some button or link syaing something like "click here to fix database" if you see it click on it

There is not a link or button like that.

But inside virtuemart in store I find this message: JUser: :_load: No se puede cargar usuario con el ID: 42 (JUser: :_load: Unable to load user with ID: 42)

Could be this the problem?

Susana

P.S. Besides, I have noticed if I change languaje of backend all in the VM store dissapears. When I put it in English again it appears. Could you give me an advice on this?

I send my login info in "Report to moderator" my link is recordarte.turismonegocios.biz/

Yes that is well known error that happens when you migrate site db from one server to another. You have to edit in db directly ID of user "Super administrator" to change it to 42 table is $$_users. Remember ID that you cnaged and also change it to 42 in $$_user_usergroup_map

I change the ID as you tell me, but problems persist.

Now I'm getting messages as following:

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_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 `q83oa_virtuemart_categories_es_es` l JOIN `q83oa_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `q83oa_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


vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_products_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `q83oa_virtuemart_products_es_es` as l JOIN `q83oa_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 10
vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_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 `q83oa_virtuemart_categories_es_es` l JOIN `q83oa_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `q83oa_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

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_products_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `q83oa_virtuemart_products_es_es` as l JOIN `q83oa_virtuemart_products` AS p using (`virtuemart_product_id`) WHERE ( p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY product_name DESC LIMIT 0, 10

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_products_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS r.*,p.`product_name` FROM `q83oa_virtuemart_ratings` AS `r` JOIN `q83oa_virtuemart_products_es_es` AS `p` USING (`virtuemart_product_id`) ORDER BY created_on DESC LIMIT 0, 10

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_paymentmethods_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,u.email as order_email,pm.payment_name AS payment_method FROM q83oa_virtuemart_orders as o LEFT JOIN q83oa_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN q83oa_virtuemart_paymentmethods_es_es as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 10

vmError: vmTable loadTable 'justelit_record.q83oa_virtuemart_vendors_es_es' doesn't exist SQL=SELECT `q83oa_virtuemart_vendors_es_es`.* ,`q83oa_virtuemart_vendors`.* FROM `q83oa_virtuemart_vendors_es_es` JOIN q83oa_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE q83oa_virtuemart_vendors_es_es.`virtuemart_vendor_id` = "1"

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_paymentmethods_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,u.email as order_email,pm.payment_name AS payment_method FROM q83oa_virtuemart_orders as o LEFT JOIN q83oa_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN q83oa_virtuemart_paymentmethods_es_es as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 10

vmError: exeSortSearchListQuery Table 'justelit_record.q83oa_virtuemart_manufacturers_es_es' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS `m`.*,`q83oa_virtuemart_manufacturers_es_es`.*, mc.`mf_category_name` FROM `q83oa_virtuemart_manufacturers_es_es` JOIN `q83oa_virtuemart_manufacturers` as m USING (`virtuemart_manufacturer_id`) LEFT JOIN `q83oa_virtuemart_manufacturercategories_es_es` AS mc on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id` ORDER BY mf_name DESC LIMIT 0, 10


AT THE END, AFTER I CHANGE ID 872 TO MAKE IT: 42 NOW IT SHOW THIS MESSAGE:


JUser: :_load: Unable to load user with ID: 872

WHAT WOULD YOU RECOMMEND I DO?

PLEASE HELP! MY LINK: recordarte.turismonegocios.biz

(I'VE SENT YOU MY LOGIN INFO EARLIER IN A REPORT TO MODERATOR)

IN ADVANCE THANKS!

P.S: all messages appear when I put the site and backend in spanish.

I JUST SENT MY NEW LOGIN INFO I FORGOT I'VE CHANGE IT BEFORE.

Recently some guys from Netherlands and Germany had such problem. They had to create tables in database manually. Basically you create table with same structure but with _es_es suffix in name

so you copy

virtuemart_categories to virtuemart_categories_es_es

Also google virtuemart_categories_es_es' doesn't exist there are few more sites with instructions.