Translating Polls in Joomla! using Joomfish

08 Mar

Posted by Anthony, under Tutorials

A lot of people who run multilingual sites on Joomla! have problem with translating polls.
The problem is related to the MySQL driver. If you switch to MySQLi “with i” it works right out of the box. This is the preferred driver for JoomFish. Alternatively you can change the modules/mod_poll/helper.php file a bit:
in getPollOptions function set

Code:

$query = ‘SELECT p.id, p.text’ .
            ’ FROM #__poll_data as p’ .
            ’ WHERE p.pollid = ‘ . (int) $id .
            ’ AND p.text <> “”‘ .
            ’ ORDER BY p.id’;

And it will be working with no problems at all