MyBB Community Forums

Full Version: PLEASE HELP ON THIS CRITICAL MYBB SQL ERROR
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
PLEASE TELL ME WHAT TO DO. WHEN I VISIT MY SITE, IT SAYS:

MyBB SQL Error
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
'WHERE t.fid NOT IN
(57,20,21,22,23,24,34,35,58,18,
19,33,58) AND t.visible = ' at
line 9
Query:
SELECT t.tid, t.fid, t.subject,
t.lastpost, t.lastposter,
t.lastposteruid, f.name,
u.usergroup, u.displaygroup
FROM mybb_threads AS t INNER
JOIN mybb_forums as f ON (f.fid
= t.fid) LEFT JOIN mybb_users
AS u ON (t.lastposteruid = u.uid)
WHERE t.fid NOT IN ('6') WHERE
t.fid NOT IN
(57,20,21,22,23,24,34,35,58,18,
19,33,58) AND t.visible = '1'
GROUP BY t.tid ORDER BY
t.lastpost DESC LIMIT 5
Please contact the MyBB Group
for support.

PLEASE AM WAITING
what is the last plugin or code modification you have done ? can you deactivate that plugin from admin panel
or undo code modification through ftp or file manager and then visit your forum
(2013-05-14, 08:34 AM).m. Wrote: [ -> ]what is the last plugin or code modification you have done ? can you deactivate that plugin from admin panel
or undo code modification through ftp or file manager and then visit your forum

i didnt modify anythin. I was just adding new forums, editing and changing forum orders when it happenned.

PLS REPLY OH
most probably you have Recent Posts on Index plugin.
if so, disable it from admin panel or remove its file from MyBB files server
Tnkz guy, now working.