MyBB Community Forums

This error message appears only on index, everything else is fine.

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 'ORDER BY r.dateline DESC LIMIT 0,100' at line 5
Query:
SELECT r.dateline, u.username, g.namestyle, u.uid FROM (threadsread as r, users as u) LEFT JOIN usergroups as g ON (g.gid = u.usergroup) WHERE r.uid = u.uid AND r.tid = ORDER BY r.dateline DESC LIMIT 0,100

What plugins are you using?

I doubt plugins caused this cus this came suddenly, not after I activated some plugin...

Akismet (1.2.1)
Boardstats-Online Users Image (1.1)
Contact Us MyBB (1.0)
Country Flags (1.0)
Currency Converter (1.0)
Extra Security Question (1.0)
Fancy Popup Message (1.0)
Fast Ban (1.0)
Force Postbit Layout (1.0)
Image Reputations (1.0)
Subscription Page (1.0)
Mini Awards (1.2)
MyMood (1.0 Beta)
Thank You/Like System (1.4)
Latest Thread Viewers (1.0)
Thread Enhancer (1.0)

Edit:
Looks like it is actually, turned off every plugin and now everything works fine... I ll turn on one by one to determinate which one is causing the problem... thanks anyway

Try re-uploading index.php

Looks like it was "Latest Thread Viewers" causing it ... thanks for help
/Request Solved/Close