MyBB Community Forums

Full Version: mysql error 1054 @ upgrade
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ***********/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


I'm upgrading from RC4 to 1.0. I have uploaded new files (except settings.php and config.php). I deleted all old files.

I can't get rid of this error. Did I do something wrong?
umm hey

i;m not sure, but try to upload and original db_mysql.php again


regards
I encounter the same error Sad
I don't know what to do too.
heloo there

did u try what menitoned above ?

are u getting the exact same error?

regards

zaher1988 Wrote:heloo there

did u try what menitoned above ?

are u getting the exact same error?

regards

Well of course I have tried that. I deleted the db_mysql.php file and uploaded it again, replaced it with the old one and so on. Nothing changed...still get the same error.
So replacing doesnt work.
I received this error message while also upgrading from RC4 to 1.02, noted that it's almost the same one as this thread, might as well post here. Smile

Attachment Conversion to Files

Converting attachments 1 to 50 (132 Total)

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/anthroas/public_html/forums/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

Any assistance would be duly appreciated, thanks!
I just did a search of the forums and found this! It works now! Thanks a million! Big Grin