Joomla! Discussion Forums



It is currently Thu Nov 26, 2009 10:49 am (All times are UTC )

 




Post new topic Reply to topic  [ 12 posts ] 
Author Message
Posted: Mon Dec 19, 2005 5:16 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Sep 27, 2005 2:52 pm
Posts: 21
Hi!

Is it possible to ve multilanguage content in virtuemart? So that when i change the language also the discription can be translated?

Thanks for help!


Last edited by doom4 on Mon Dec 19, 2005 6:36 pm, edited 1 time in total.

Top
   
 
Posted: Mon Dec 19, 2005 5:42 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 5:23 pm
Posts: 553
Location: Gogledd Cymru
You could take a look at

http://forum.joomla.org/index.php/topic,8785.0.html

I am working with Akede on getting this (or equivalent functionality) into the next official release of the Fish - hopefully to go with Joomla 1.1.

Geraint

p.s. You'll need the contentelement files I am attaching to this message


You do not have the required permissions to view the files attached to this post.

_________________
email: opensourcematters at copynDOTplusDOTcom


Top
  E-mail  
 
Posted: Mon Dec 19, 2005 6:37 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Sep 27, 2005 2:52 pm
Posts: 21
thanks! is working great


Top
   
 
Posted: Fri Jan 06, 2006 1:22 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Aug 21, 2005 7:37 pm
Posts: 7
Back again..

It was working great, but after some translating products and product categories it isn't anymore.

Translations in Viruemart are not visible in the frontpage anymore.
It only shows my default language in the shop (English) as there is no translation at all. Grmbl
Now I'm stuck. Hope someone can give me a hint what causes this behaviour.

When looking for the cause I also found that it is unposible to translate product attributes and serial attributes. Has this a relationship with my first problem?  It gives this error:

DB function failed with error number 1054
Unknown column 'c.id' in 'field list' SQL=SELECT c.id, c.attribute_name, c.attribute_value as title, c.attribute_value, mbfc.id as mbfc_id, mbfc.value as titleTranslation, mbfc.modified as lastchanged, mbfc.published as published, mbfc.language_id, mbfl.name as language FROM jos_vm_product_attribute as c LEFT JOIN jos_mbf_content as mbfc ON c.id=mbfc.reference_id AND mbfc.reference_field='attribute_value' AND mbfc.reference_table='vm_product_attribute' AND mbfc.language_id=1 LEFT JOIN jos_mbf_language as mbfl ON mbfc.language_id=mbfl.id ORDER BY c.attribute_value LIMIT 0, 30


Top
   
 
Posted: Fri Jan 06, 2006 1:50 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 5:23 pm
Posts: 553
Location: Gogledd Cymru
I didn't have a Product attributes config in the mbf.php file - you could try adding this to it (untested):

Code:
$tempContentElement = array("type" => "contentelement",
  "name" => "VirtueMart Product Attribute ",
  "author" => "GWE",
  "version" => "1.0",
  "description" => "Definition for VirtueMart (Product Attributess)",
  "primarykey" => "product_id",
  "tablename" => "vm_product_attribute");
        $tempContentElement["fields"][]=array("type"=>"referenceid","name" => "product_id","translate" =>"0", "label" => "ID");
        $tempContentElement["fields"][]=array("type"=>"titletext","name" => "attribute_name","translate" =>"0", "label" =>"Name");
        $tempContentElement["fields"][]=array("type"=>"text","name" => "attribute_value","translate" =>"1", "label" =>"Value");

   $phpContentElement[$tempContentElement["tablename"]]=$tempContentElement;

     
   $phpContentElement[$tempContentElement["tablename"]]=$tempContentElement;


I'll have a think about your other problem

Geraint

_________________
email: opensourcematters at copynDOTplusDOTcom


Top
  E-mail  
 
Posted: Fri Jan 06, 2006 2:30 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Aug 21, 2005 7:37 pm
Posts: 7
Geraint wrote:
I didn't have a Product attributes config in the mbf.php file - you could try adding this to it (untested):


Nope, does not work, It keeps saying: Unknown column 'c.id' in 'field list'......
P.s. remove one line:
  $phpContentElement[$tempContentElement["tablename"]]=$tempContentElement;
  $phpContentElement[$tempContentElement["tablename"]]=$tempContentElement;

But for now I'ts not my main problem
Geraint wrote:
I'll have a think about your other problem

Thnx!


Top
   
 
Posted: Fri Jan 06, 2006 4:32 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Aug 21, 2005 7:37 pm
Posts: 7
As it also was not possible to translate Store information and Product Serial Attributes.
I've added these to Virtuemart.mbf.php to make it complete (see attachment)

