Hi!
I bought this module yesterday.
When I install it in Joomla 2.5.4, the website was error 500.
Please help..
500 - JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND c.access IN (1,1) AND a.state >= 0 AND ( a.publish_up = ' at line 12 SQL=SELECT a.id, a.title, a.introtext, a.fulltext, a.created, a.modified, a.hits, a.alias, DATEDIFF(NOW(), a.created) as datediff, c.id AS category_id, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM i0un9_content AS a INNER JOIN i0un9_categories AS c ON c.id = a.catid LEFT JOIN i0un9_content_rating AS v ON a.id = v.content_id WHERE c.id IN () AND c.access IN (1,1) AND a.state >= 0 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-04-19 05:29:01' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-04-19 05:29:01' ) AND a.language IN ( 'zh-TW' , '*' ) ORDER BY a.created DESC