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? |
| Trustmaster |
|
|---|---|
|
Please check "Maximum topics per page" setting in Admin => Config => forums. What value does it have? May the Source be with you!
|
| annihillator |
|
|---|---|
|
I can't see a Maximum topics per pages setting in my configuration. Added 1 minutes later: I'm using Siena. |
| Trustmaster |
|
|---|---|
|
That's very strange. Go to Admin => Extensions => Forums and click "Update". May the Source be with you!
|
| annihillator |
|
|---|---|
|
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 |
|
|---|---|
|
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 |
|
|---|---|
|
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. |
