joomfish translation joomla25 / auto tweet plugin

Hello all,
I wonder about this error when trying to translate sermons(sermon_sermons):
No valid database connection: DB function failed with error number 1054
Unknown column 'c.sermon_scripture' in 'field list' SQL=SELECT c.id, c.sermon_title as title, c.sermon_title, c.sermon_scripture, c.notes, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM j25_sermon_sermons as c LEFT JOIN j25_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='sermon_title' AND jfc.reference_table='sermon_sermons' AND jfc.language_id=1 LEFT JOIN j25_languages as jfl ON jfc.language_id=jfl.lang_id ORDER BY c.sermon_title LIMIT 0, 100

but sermon_speaker & sermon_series is working fine(using joomla2.5.8, joomfish2.5.0 & sermon_speaker4.4.9)
also when trying to translate menus the output is only translation fields with poor CSS & no save,close buttons

another thing I need if there is ability to let sermon speaker work with autotweet_NG it's free and most church websites need it to be free
Thank you in advance.
best wishes,
Michael F

The Joomfish definitions are written for the Joomla 1.5 releases. I didn't know that there is finally a release for Joomla 2.5. I'll have to update the definitions for sure to reflect the database changes. Shouldn't be that hard to do.

I'm already in contact with the guys from Autotweet NG. They will release a new version in January which will support Joomla 3.0 and has a simpler plugin format. As soon as it is available I will write a plugin for it

Joomfish 2.5 seems to be still unavailable for public so I can't do anything. Where did you get it?

edit: Nevermind, found their GitHub repository. I'll have a look at it

Try the attached file. You may have to unzip it and install them as individual files. I didn't figure out how to do a proper archive




Tell me how this works and if you need additional fields available for translation.

The error in the original files comes from the fact that scriptures are now in a separate table and no longer stored as plain text in the sermon table, thus the database query failed. Since they are now automatically translated using Joomla language files, this is no longer needed in the JoomFish definitions.

Dear Thomas,
Merry christmas

Thank you alot for your time... the Joomfish files works fine it solves the problem when translating the sermons... I'll translate them and till you if there is any issue I will face,

But I still can't translate the menu of Sermon speaker, menutype is "Series/Sermons List" :S

God blesses

This is a bug in JoomFish. On line #218 in the file

/libraries/joomfish/translateparams/xml.php

it says "$this->escape" is the problem here.
You can comment out/delete the whole line or just don't escape the output like this
This will fix the issue.