transalation problem

Phoca Guestbook - creating guestbooks in Joomla! CMS
vipser
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 23 Jan 2010, 13:47

transalation problem

Post by vipser »

hi all,
i install Phoca Guestbook on my site and i have 2 languages (en, de), i need to change text of Guestbook with languages switch
can any one help om that

regards

vipser
Ronny
Phoca Professional
Phoca Professional
Posts: 211
Joined: 03 Nov 2009, 20:31
Location: Germany
Contact:

Re: transalation problem

Post by Ronny »

Hi vipser,

I think the easiest way to achieve this is using JoomFish (what works great if you want to have a multilingual site; I also have it on mine).

Regards,
Ronny
vipser
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 23 Jan 2010, 13:47

Re: transalation problem

Post by vipser »

hi,
thank for your reply to me
i use joomfish already, but joomfish just translate the tile of guestbook
but us need translate of this list :
Title:
Name:
E-mail:
because this list not translate when i switch between languages

regards

saad
Ronny
Phoca Professional
Phoca Professional
Posts: 211
Joined: 03 Nov 2009, 20:31
Location: Germany
Contact:

Re: transalation problem

Post by Ronny »

Hi Saad,

did you install the Phoca Guestbook Joomfish files?
I'm also using Joomfish with the Phoca Guestbook - and the items you mentioned are translated there, so I don't know where else to look... :idea:

Regards,
Ronny
vipser
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 23 Jan 2010, 13:47

Re: transalation problem

Post by vipser »

I go to component -> joomfish -> translation -> I select language (erman) and select phocaguestbook items.
I get this error message:
DB function failed with error number 1054
Unknown column 'c.user_id' in 'field list' SQL=SELECT c.id, c.catid, c.sid, c.username, c.user_id, c.email, c.homesite, c.ip, c.title, c.content, c.date, c.published, c.checked_out as check_out, c.checked_out, c.checked_out_time, c.ordering, c.params, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language, jfc.reference_id as jfc_refid FROM jos_phocaguestbook_items as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='phocaguestbook_items' AND jfc.language_id=2 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.title LIMIT 0, 20
Warning: Invalid argument supplied for foreach() in /home/*********/public_html/joomlatester/administrator/components/com_joomfish/contentelements/translationSectionFilter.php on line 67
I try to translate phocaguestbook items from manage translations of joomfish, it ends by a blank page

I hope you continue help me.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48726
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: transalation problem

Post by Jan »

Hi, in Phoca Guestbook, there is no column user_id but userid. Maybe the Joom!fish Phoca Guestbook file is not Ok, I have changed it, try to download and install it again.

https://www.phoca.cz/download/category/5 ... t?start=20
Jan
If you find Phoca extensions useful, please support the project
Post Reply