MyBB Community Forums

Full Version: help plz? (MyBB SQL Error)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Current revision: 5081

in the portal.php:
_____________________________________________________________
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
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 1
Query:
SELECT COUNT(tid) AS newann FROM mybb_threads WHERE visible=1 AND dateline>'1278350672' AND fid IN ()
_____________________________________________________________

steps:

-> new installation
-> delete all the forums and categories
-> create news categories and forums
-> create news threads
-> create news post

and that error Sad

my english is bad, sorry.
What version of MySQL does your host have installed?
(2010-07-05, 11:44 PM)pyridine Wrote: [ -> ]What version of MySQL does your host have installed?

5.1.36
Created Portal SQL Error if no Forums Selected.

ilusoignorante, to fix your problem, simply go to the ACP -> General Configuration -> Portal Settings and make sure you have Forum IDs (fid) in the Forum ID to pull announcements from setting.
thanks Smile