MyBB Community Forums

Hi.

I upgraded the other day from 1.2.13 to 1.4, and everything seemed fine.

However, it turns out that I have a problem. When people try to register, the registration page works, but when they submit a MyBB SQL Error comes up:

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'ufid5' in 'field list'
Query:
INSERT INTO mybb_userfields (fid3,fid6,fid1,fid2,fid7,ufid,ufid5) VALUES ('','','','','','6','')

The account is created, but it doesn't then show in the stats at the bottom of the index page...

Any ideas?

Edit: Sorry, I may have put this in the wrong forum. Still...

Have you made any changes to the core code or have any plugins active? I would try disabling all your plugins and re-enabling them maybe.

No changes to the core code, no active plugins.

Have you played around in PHPmyadmin? or added any custom fields maybe?

No, and no custom fields.

-

Sorry for the late response. Try this: Open the file inc/datahandlers/user.php and search for line 975:

$user['user_fields']["ufid{$profile_field['fid']}"] = '';

Replace with:

$user['user_fields']["fid{$profile_field['fid']}"] = '';

So thanks for interest