2014-08-09, 10:04 PM
I have posted this issue on GitHub first due from what I read on forum thread, it is a bit confusing. Now here is a forum thread.
I have found a bug in administrator control panel (ACP) related to editing user profile with MyBB 1.7.2 aka MyBB 1.8 Beta 3 version.
Link: home/admin/index.php?module=user-users&action=edit&uid=1#tab_profile
When I click on "Save User" button, it loads up and say:
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'fid1' in 'field list'
Query:
UPDATE secret_userfields SET fid1='', fid2='', fid3='' WHERE ufid='1'."
I have tried changing options around to hopefully catch a field that causes it, with no luck.
I am not quite sure, but before I found this bug, I was managing a forum. The only thing I maybe (only maybe) think is the cause of this, could be that because I have deleted/removed ALL pre-defined custom user fields that came with MyBB 1.8 Beta 3 installation. Right after that, I came to editing user. The rest of change it forum-related as far as I remember. Small notes, I have provided default admin folder name, also I have changed my real table prefix to "secret_", as I don't think it has anything to do with this (my real table prefix includes random lowercase/uppercase letters, digits and ends with "_" character, and it is 16 characters long).
Click here to see image of MySQL error.
I have found a bug in administrator control panel (ACP) related to editing user profile with MyBB 1.7.2 aka MyBB 1.8 Beta 3 version.
Link: home/admin/index.php?module=user-users&action=edit&uid=1#tab_profile
When I click on "Save User" button, it loads up and say:
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'fid1' in 'field list'
Query:
UPDATE secret_userfields SET fid1='', fid2='', fid3='' WHERE ufid='1'."
I have tried changing options around to hopefully catch a field that causes it, with no luck.
I am not quite sure, but before I found this bug, I was managing a forum. The only thing I maybe (only maybe) think is the cause of this, could be that because I have deleted/removed ALL pre-defined custom user fields that came with MyBB 1.8 Beta 3 installation. Right after that, I came to editing user. The rest of change it forum-related as far as I remember. Small notes, I have provided default admin folder name, also I have changed my real table prefix to "secret_", as I don't think it has anything to do with this (my real table prefix includes random lowercase/uppercase letters, digits and ends with "_" character, and it is 16 characters long).
Click here to see image of MySQL error.
