MyBB Community Forums

Full Version: 503 error on new user registration
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all,

User registration at the last part when hitting submit throws a 503 error and stops there.
On server logs there isn't anything, no single error line. Any way to troubleshoot this?
I'm new to mybb.

Thanks
What plugins are you using?
Hi, I'm using various plugins. After further investigation from my hosting provider here is some extra info:

## connecting into database and sending some INSERT query (probably , to add a new forum user):
32634 recvfrom(4, "\7\0\0\1\0\0\0\2\0\0\0", 10868, MSG_DONTWAIT, NULL, NULL) = 11
32634 sendto(4, "\325\4\0\0\3\n\t\t\tINSERT\n\t\t\tINTO kagiak_users (username,password,salt,loginkey,email,postnum,threadnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,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)\n\t\t\tVALUES ('dasupport','4c34464c5d1e35226eb39e6142cff74c','aaKP7Ztk','mea1nldvlLoxB3jVQEuu3ADOC8rDZhZJFgVANaCRQfJeB3yq5g','[email protected]',0,0,'','',5,'',0,'',1547024940,1547024940,1547024940,'',0,'','','','','',0,0,0,0,0,0,0,1,1,1,1,1,1,0,0,0,0,'0',2,'linear',0,'','',X'5bf303b7','',1,0,1,0,0,0,0,'','',0,0,'','','',0,0,0,0,0,0,0,'')\n\t\t", 1241, MSG_DONTWAIT, NULL, 0) = 1241

But response is:

32634 poll([{fd=4, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=4, revents=POLLIN}])
32634 recvfrom(4, "1\0\0\1\377T\5#HY000Field 'aim' doesn't have a default value", 10857, MSG_DONTWAIT, NULL, NULL) = 53

And it produce the error:

32634 chdir("/") = 0
32634 times({tms_utime=130, tms_stime=24, tms_cutime=0, tms_cstime=0}) = 1722435185
32634 setitimer(ITIMER_PROF, {it_interval={tv_sec=0, tv_usec=0}, it_value={tv_sec=0, tv_usec=0}}, NULL) = 0
32634 utime("/home/admin/tmp/sess_ohpq6a0f9tggjll74nkv98f23n", NULL) = 0
32634 close(5) = 0
32634 close(6) = 0
32634 sendto(4, "\1\0\0\0\1", 5, MSG_DONTWAIT, NULL, 0) = 5
32634 close(4) = 0
32634 write(3, "\1\6\0\1\r\307\1\0Status: 503 Service Temporarily Unavailable\r\nX-Powered-By: PHP/7.2.13...

The exact error is "HY000Field 'aim' doesn't have a default value" which means that database structure for this forum does not match inserted values.

I've added a default value of null to the aim field and worked afterwards.