MyBB Community Forums

Full Version: my forum is not running, wiered query issus on forum.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi all, i am working on my local pc on database import , we are importing data form some existing database to mybb.

i am seeing the error on my locapc when i visit pages like

http://localhost/forumdisplay.php?fid=32
http://localhost/showthread.php?tid=215

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 ') AND t.lastpost > IFNULL(fr.dateline,) ' at line 7
Query:
Query 1.

SELECT t.tid FROM local_threads t LEFT JOIN local_threadsread tr ON (tr.uid = 4313 AND t.tid = tr.tid) LEFT JOIN local_forumsread fr ON (fr.uid = 4313 AND t.fid = fr.fid) WHERE t.visible = 1 AND t.closed NOT LIKE 'moved|%' AND t.lastpost > IFNULL(tr.dateline,) AND t.lastpost > IFNULL(fr.dateline,) AND t.lastpost > ORDER BY t.dateline DESC LIMIT 1000


Query 2 .
SELECT COUNT(t.tid) AS unread_count FROM local_threads t LEFT JOIN local_threadsread tr ON (tr.tid=t.tid AND tr.uid='5762') LEFT JOIN local_forumsread fr ON (fr.fid=t.fid AND fr.uid='5762') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (32) AND t.lastpost > IFNULL(tr.dateline,) AND t.lastpost > IFNULL(fr.dateline,) AND t.lastpost >
what's ur mysql version.....
i am using wamp 2.2 64 bit with
Apache Version : 2.2.21
PHP Version : 5.3.10
MySQL Version : 5.5.20