VirtueMart Forum

VirtueMart 2 + 3 + 4 => Language/Translations => Topic started by: Jinxed on October 12, 2012, 10:37:24 AM

Title: Switching from english to croatian, products not displayed
Post by: Jinxed on October 12, 2012, 10:37:24 AM
I have installed official joomla 2.5 Croatian language pack from here:
http://joomlacode.org/gf/project/jtranslation1_6/frs/?action=FrsReleaseBrowse&frs_package_id=5825 (http://joomlacode.org/gf/project/jtranslation1_6/frs/?action=FrsReleaseBrowse&frs_package_id=5825)

Than I have changed default site language in administration to Croatian. At that point, all categories from "VirtueMart Categories Layout" that I had displayed on the front-page until now have disappeared. When I switch back to English, all categories are listed again.

So I thought it's because I'm still missing virtuemart Croatian language file. I went and downloaded it from here:
http://gruz.org.ua/virtuemart-language-files.html (http://gruz.org.ua/virtuemart-language-files.html)

After installation, still nothing. Is it some mistake in the core joomla croatian language file, or have I messed something up?

Ok, I have also noticed this in my virtuemart admin right now:
vmError: exeSortSearchListQuery Table 'bacohr_baza.xyk1e_virtuemart_categories_hr_hr' 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 `xyk1e_virtuemart_categories_hr_hr` l JOIN `xyk1e_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `xyk1e_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

I have been filling filling in products while working with english as default language, don't tell me I'll have to mess with database to switch all products to croatian or something.
Title: Re: Switching from english to croatian, products not displayed
Post by: jjk on October 12, 2012, 19:06:32 PM
Probably the same problem and solution as mentioned here:
http://forum.virtuemart.net/index.php?topic=108708.msg363891#new (http://forum.virtuemart.net/index.php?topic=108708.msg363891#new)
Title: Re: Switching from english to croatian, products not displayed
Post by: Jinxed on October 12, 2012, 22:52:17 PM
Quote from: jjk on October 12, 2012, 19:06:32 PM
Probably the same problem and solution as mentioned here:
http://forum.virtuemart.net/index.php?topic=108708.msg363891#new (http://forum.virtuemart.net/index.php?topic=108708.msg363891#new)

So, basically, I should enable croatian in virtuemart administration and export all content from en-GB vm tables to hr-HR tables? I mean, that will do the trick right?
Title: Re: Switching from english to croatian, products not displayed
Post by: jjk on October 12, 2012, 23:25:08 PM
First you should check if your content actually is in the en-GB tables. If yes, you can export (check "Add drop table" in the export view of phpMyadmin) each individual en-GB SQL table (i.e. xxxxx_virtuemart_products_en_gb), change the suffix from en_gb to hr_hr, then open the SQL file with an editor like i.e Notepad++ and change all 'en_gb' in the file to 'hr_hr'. After that you can import the file into your existing (empty) hr-HR table.
Title: Re: Switching from english to croatian, products not displayed
Post by: Kongzi on September 05, 2013, 00:54:09 AM
Quote from: jjk on October 12, 2012, 23:25:08 PM
First you should check if your content actually is in the en-GB tables. If yes, you can export (check "Add drop table" in the export view of phpMyadmin) each individual en-GB SQL table (i.e. xxxxx_virtuemart_products_en_gb), change the suffix from en_gb to hr_hr, then open the SQL file with an editor like i.e Notepad++ and change all 'en_gb' in the file to 'hr_hr'. After that you can import the file into your existing (empty) hr-HR table.

Hello, I use your solution but have bugs now, I post here new topic : http://forum.virtuemart.net/index.php?topic=118456.0 (http://forum.virtuemart.net/index.php?topic=118456.0)

Could you help me please ?

Thanks,

All the best