web design, England, Britain, UK, belgium
 
Ulti Clocks content

Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0

GJC Web Design Joomla & VirtueMart how to, tips, tricks, coding examples, html, php, tutorial, 101, useful hints, help

A collection of help articles and coding examples for Joomla & Virtuemart

Belgium, VirtueMart & Joomla Web Design England UK Britain & Germany

Joomla, VirtueMart, how to, tips, tricks, coding examples, html, php, tutorial, 101, useful hints, help 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

Thu

09

Apr

Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0

  • 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
Digg! Reddit! Del.icio.us! Mixx! Free and Open Source Software News Google! Live! Facebook! Slashdot! Technorati! StumbleUpon! Spurl! Newsvine! Furl! Fark! Yahoo! Netvouz! Mister-Wong! RawSugar! Ma.gnolia! Squidoo! DZone! Swik!
Last Updated on Wednesday, 24 June 2009 09:09 Read : 23284 times
 
Comments (52)
thanks!
52 Thursday, 10 June 2010 14:41
Rolf
This helped me a lot! Thank you!
@Matamort
51 Friday, 28 May 2010 15:07
(GJC Admin)
Yes, for a small fee..
Contact thru the contact page...

Cheers
No wysiwyg for vendor information
50 Friday, 28 May 2010 13:22
Matamort
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 ?
DB error
49 Friday, 21 May 2010 07:51
Anni
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
Forget my case
48 Thursday, 20 May 2010 15:35
Still Flo
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
Problem with product titles
47 Thursday, 20 May 2010 15:29
Flo (again)
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?
Thanks, thanks and again THANKS
46 Thursday, 20 May 2010 15:20
Flo
Wow, really good tutorial! You're definitely going up to heaven for this! I LOVE YOU!!!!
thanks
45 Saturday, 27 March 2010 10:49
mat
good tuto simple ! easy ! it works, keep it in book marks
@Freelancelot
44 Wednesday, 24 March 2010 21:09
(GJC Admin)
Hi,
Contact me thru the contact page if you need help.

Cheers,
Thanks, but products are still not translating
43 Wednesday, 24 March 2010 19:34
Freelancelot
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
Shiping module missing
42 Wednesday, 10 March 2010 16:22
Dutchie
I can't translate the shipping
Thanks
41 Thursday, 25 February 2010 10:47
Cook
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?
@Philip
40 Tuesday, 23 February 2010 15:18
GJC (admin)
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..
Step 3 - what is it exactly?
39 Tuesday, 23 February 2010 15:08
Philip
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!
thanks a lot!!
38 Thursday, 18 February 2010 08:52
pablo
Finally I've got joomfish+virtuemart working in php4.

Thanks for your tutorial.

greets
Thank you
37 Tuesday, 16 February 2010 12:56
Roderick
Thank you very much for this solution, it works great on joomla 1.5.15 and virtuemart 1.14.

Great fix
Great
36 Friday, 12 February 2010 21:56
rainbow
Many thanks for this excellent guide
it solved my problems
35 Friday, 12 February 2010 16:18
darek
thx so much
see joomfish in action

