Ulti Clocks content

Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0

JOOMLABOTTOM sand Information on the installation of Joomfish 2.0 with Joomla 1.5 & VirtueMart 1.1
joomfish, virtuemart, store, joomla, pack, xml, components, root, administrator, vendor, attribute, sku, contentelements, table, try, don, query, available, translate, files, work, field, needed, info, elements, product, jos, auto, increment, content, alter, upload, ftp, change, course, package, language, languages, object, uploaded

Home

Joomla - VirtueMart

Joomla & VM How To's

Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0

Don

09.

Apr

Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0

Prev << Using the VitueMart 1.1 Popup (vmPopupLink function)		Next >> Allow html formatting in VirtueMart's "Terms of Service"

Joomla 1.5
VirtueMart 1.1
Joomfish 2.0

There is a lot of confused posts about how to enable Joomfish 2.0 compatibility with Joomla 1.5 & VirtueMart 1.1
Here (hopefully) are the steps and files needed to get these 3 components to work together.

Joomfish Logo

First make sure you have the latest versions of each package, Joomfish especially has had a number of bug fixes, the current version is Joomfish 2.03.

Of course your required languages should be installed via the installer.

Upload via ftp the VirtueMart language pack to
joomla_root/administrator/components/com_virtuemart/languages
You can get them here -
Language Pack for VirtueMart 1.1.3
Just extract the package and upload the whole resulting folder structure.

One database table needs to alter to conform with the Joomfish schema so you need to run the following query.
The easiest way is to simply paste the query into your phpMyAdmin SQL tab and click "Go".
It adds another field auto-increment field to the jos_vm_product_attribute_sku table.
```
 
ALTER TABLE `jos_vm_product_attribute_sku` 
ADD `attribute_sku_id` INT( 11 ) 
NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;
 
```
You then need the VirtueMart Content Elements for Joomfish which you can find here -
VirtueMart Content Elements for Joomfish 2.0 or here.
The 2nd local one has the needed changes to the vm_store_info.xml / vendor.xml file done (See below).
Don't try to use the virtuemart.zip available on the joomlacode site. This is for Joomfish 1.8.
Unzip the pack and ftp the files to joomla_root/administrator/components/com_joomfish/contentelements

It should all work now apart from the VirtueMart Store Information which when you try to translate gives a
"Fatal error: Call to a member function getTable() on a non-object".

To fix this you need to rename the joomla_root/administrator/components/com_joomfish/contentelements/vm_store_info.xml to vm_vendor.xml.
Why this has never been done in the original pack I don't know.
You could of course do this before you uploaded them.
You can download the pack with the change done from here. Joomfish Virtuemart translate

While your there if you need to have a different Store Name then change line 10 of joomla_root/administrator/components/com_joomfish/contentelements/vm_vendor.xml to -

 
<field type="titletext" name="vendor_name" 
translate="0">Store Name</field>
to...
<field type="titletext" name="vendor_name" 
translate="1">Store Name</field>

So all fields should now be available in the Joomfish --> Translate section.

Add this page to your favorite Social Bookmarking websites

Zuletzt aktualisiert am Mittwoch, 24. Juni 2009 um 09:09 Uhr Read : 26039 times

» Using php globals in FaclieForms / Breezing Forms

» Pass a field to another field in Breezing Forms

» A Joomla Module to show SOBI2 Category Descriptions - SOBI2 Show Category Descriptions

» e-go.com.au VirtueMart Shipping Module released today

» e-go.com.au Shipping Module for VirtueMart 1.1

Comments (52)

This helped me a lot! Thank you!

Yes, for a small fee..
Contact thru the contact page...

Cheers

Really great Tuto ! I finally manage my translation. Nut i found out that the wysiwyg is not working when you want to translate Vendor information.

Could you help me out ?

Hi,
First of all great manual thanks! I did everything as you wrote but when I go in to my site I get the following error:
Database Error: Unable to connect to the database:Could not connect to MySQL

Does anyone knoe what this is? How I can fix it? and what went wrong.
Thanks in advance
Anni

Found the error - I'm using the "wrong versions". It's Joomfish 2.0.4 and Virtuemart 1.1.4. My fault. Sorry for bothering you... Delete my postings - but keep the 1st one! Wink

