Forums / Cotonti / Support / 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

annihillator
#1 2011-04-11 12:38

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?

Trustmaster
#2 2011-04-11 15:03

Please check "Maximum topics per page" setting in Admin => Config => forums. What value does it have?

May the Source be with you!
annihillator
#3 2011-04-11 17:35

I can't see a Maximum topics per pages setting in my configuration.

Added 1 minutes later:

I'm using Siena.

Trustmaster
#4 2011-04-11 18:42

That's very strange. Go to Admin => Extensions => Forums and click "Update".

May the Source be with you!
annihillator
#5 2011-04-11 19:20

Thank you so much Trustmaster.  that worked.  Now could you provide a solution to another problem i'm having?  I installed the Paypal Genoa plugin, enabled genoa compatibility, enabled paypal plugin and got "Wrong URL" on every page, no access to site at all.  I deleted the paypal donation directory from ftp and got the error which is visible at http://www.crazygaming.co.tv how can I fix this?

pieter
#6 2011-04-11 19:33

You need to un-install the plugin before delete the directory.

Maybe upload some files of the plugin and see when you can un-install it.

... can we help you ...
annihillator
#7 2011-04-11 19:41

Pieter, Trustmaster you are both legends!  Thank you so much for your help.  I wish this CMF the best of luck, it is (generally) easy to use and has amazing prospects.

 

Thank you for your supprt guys.