MyBB Community Forums

I upgraded from 1.22 to 1.24 and got this error.

MySQL error: 1054
Unknown column 'b.olddisplaygroup' in 'field list'
Query: SELECT u.*, f.*, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup, b.olddisplaygroup as banolddisplaygroup, b.oldadditionalgroups as banoldadditionalgroups FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1'

Anyone know how to fix this?

Thanks,
-Bill

maybe try and create the column olddisplaygroup in table banoldgroup manually

microdude431 Wrote:I upgraded from 1.22 to 1.24 and got this error.

MySQL error: 1054
Unknown column 'b.olddisplaygroup' in 'field list'
Query: SELECT u.*, f.*, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup, b.olddisplaygroup as banolddisplaygroup, b.oldadditionalgroups as banoldadditionalgroups FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1'

Anyone know how to fix this?

Thanks,
-Bill

You've ran the upgrade.php ?

Seems to work now, thanks for the help.

-Bill

but how
i recieved this to

---

what is your mean?(run the upgrade.php)?