MyBB Community Forums

When a user visits the Members List link, and then tries to click on a members name The following error occurs.

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'hidden' in 'where clause'
Query:
SELECT * FROM mybb_profilefields WHERE hidden=0 ORDER BY disporder

I tried using the File Verification tool, however the only thing picked up was missing files from the /install folder.

MyBB 1.6.17



Any help is appreciated.

have you upgraded your forum recently or is it automatic installation from web host panel ?

Did you try to upgrade to 1.8 recently, but then decided to go back to 1.6?

Because the hidden column in table profilefields does no longer exist in 1.8.

Yes, I did. The 1.8 failed and files were rolled back. At least I thought they were. Does this mean i need to grab a file/s from the 1.6 and upload them again?

(2015-09-01, 05:19 PM)chris7878 Wrote: [ -> ]Does this mean i need to grab a file/s from the 1.6 and upload them again?

No, but you could re-install the 1.6 version of the mybb_profilefields table in your database. But I'm not sure whether there are more situations like this.