MyBB Community Forums

SQL Error

MyBB encountered an internal error in the SQL query and can not continue.

SQL error:
    1054 - Unknown column 'myalerts_disabled_alert_types' in 'field list'
Query:
    INSERT INTO mybb_users (username,password,salt,loginkey,email,postnum,threadnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,aim,yahoo,skype,google,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showimages,showvideos,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,language,showcodebuttons,sourceeditor,buddyrequestspm,buddyrequestsauto,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,dst,myalerts_disabled_alert_types) VALUES ('test','7da71207dfc71b8517b4b9414468d3ac','84KiCXKF','7CN2NkTAlf6uDG5Dx7Iz9kVf6nYNhIeT96iJjOIqbFsBvXfMuq','[email protected]',0,0,'','',2,'',0,'',1440235957,1440235957,1440235957,'',0,'','','','','','',1,0,0,1,0,1,1,1,1,1,1,1,1,0,0,0,0,'',0,'linear',0,'','',X'','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,1,'',0,'[]')

Visit Polish MyBB Support for assistance.

Moved to plugin support.

Was this a fresh install of MyAlerts? It looks like the "myalerts_disabled_alert_types" column wasn't added to the mybb_users table. AN easy fix would be to add the column manually through phpMyAdmin, using a column type of "TEXT NOT NULL'. You can do so using the following SQL query:

ALTER TABLE mybb_users ADD `myalerts_disabled_alert_types` TEXT NOT NULL DEFAULT '[]';

#1101 - BLOB/TEXT column 'myalerts_disabled_alert_types' can't have a default value

Remove the default clause then.

How to do it?

There is no longer a SQL error , only MyAlerts does not work