Hi, it's me again. Unfortunately are the Product tiles translated, but the translation isn't shown in the frontend. It always shows the original product title. What might i have done wrong?

Wow, really good tutorial! You're definitely going up to heaven for this! I LOVE YOU!!!!

good tuto simple ! easy ! it works, keep it in book marks

Hi,
Contact me thru the contact page if you need help.

Cheers,

I've done all the workarounds for this including editing the database table, but still not luck being able to translate products, etc in VM. I get the ".../public_html/administrator/components/com_joomfish/models/ContentObject.php on line 669" error message. I've looked all over the net and still have no working solution for my client who desperately needs Spanish working for her VM products. TIA for any assistance.

Here's my system info:
PHP 5.2.9
Joomla 1.5.15
VirtueMart 1.1.4
JoomFish 2.04

I can't translate the shipping

Works great, but i have a small problem. As you can see here : http://www.ktirio59.com/index.php?page=shop.browse&category_id=6&option=com_virtuemart&Itemid=1&lang=en the name of the product ????? 1 which means Door 1 in Greek is not translated but when you focus in it : http://www.ktirio59.com/index.php?page=shop.product_details&flypage=flypage.tpl&product_id=1&category_id=6&option=com_virtuemart&Itemid=1&lang=en everythig is OK. Can anyone help me?

You need to add a new field to your database table ALTER TABLE `jos_vm_product_attribute_sku` .
This field needs to be called
`attribute_sku_id`.

You can do this manually or by a SQL statement, whatever..

Hi,

thanks a lot for your help on this problem.

I have an issue with this step

One database table needs to alter to conform with the Joomfish schema so you need to run the following query.
The easiest way is to simply paste the query into your phpMyAdmin SQL tab and click "Go".
It adds another field auto-increment field to the jos_vm_product_attribute_sku table.

What exactly does it mean? Do I have to change a line somewhere??

Thank you!

Have a nice day!

Finally I've got joomfish+virtuemart working in php4.

Thanks for your tutorial.

greets

Thank you very much for this solution, it works great on joomla 1.5.15 and virtuemart 1.14.

Great fix

Many thanks for this excellent guide

thx so much
see joomfish in action
www.piekloniebo.pl/kolczyki
Mr. Green

A thousand Thank you

Thank you for this superb tutorial!!!!!

Manually, and then don't forget to send it to VM to include in there next pack release...

I from ukranian. how i can translete VirtueMart , on UKR. This Language Pack without ukranian.

I from ukranian. how i can translete VirtueMart , on UKR. This Language Pack without ukranian.
Crying or Very Sad

Thanks

I am trying to edit the file vm_country.xml and change it to vm_state.xml, but although i can see the translations on the backend on joomfish on the frontend in the register new user form the states list remains the same.Has anyone found a solution on how to translate states in virtuemart? Please help!

hi, installed joomfish with virtuemart, for some reason vm product contents did not transalate, then uninstalled joomfish, but my storage space sky rocketed from 70MB to 140MB. even after uninstall stays at 140MB and the hosting provider demanding double fees. anyone to help me pls. so thankful
regds
thambi
singapore

Hey Mate! You saved my life. Thanks! Smile

Thanks for help. Everything working ok but when i am trying go back using module breadcrumbs i have a message: "Not Found
The requested document was not found on this server. web is www.fzb.com.ua. Change language to eng , see bottom.

Hey... you are the ONE! thank you very much i owe you MAN.

thanks dude, your tutorial is great, i oew you one man!

The guide is great, simple concise. My Store infos still do not display in English, but the backend now says that they are published. Will check the IDs in the DB.

Mamboman

Cant upload VirtueMart Content Elements. FTP dont upload them, can anybody know whats the issue?

Hi,

I have installed the VM Content Elements and added some advanced attributes.

When I want to add the translations in the backend (VM products attributes SKU) I get the error message 'Unknown column c.attribute_sku_id in field list ...'. The field attribute_sku_id doesn't exist in the table jos_vm_product_attribute_sku, so the error message seems logic.

Then I have added the alter table statement as shown in the article above. But my attributes still aren't translated.

In the backend I can open the translations for attribute_sku but allways the same record is opened and I can't save the translations.

I urgently need a solution for this frustrating problem.

