VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Development & Testing => Topic started by: lipes on October 05, 2013, 16:15:10 PM

Title: 2.0.24 Problems with different language - clean instalation from Zero.
Post by: lipes on October 05, 2013, 16:15:10 PM
Hi.
Just to tell that i've created a new instalation (to test the new version 0.24) with a blank joomla configuration too but Portuguese Language and i am getting too many problems to test it.

for example PRODUCTS AREA:
vmError: exeSortSearchListQuery Table 'user_teste.c2xco_virtuemart_products_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `c2xco_virtuemart_products_pt_pt` as l JOIN `c2xco_virtuemart_products` AS p using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 30
vmError: exeSortSearchListQuery Table 'user_teste.c2xco_virtuemart_categories_pt_pt' 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 `c2xco_virtuemart_categories_pt_pt` l JOIN `c2xco_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `c2xco_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

INVENTORY AREA:
vmError: exeSortSearchListQuery Table 'user_teste.c2xco_virtuemart_products_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `c2xco_virtuemart_products_pt_pt` as l JOIN `c2xco_virtuemart_products` AS p using (`virtuemart_product_id`) WHERE ( p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id DESC LIMIT 0, 30

VOTES:
vmError: exeSortSearchListQuery Table 'user_teste.c2xco_virtuemart_products_pt_pt' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS r.*,p.`product_name` FROM `c2xco_virtuemart_ratings` AS `r` JOIN `c2xco_virtuemart_products_pt_pt` AS `p` USING (`virtuemart_product_id`) ORDER BY created_on DESC LIMIT 0, 30

ORDERS AREA:
vmError: exeSortSearchListQuery Table 'user_teste.c2xco_virtuemart_paymentmethods_pt_pt' 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 c2xco_virtuemart_orders as o LEFT JOIN c2xco_virtuemart_order_userinfos as u ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT" LEFT JOIN c2xco_virtuemart_paymentmethods_pt_pt as pm ON o.virtuemart_paymentmethod_id = pm.virtuemart_paymentmethod_id WHERE ( o.virtuemart_vendor_id = "1" ) ORDER BY created_on DESC LIMIT 0, 30

etc... etc.. etc...
there are too many messages (maybe in all VM menus) on top with a Red background
Title: Re: 2.0.24 Problems with different language - clean instalation from Zero.
Post by: jjk on October 05, 2013, 18:52:28 PM
I suppose you did not forget to install and select the portuguese language pack for VM, but do you have portuguese language menus, category names, etc.?
Title: Re: 2.0.24 Problems with different language - clean instalation from Zero.
Post by: lipes on October 07, 2013, 15:57:22 PM
I've didnt installed the joomla example data, but wuth en-gb VM doesnt have same problems..
i just pick the portuguese language files (front and backend) from the old instalation and upload to new instalation folders.

I'll try to see where are the files of portuguese translation package again and check if the problem give the same errors