Hello,
I am using the below query where the cc.title is bilingual. However it cannot be translated.
$query = 'SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access'
. ', cc.accessuserid as accessuserid, cc.owner_id as owner_id '
. ', count(cc.id) as number'
. ' FROM `#__phocagallery_categories` AS cc'
. ' INNER JOIN `#__photos` AS a ON cc.id = a.catid'
. ' WHERE cc.published = 1'
. ' AND cc.approved = 1'
. ' AND a.published = 1'
. ' GROUP BY cc.id'
. ' ORDER BY cc.id DESC'
. ' LIMIT 100';
After some trial-and-errors, I found that the title can be translated successfully if I replace "count(cc.id) as number" with "1 as number".
I am using joomla 3.3.0 and jdiction 1.2.0. When I move the whole module back to my old site (joomla 3.1.5 with jdiction 0.9.9.10), it works. Is it a problem of incompatibility with joomla 3.3.0 or is there a problem with the count() in sql? Thanks!