Thanks a lot for this fantastic tutorial. I was starting to fear that I wouldn't be able to use JoomFish & VirtueMart together, but now I can. I applied your hacks, and it all seems to work just fine now.

Seriously, hundreds of work hours are not wasted after all, thanks to you. Mr. Green

Joomfish not working on server properly with virtuemart

very helpful!!!

Thanks from Chile!

Thak you! It's relay helpful, saved a lot of time for me!

??????? ?? ?????! ?????? ? ??? ????????!

Thanks for keeping it simple and precise for a complete non-technical Joomla user like me who totally relies on people taking the time to do these idiot proof guides!

Really helpfull. Thank you so much Smile

Thanks for your great article, it's a life saver!

Simple and clear. Saved my day. Thank you!

I want to the User Fields and variations of buttons in Virtuemart to be multilingual too. This is actually more important to me than anything else. This was a pretty thorough tutorial am I missing something?

Thanks Coach!

Saved me hours too.

Thought it should work out of the box.

Great tutorial.

Hey Tom,
I have the problem with checkout, too. What was the error in detail?

Checkout button is working fine! Turns out that it is one single bit error in a full page of double-byte translation text. GJC ... thanks for the great work and instructions. It's good people like you making the Net a better place! Wink

Thanks for the great instructions. I follow all the instructions and can get multilingual working in most pages except the Checkout Button which only works in English. Any idea, what goes wrong?

i've been searching for a multilingual CMS + shop extension for so long. I'm glad to finally find out that simple solution for Virtuemart.

Glad to help, please social bookmark for others to find..

Cheers

this saved hours! Great simple tutorial!

Add your comment

Your name:

	The word for verification. Lowercase letters only with no spaces.
Word verification:

Titel:

Comment:

yvComment v.1.21.0

Latest Articles

Using php globals in FaclieForms / Breezing Forms
Donnerstag, 27. Mai 2010Views: 1256

Here is how to use global php variables in your Breezing Forms / FacileForms form....
Pass a field to another field in Breezing Forms
Donnerstag, 27. Mai 2010Views: 1311

Pass a field to another field in Breezing Forms with Javascript...
A Joomla Module to show SOBI2 Category Descriptions - SOBI2 Show Category Descriptions
Montag, 03. Mai 2010Views: 1692

A Joomla Module to show SOBI2 Category Descriptions on any page in conjunction with the SOBI2 items - SOBI2 Show Category Descriptions...
e-go.com.au VirtueMart Shipping Module released today
Freitag, 19. Februar 2010Views: 2416

We have built a VirtueMart 1.1 e-go Australia's #1 Cheap Courier & Freight Service that fully integrates and shows real time quotations based on vendor and customer post...
e-go.com.au Shipping Module for VirtueMart 1.1
Freitag, 19. Februar 2010Views: 3367

We have built a VirtueMart 1.1 e-go Australia's #1 Cheap Courier & Freight Service that fully integrates and shows real time quotations based on vendor and customer post...
How to embed fonts in Flash
Montag, 15. Februar 2010Views: 2215

How to embed fonts in Flash. Help for the Flash Nifties XML Flash Gallery....
A Joomla 1.5 Plugin to insert the rel="nofollow" attribute within outgoing links updated
Samstag, 13. Februar 2010Views: 2510

A Joomla 1.5 Plugin to insert the rel=nofollow attribute within outgoing links updated. Now has the ability to exclude chosen authors from having a nofollow link....
A Joomla Module to show SOBI2 Category Contents - SOBI2 Show Category updated
Mittwoch, 10. Februar 2010Views: 3034

A Joomla Module to show SOBI2 Category Contents - SOBI2 Show Category updated...
Enable VirtueMart Paypal Notifications when Administrator folder is htaccess protected
Samstag, 06. Februar 2010Views: 3628

Enable VirtueMart Paypal Notifications when Administrator folder is htaccess protected...
Joomla 1.5 nofollow Plugin updated to include new window attribute
Montag, 25. Januar 2010Views: 2929

Joomla 1.5 nofollow Plugin updated to include selectable new window attribute, the target=_blank tag....
SOBI2 Show Category Contents module finally released
Donnerstag, 21. Januar 2010Views: 2428

A Joomla Module to show SOBI2 Category Contents - SOBI2 Show Category items in any module position....
A Joomla Module to show SOBI2 Category Contents - SOBI2 Show Category
Freitag, 08. Januar 2010Views: 9657

