2012-06-27, 08:50 AM
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 >
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 >