MyBB Community Forums

Hi guys, I am getting the following error when trying to register a new user to my board:

MySQLi error: 1364
Field 'modallposts' doesn't have a default value
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, emailnotify, receivepms, pmpopup, pmnotify, remember, showsigs, showavatars, showquickreply, showredirect, tpp, ppp, invisible, style, timezone, dst, threadmode, daysprune, dateformat, timeformat, regip, language, showcodebuttons, away, awaydate, returndate, awayreason, notepad, referrer, buddylist, ignorelist, pmfolders) VALUES ('dmoffitt', '2a2ff5ccf4de002ca734d5bd521db021', 'OIsX7Gwy', 'RMsO4sQkc9njTIR2VwZa3AREHmSjMRI5NxN87UN6bQeXiCz6XP', '[email protected]', '0', '', '', '2', '', '0', '', '1166705856', '1166705856', '1166705856', '', '0', '', '', '', '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '0', '0', 'no', '0', '-5', 'yes', 'linear', '0', '', '', '24.59.175.189', '', '1', 'no', '0', '0', '', '', '0', '', '', '');

I've already tried the help section and reloaded the function.php Any other ideas, I'm stumped.

Thanks

This is from a modification you've been using and has nothing to do with MyBB.

I've updated DennisTT's plugin to fix MySQL 5 compatibility and attached it to this post. Please upload the file and replace your current copy in inc/plugins/ with it.

Then login to the Admin CP and disable the "User Permissions" plugin and re-enable it.

Generally before asking for support in the future, please try disabling your plugins to see if the problem is with them or with MyBB.

Chris Boulton Wrote:This is from a modification you've been using and has nothing to do with MyBB.

I've updated DennisTT's plugin to fix MySQL 5 compatibility and attached it to this post. Please upload the file and replace your current copy in inc/plugins/ with it.

Then login to the Admin CP and disable the "User Permissions" plugin and re-enable it.

Generally before asking for support in the future, please try disabling your plugins to see if the problem is with them or with MyBB.

Chris thank you, that worked like a charm.  I have another quicky for you.  Is it possible to shut off the email stuff comlpetely, and just allow everything to be handled within the board.  I am running it on my own Abyss server, and the sendmail locally will be blocked from anyone using AOL or most of the others.  Or maybe change the sendmail to an actual smtp server address?  Chris I did a mass email, I received a copy as admin, but my username as a new sign up different email addy did not receive it.  I do have the board set to automatic activation BTW. Another thing that is a little baffling is that when I sign in with the admin username and password, it still says welcome guest? Shouldn't it say something like Welcome You Have Admin Rights? Sorry for the double post, just thought maybe you were over on the IRC channel and not paying attention. My bad