But, also, this makes no difference..
Store information gives no error, but is unpossible to to publish, Product Serial Attributes gives the known sql error.

Regards Evert


You do not have the required permissions to view the files attached to this post.


Top
   
 
Posted: Sat Jan 07, 2006 11:58 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 5:23 pm
Posts: 553
Location: Gogledd Cymru
Evert

Looking at the product_attribute data in more detail I realised that product_id relates to the id of the product as opposed to a unique id for the attribute.  As a result it is impossible for Mambelfish to translate the content of this table (without a significant rewrite - it would be easier for VirtueMart to add primary index field to this table).  You should therefore remove the extra "vm_product_attribute" portion of the mbf.php file I suggested.  You could try adding $tempContentElement["fields"][]=array("type"=>"text","name" => "attribute","translate" =>"1", "label" => "Attribute"); to the vm_product entry - it translates the attributes in the product detal but I have no idea if it has any consequences after a product is ordered etc - my quick test suggests its all ok (take care with commas etc.)

Store Information should work (assuming this is the vm_vendor table) - I'm not sure which table the Product Serial Attributes relate to.

In terms of your SQL error - do you have a line number? What are you viewing - product detail/module etc?.  I can't see how this query could get constructed (especially before you added the product attributes to the mbf.php file).

Back to original problem (english only on front page) - did you try it with caching off?  Is it a module that's failing?

_________________
email: opensourcematters at copynDOTplusDOTcom


Top
  E-mail  
 
Posted: Sun Jan 08, 2006 1:11 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Aug 21, 2005 7:37 pm
Posts: 7
For the attributes we have a success. I can translate them now.

Store information won't. when I submit the translation in the backend it says "Translation is up to date" (green mark) but it does not show the 'translation' and 'Last modified' date. Also it is not possible to pubish it. (*)

The sql error problem was a stupid mistake. My config.mambelsfish.php was overwritten by the backend configuration!.. Oops.
So Mambelfish wasn't looking at my Virtuemart.mbf.php at all...  Grr
The sql error is gone now.. The problem above still exists

For the original problem:
Ai. also gone. It seems to work right now!
The overwitten config file was the problem. The option "Language configuration" is a dangerous option now.

(*) The translated store info however now shows up.


Top
   
 
Posted: Thu Feb 23, 2006 4:30 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Thu Feb 23, 2006 3:37 pm
Posts: 30
Geraint wrote:
You could take a look at

http://forum.joomla.org/index.php/topic,8785.0.html

I am working with Akede on getting this (or equivalent functionality) into the next official release of the Fish - hopefully to go with Joomla 1.1.

Geraint

p.s. You'll need the contentelement files I am attaching to this message


Hi, I have Joomla 1.0.7 whith Mambelfish 1.5 and VirtueMart 1.0.2
It's possible to tranlate content of VirtueMart and were I need to copy the file "VirtueMart.mbf.zip"


Top
  E-mail  
 
Posted: Thu Feb 23, 2006 5:00 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Sun Aug 21, 2005 7:37 pm
Posts: 7
Using Mambelfish you can!

You can store Virtuemart.mbf.php in /administrator/components/com_mambelfish/contentelements2/
or /administrator/components/com_mambelfish/contentelements/


Top
   
 
Posted: Fri Feb 24, 2006 8:28 am 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Thu Feb 23, 2006 3:37 pm
Posts: 30
flexconcept wrote:
Using Mambelfish you can!

You can store Virtuemart.mbf.php in /administrator/components/com_mambelfish/contentelements2/
or /administrator/components/com_mambelfish/contentelements/


OK thanks.
And the files "changes.zip" posted in "http://forum.joomla.org/index.php/topic,8785.0.html"?

I install in this order the files:
- Add Italian language;
- Install Mambelfish 1.5 component;
- Install Mambelfish module;
- Install Mambelfish searchbot;
- Copy files pach for mambo 4.5.2;
- Copy files pach for joomla 1.0.7;
- Install Virtuemart 1.0.2 componet;
- Install Virtuemart module;
- Install Virtumart searchbot;
- Copy file "VirtueMart.mbf.php" in administrator\components\com_mambelfish\contentelements;

but in mambelfish no changes are available, in the "translation" tab the virtuemart product and other choice are not available.

Wich is the wrongh step?

Thanks


Last edited by calamusid on Fri Feb 24, 2006 8:32 am, edited 1 time in total.

Top
  E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 

Quick reply

 



Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group