+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Error Message] MyBB SQL Error (/thread-177170.html)
MyBB SQL Error - chris7878 - 2015-09-01
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.
RE: MyBB SQL Error - .m. - 2015-09-01
have you upgraded your forum recently or is it automatic installation from web host panel ?
RE: MyBB SQL Error - Ad Bakker - 2015-09-01
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.
RE: MyBB SQL Error - chris7878 - 2015-09-01
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?
RE: MyBB SQL Error - Ad Bakker - 2015-09-01
(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.