MyBB Community Forums

Full Version: While using upgrade.php
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
While getting to the point Data Cache Building

I get:

Fatal error: [SQL] [1054] Unknown column 'm.isgroup' in 'where clause'
SELECT m.*, u.username, u.usergroup, u.displaygroup FROM mybb_moderators m LEFT JOIN mybb_users u ON (m.id=u.uid) WHERE m.isgroup = '0' ORDER BY u.username in /XXX/forum/inc/db_mysqli.php on line 557

line 557 in db_mysqli.php
trigger_error("<strong>[SQL] [".$this->error_number()."] ".$this->error_string()."</strong><br />{$string}", E_USER_ERROR);

upgrading from 1.4 to 1.6
Are you sure you had all the updated files and ran the upgrade fully?? What version did you choose from the version list??
Yes uploaded all files and set to over-write. (except ./inc/settings.php)

After that I chose 1.4 in upgrade.php
Upload them again and re-run the upgrade, it runs code to add this column during the upgrade process.
Yea that fixed it....

Meh sorry for this obvious fix...

Just checked the filezilla log and during the transfer of upgrade.php the server closed connection (prolly cus ive been up/dwnloading files alot today).

It resumed the upload though thats why I think it didnt get flagged as failed, but still got corrupted...

Thanks for the help Smile.