Форуми / Cotonti / Extensions / Comlist - Commented resources list for Siena

Generates commented resources list

foxhound
#39011 17.01.2014 23:33

I am trying to use this plugin but it keeps giving me errors, like this:

SQL error 42000: Syntax error or access violation: 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 'As pl ON c.com_code=pl.poll_id AND c.com_area = 'polls' #0 cot_diefatal(SQL error 42000: Syntax error or access violation: 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 'As pl ON c.com_code=pl.poll_id AND c.com_area = 'polls') called at [D:\Dropbox\Xampp\htdocs\site\system\database.php:568] #1 CotDB->query(SELECT c.com_id, c.com_code, c.com_area, c.com_date as com_maxdate, c.com_author, c.com_authorid, c.com_text, p.*, pl.*, (SELECT COUNT(*) FROM cot_com AS ccc WHERE ccc.com_code = c.com_code) AS com_count FROM cot_com AS c LEFT JOIN cot_pages As p ON c.com_code=p.page_id AND c.com_area = 'page' AND p.page_state='0' LEFT JOIN As pl ON c.com_code=pl.poll_id AND c.com_area = 'polls' WHERE c.com_date = (SELECT MAX(com_date) FROM cot_com AS cc WHERE c.com_code = cc.com_code GROUP BY cc.com_area) AND com_area IN ('news') GROUP BY c.com_area, c.com_code ORDER BY com_maxdate DESC LIMIT 0, 5) called at [D:\Dropbox\Xampp\htdocs\site\plugins\comlist\comlist.global.php:110] #2 comlist(comlist, 5, com_maxdate DESC, , news, , TRUE, pcl) #3 call_user_func_array(comlist, Array ([0] => comlist,[1] => 5,[2] => com_maxdate DESC,[3] => ,[4] => news,[5] => ,[6] => TRUE,[7] => pcl)) called at [D:\Dropbox\Xampp\htdocs\site\system\cotemplate.php:1675]

I am getting the idea the problem is with how this plugin works with the poll comments, but I have no idea what needs to change and how. Maybe the author is still around and can take a look or maybe someone else knows how to fix this?
<img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />