MyBB Community Forums

People are trying to join but get this error after hitting join.

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

SQL Error:
1054 - Unknown column 'remember' in 'field list'
Query:
INSERT INTO mybb_users (username,password,salt,loginkey,email,postnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,aim,yahoo,msn,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,longregip,language,showcodebuttons,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,remember) VALUES ('tamigachigirl','d4ced496eb32e3d7995c69e9b893b2d9','z6ld2Vss','tC6sVxx5hgXhbeUZHsQElEldw57PRvirq7DC36qx3ZUpWlwNOk','[email protected]','0','http://i38.tinypic.com/34te9ht.png','remote','5','','0','','1281738934','1281738934','1281738934','gfxcafe.net','0','','','','','tamigachigirl, proud to be a member of GFX Cafe since Aug 2010.','1','0','0','1','0','1','0','1','1','0','1','0','0','0','0','8','2','linear','0','','','174.57.40.47','-1371985873','','1','0','0','0','','','1','0','','','','0','0','0','0','0','0','0','','1')
Please contact the MyBB Group for support.

Which one is it under... I never upgraded either this is a new site with 1.6

Then you've installed a 1.4 plugin. If this column is coming up in an error, 1.4 code is being run. It's not in 1.6 at all.

Well i added some old 1.4 files but changed

 compatibility => 14* to 16*

would that be a issue?

Yes, as it says in the sticky thread, that's not going to make every single plugin work. Some need more changes, you're probably using one that needs more, one that still uses the remember column.

Ok i have to deactive each one 1 by 1 and see what it its hold on....
It was Denisstt's default profile that was doing it. Thanks.