MyBB Community Forums

Here is the error it's giving when it tries to convert my RC4 Database to 1.1.2

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/z3rb/public_html/upgraded/inc/db_mysql.php on line 151
mySQL error: 1054
Unknown column 'a.donecon' in 'where clause'
Query: SELECT a.*, p.uid AS puid, p.dateline FROM mybb_attachments a LEFT JOIN mybb_posts p ON (p.pid=a.pid) WHERE a.donecon!='1' ORDER BY a.aid ASC LIMIT 50

Please upload the attached file into the "inc" directory and replace the existing one. After that try again.

Thanks, just out of curiosity, what did the new file do?

I think it was the field_exists method that was changed between PR2 and 1.0 (the logic was incorrect before). Because the RC4 upgrade script used the field_exists method assuming it was the old version before it was changed, it would not work correctly.