MyBB Community Forums

Big problem ... when i visit my main index http://musicjam24.com/forum/ it show...



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 (70,79,71,102,72,73,74,75,77,78,80,81,82,103,104) AND t.v' 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 ('13','66','92','93','94','95','96') WHERE t.fid NOT IN (70,79,71,102,72,73,74,75,77,78,80,81,82,103,104) AND t.visible = '1' GROUP BY t.tid ORDER BY t.lastpost DESC LIMIT 9

The correct query should be

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 ('13','66','92','93','94','95','96') AND t.fid NOT IN (70,79,71,102,72,73,74,75,77,78,80,81,82,103,104) 
AND t.visible = '1' GROUP BY t.tid ORDER BY t.lastpost DESC LIMIT 9

How to fixed it ? i mean what to do ?

You need to find where that query is generated. I'm going to guess that you recently installed a plugin. By the looks of the query, I'm going to guess it was a plugin for Recent Threads on Index. You'll need to go through the plugin file and make the changes there.

i did nothing not a plugin have installed. i just rename 4 subforum. aftar that this problem occurs. then i quick change the past name. but still this message showing.

Please list all plugins you have installed.

Additional Usergroups on profiles (1.2)
Advanced Sitemap (1.2)
Akismet (1.2.2)
Online Status Avatar (3.0)
Code Select All (1.0.0)
Fassim Anti Spam (1.3)
Google SEO (1.6.7)
Hello World! (1.0)
Highslide 4.1.9 Zoom-Slideshow-Watermark (4.0)
Hide Post Contents (1.1)
Imp Forums (0.1)
iShare (1.2.1)
MetaTags Plugin (1.0)
CKEditor WYSIWYG editor (2)
MyFacebook Connect (2.0.1)
Show the users that has been online today (2.0)
Registered Members Links (1.0.0)
PluginLibrary (12)
Facebook profile link on Postbit (2.4)
Quote Shrinker (1.0)
Recent Posts Forum Index (1.0)
Registered Links (1.0)
Registration Security Question (1.2)
Side Bar Threads (0.1)
Stop Forum Spam (1.4)

---

point to noted that i can visit all link except index.php
example : musicjam24.com/forum/showthread.php?tid=6007

Can I get a link to Side Bar threads please? I'm not able to locate it on the Mods Site.

Side bar threads means ??
i can visit all link except index.php
example : www.musicjam24.com/forum/showthread.php?tid=6007

also i can view members profile / and view post by going member--->Show All Threads-->>

A link to the plugin download.