cotonti.com : Fatal error: SQL error 42000: Syntax error or access violation: 1064

annihillator

пн, 11 апр 2011 19:41:45 -0000

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.

pieter

пн, 11 апр 2011 19:33:11 -0000

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.

annihillator

пн, 11 апр 2011 19:20:45 -0000

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?

Trustmaster

пн, 11 апр 2011 18:42:44 -0000

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

annihillator

пн, 11 апр 2011 17:35:59 -0000

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

Added 1 minutes later:

I'm using Siena.

Trustmaster

пн, 11 апр 2011 15:03:06 -0000

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

annihillator

пн, 11 апр 2011 12:38:58 -0000

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?