A Joomla Module to show SOBI2 Category Contents - SOBI2 Show Category items in any module position....
Joomlaxi Captcha 1.0 Released
Mittwoch, 30. Dezember 2009Views: 2880

...
No menus appear for mod_product_categories VirtueMart
Sonntag, 27. Dezember 2009Views: 3322

No menus appear for mod_product_categories VirtueMart. You install your VirtueMart mod_product_categories to have a nice drop down or flyout VirtueMart Categories menus...
New Joomla Show Images Module released
Sonntag, 20. Dezember 2009Views: 3240

New Joomla Show Images Module released. Shows a series of images with captions and links from a folder....
A Joomla Module to show images from a folder - Show Images
Sonntag, 20. Dezember 2009Views: 10773

A Joomla Module to show images from a folder - Show Images...
Disappearing text in Breezing Forms / FacileForms text area when clicked
Mittwoch, 16. Dezember 2009Views: 3170

Disappearing text in Breezing Forms / FacileForms text area when clicked. It is useful to have some information text in the Breezing Forms / FacileForms text areas or t...
Pre filled text boxes with Breezing Forms / FacileForms
Mittwoch, 16. Dezember 2009Views: 3430

Pre filled text boxes with Breezing Forms / FacileForms. Here is how to have the username and email address automatically entered in your Breezing Forms / FacileForms f...
How to pass a Joomla variable to a Plugin Breezing Forms / FacileForms Form
Dienstag, 15. Dezember 2009Views: 4214

How to pass a Joomla variable to a Plugin Breezing Forms / FacileForms Form. It is often useful to have dynamic information in your Breezing Forms / FacileForms form es...
Separate links for Briask ImageSlideShow module images Part 2
Montag, 14. Dezember 2009Views: 3127

How to link any Joomla ImageSlideShow module images to any url. The Joomla ImageSlideShow module from briask.com is an excellent and simple image gallery which shows an...
Separate links for Briask ImageSlideShow module images
Sonntag, 13. Dezember 2009Views: 3757

How to get separate links for ImageSlideShow module images. The ImageSlideShow module from briask.com is an excellent and simple image gallery which shows any images fr...
Wrong currency symbol shown in VirtueMart Paypal checkout
Donnerstag, 10. Dezember 2009Views: 3368

Wrong currency symbol shown in VirtueMart Paypal checkout. How to fix the wrong currency symbol in the VirtueMart 1.1 Paypal checkout....
Disable Joomla php error reporting with @ (at) symbol
Montag, 07. Dezember 2009Views: 3602

Disable Joomla php error reporting with @ (at) symbol....
Change the VirtueMart Currency Symbols for Multi-Currency
Donnerstag, 03. Dezember 2009Views: 4981

How to change the VirtueMart Currency Symbols for a Multi-Currency Shop....
Select VirtueMart Currency By Language
Dienstag, 01. Dezember 2009Views: 3915

VirtueMart currency selected by chosen language. How to force the VirtueMart currency to be selected by the chosen VirtueMart language....
Joomla & VirtueMart How To's by RSS Feed
Sonntag, 29. November 2009Views: 417

We at GJC Web Design are pleased to announce that all our tips and how to's are available by RSS feed....
How to Customize the VirtueMart Home Page (Shop Page)
Samstag, 28. November 2009Views: 5684

How to Customize the VirtueMart Home Page (Shop Page). How to provide a more interesting VirtueMart Front Page....
VirtueMart 1.1 Product Reviews message when not logged in
Samstag, 14. November 2009Views: 2816

If your using JoomlaWorks Tabs for your VirtueMart product pages and a separate tab for adding a product review, if your not logged in the tab is just blank. Here's ho...
How to show correct modules on ccNewsletter thank you pages
Mittwoch, 04. November 2009Views: 3087

How to show correct modules on ccNewsletter thank you pages. If you have different module layouts on different pages the thank you and other acknowledgement messages (s...
How to add the VirtueMart Breadcrumbs to the Browse Pages
Dienstag, 27. Oktober 2009Views: 6734

How to add the VirtueMart Breadcrumbs to the Browse Pages. Adding the Virtuemart Breadcrumbs to your Browse pages is not native to Virtuemart. Here are the steps and f...