MyBB Community Forums

Today, i decided to take a look at my portal. i found out it was broken. it showed an sql error

Quote: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 6
Query:
SELECT p.pid, p.message, p.tid, p.smilieoff FROM mybb_posts p LEFT JOIN mybb_threads t ON (t.tid=p.tid) WHERE t.fid IN (0) AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid ORDER BY t.dateline DESC LIMIT 0,

I am not in a hurry to fix it as i hardly use the portal

Is this a custom portal or the default portal?.

default one

In the portal settings, what's in the setting for how many announcements to show?? Looks like it's empty: [Issue #1291]

it was blank. when i put 0, i didn't get the error.

Put it on 10 or something, otherwise it won't show any announcements.

(2010-10-26, 09:50 AM)MattRogowski Wrote: [ -> ]Put it on 10 or something, otherwise it won't show any announcements.

Yep.