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 '' at line 2
annihillator |
|
---|---|
I finally got my forums back up after I realised what was wrong. But now when I go to view a forum I get this:
Fatal error: 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 '' at line 2
#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 '' at line 2) called at [/home/crazyfor/public_html/system/database.php:436]
#1 CotDB->query(SELECT t.* , p.poll_id, p.poll_type FROM cot_forum_topics AS t LEFT JOIN cot_polls AS p ON t.ft_id=p.poll_code
WHERE ft_cat='general' AND (poll_type='forum' OR poll_id IS NULL) ORDER BY ft_sticky DESC, ft_updated desc LIMIT 0, ) called at [/home/crazyfor/public_html/modules/forums/inc/forums.topics.php:242]
#2 include(/home/crazyfor/public_html/modules/forums/inc/forums.topics.php) called at [/home/crazyfor/public_html/forums.php:39]
Added 39 seconds later: Fatal error: 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 '' at line 2 #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 '' at line 2) called at [/home/crazyfor/public_html/system/database.php:436] #1 CotDB->query(SELECT t.* , p.poll_id, p.poll_type FROM cot_forum_topics AS t LEFT JOIN cot_polls AS p ON t.ft_id=p.poll_code WHERE ft_cat='general' AND (poll_type='forum' OR poll_id IS NULL) ORDER BY ft_sticky DESC, ft_updated desc LIMIT 0, ) called at [/home/crazyfor/public_html/modules/forums/inc/forums.topics.php:242] #2 include(/home/crazyfor/public_html/modules/forums/inc/forums.topics.php) called at [/home/crazyfor/public_html/forums.php:39]
Added 40 seconds later: What can I do to resolve the problem? |