Mr. Green
A thousand Thank you
34 Thursday, 04 February 2010 12:20
Siraset Jirapatchandej
A thousand Thank you
Sincerely great!
33 Tuesday, 02 February 2010 20:13
Patin
Thank you for this superb tutorial!!!!!
Ukranian
32 Friday, 15 January 2010 08:38
GJC (admin)
Manually, and then don't forget to send it to VM to include in there next pack release...
help
31 Thursday, 14 January 2010 23:28
hi
I from ukranian. how i can translete VirtueMart , on UKR. This Language Pack without ukranian.
.
30 Thursday, 14 January 2010 23:27
help
I from ukranian. how i can translete VirtueMart , on UKR. This Language Pack without ukranian.
Crying or Very Sad
Thanks
29 Saturday, 09 January 2010 12:13
Sasha Ukr
Thanks
vm_state
28 Thursday, 07 January 2010 13:15
lefty
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!
joomfish help request
27 Thursday, 24 December 2009 03:17
thambi
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
thanksgiving
26 Friday, 18 December 2009 00:02
pegazoo
Hey Mate! You saved my life. Thanks!Smile
not working with module breadcrumbs"you are here"
25 Tuesday, 01 December 2009 14:31
Artur
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.
Thanks!
24 Monday, 30 November 2009 19:53
DarkLord
Hey... you are the ONE! thank you very much i owe you MAN.
thanks
23 Saturday, 14 November 2009 11:53
rey
thanks dude, your tutorial is great, i oew you one man!
Good work
22 Sunday, 08 November 2009 15:05
Mamboman
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
21 Friday, 30 October 2009 16:51
Taavi
Cant upload VirtueMart Content Elements. FTP dont upload them, can anybody know whats the issue?
Product attributes not translated
20 Monday, 19 October 2009 19:17
Patrick
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.
You ROCK!
19 Monday, 19 October 2009 10:39
Midnightman
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
18 Sunday, 18 October 2009 09:19
Irfan khan
Joomfish not working on server properly with virtuemart
THANKS!!
17 Thursday, 15 October 2009 17:00
Christian
very helpful!!!
Thanks
16 Thursday, 08 October 2009 18:13
Antonio Cortés
Thanks from Chile!
Thank you!
15 Friday, 02 October 2009 11:27
Csaba
Thak you! It's relay helpful, saved a lot of time for me!
?? ?????
14 Monday, 28 September 2009 16:36
???????
??????? ?? ?????! ?????? ? ??? ????????!
Fantastic and simple
13 Monday, 21 September 2009 19:09
Chris Watts
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!
great
12 Saturday, 19 September 2009 17:27
Frank
Really helpfull. Thank you so much Smile
Thanks for your great article!
11 Saturday, 19 September 2009 05:33
Albert Wang
Thanks for your great article, it's a life saver!
Great, exellent!
10 Monday, 14 September 2009 09:37
o.u.
Simple and clear. Saved my day. Thank you!
Rookie Developer
9 Tuesday, 11 August 2009 23:56
Bench Rider
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?
Rookie Developer
8 Tuesday, 11 August 2009 23:09
Bench Rider
Thanks Coach!
Thank you very much
7 Sunday, 09 August 2009 14:43
Geeforce
Saved me hours too.

Thought it should work out of the box.

Great tutorial.
Checkout works?
6 Monday, 20 July 2009 12:53
Thomas
Hey Tom,
I have the problem with checkout, too. What was the error in detail?
Follow up on Checkout Button
5 Tuesday, 23 June 2009 05:21
Tom
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
Checkout Button not worki
4 Monday, 22 June 2009 22:25
Tom
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?
Thank you
3 Tuesday, 26 May 2009 14:40
Lp
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.
Bookmark
2 Thursday, 07 May 2009 07:01
GJC (admin)
Glad to help, please social bookmark for others to find..

Cheers
Thanks
1 Thursday, 07 May 2009 02:19
anon
this saved hours! Great simple tutorial!

Add your comment

BoldItalicUnderlineStrikethroughSubscriptSuperscriptEmailImageHyperlinkOrdered listUnordered listQuoteCodeHyperlink to the Article by its id
Very HappySmileWinkSadSurprisedShockedConfusedCoolLaughingMadRazzEmbarrassedCrying or Very SadEvil or Very MadTwisted EvilRolling EyesExclamationQuestionIdeaArrowNeutralMr. GreenGeekUber Geek
Your name:
Subject:
Comment:

Latest Articles

Paypal Donation

If you use this module on your site please donate a small amount.
Any donation amount appreciated.

VM Live Product Search

Recommended Reading

For those interested in extending there knowledge of Joomla! & VirtueMart Packt Publishing has an excellent range of help & how to books.
Listed below are some I can recommend.
Simply click on the images to be taken directly to their web shop.

Learning Joomla! 1.5 Extension Development Learning Joomla! 1.5 Extension Development
by Joseph L. LeBlanc.
Read the review
Joomla! E-Commerce with VirtueMart Joomla! E-Commerce with VirtueMart
by Suhreed Sarkar.
Read the review
Joomla! Web Security Joomla! Web Security
by Tom Canavan.

Mastering Joomla! 1.5 Extension and Framework Development Mastering Joomla! 1.5 Extension and Framework Development
by James Kennard.

Joomla! Template Design: Create your own professional-quality templates with this fast, friendly guide Joomla! Template Design: Create your own professional-quality templates with this fast, friendly guide
by Tessa Blakeley Silver.

GJC Web Design Joomla & VirtueMart how to, tips, tricks, coding examples, html, php, tutorial, 101, useful hints, help

A collection of help articles and coding examples for Joomla & Virtuemart

Belgium, VirtueMart & Joomla Web Design England UK Britain & Germany

Joomla, VirtueMart, how to, tips, tricks, coding examples, html, php, tutorial, 101, useful hints, help



Joomla 1.5, VirtueMart 1.1 & Joomfish 2.0



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