Author Topic: 2.0.24 Problems with different language - clean instalation from Zero.  (Read 3181 times)

lipes

  • Full Member
  • ***
  • Posts: 720
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
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3700
  • using Matomo instead of Google Analytics
Re: 2.0.24 Problems with different language - clean instalation from Zero.
« Reply #1 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.?
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

lipes

  • Full Member
  • ***
  • Posts: 720
Re: 2.0.24 Problems with different language - clean instalation from Zero.
« Reply #2 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
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25