Hi. I recently purchased JMS and am using it in a combination with Fabrik and JoomFish. Overall, the experience has been quite good. However I'm running into an issue which I believe to be related to JMS.
In Fabrik I have the option to create JoomFish translations for data within tables. Fabrik generates an XML file specific to a table and JoomFish lets me select it as an option to perform translations against the data.
The issue is that I believe JMS is appending the site's table suffix in front of the table, even though it shouldn't be.
JoomFish Error Message on Master Site (table prefix jms_):
DB function failed with error number 1146
Table 'mc_bpjms.jms_fab_countries' doesn't exist SQL=SELECT c.country_id as id, c.country_id, c.country_name as title, c.country_name, c.nationality, 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 jms_fab_countries as c LEFT JOIN jms_jf_content as jfc ON c.country_id=jfc.reference_id AND jfc.reference_field='country_name' AND jfc.reference_table='fab_countries' AND jfc.language_id=1 LEFT JOIN jms_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.country_name LIMIT 0, 20
JoomFish Error Message on Slave Site (table prefix js1_):
DB function failed with error number 1146
Table 'mc_bpjms.js1_fab_countries' doesn't exist SQL=SELECT c.country_id as id, c.country_id, c.country_name as title, c.country_name, c.nationality, 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 js1_fab_countries as c LEFT JOIN js1_jf_content as jfc ON c.country_id=jfc.reference_id AND jfc.reference_field='country_name' AND jfc.reference_table='fab_countries' AND jfc.language_id=1 LEFT JOIN js1_languages as jfl ON jfc.language_id=jfl.id ORDER BY c.country_name LIMIT 0, 20
JoomFish Fabrik Table XML File Contents:
Code: |
<?xml version="1.0" ?>
<joomfish type="contentelement">
<name>Fabrik - Countries</name>
<author>rob@pollen-8.co.uk</author>
<version>1.0 for Fabrik 2.0</version>
<description>Definition for Fabrik Table data - Countries</description>
<reference type="content">
<table name="fab_countries">
<field type="referenceid" name="country_id" translate="0">country id</field>
<field type="titletext" name="country_name" translate="1" length="30">country name</field>
<field type="text" name="nationality" translate="1" length="30">nationality</field>
</table>
</reference>
</joomfish>
|
As you can see, the table name in the db is fab_countries, but in both cases JMS is trying to append the site's prefix. How can I stop this?