MyBB Community Forums

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 '' at line 6
Query:
    SELECT p.pid, p.message, p.tid FROM mybb_posts p LEFT JOIN mybb_threads t ON (t.tid=p.tid) WHERE t.fid IN (0) AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid ORDER BY t.dateline DESC LIMIT 0, 

Thats the error thats now on my forum after I used the upgrade.

How did you upgrade? Have you replaced the files and run the upgrading script?

Replace the files and your database with the backup you made, and try again.

(2008-08-17, 01:10 PM)Ddraiggoch06 Wrote: [ -> ]How did you upgrade? Have you replaced the files and run the upgrading script?

Replace the files and your database with the backup you made, and try again.

Thats what I did.

I uploaded the new files and run the upgrade script and that happened.

Hi,

Please try this: http://community.mybboard.net/thread-360...#pid240505

Ryan