Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Months, 4 Weeks ago 503 error on new user registration
#1
Solved: 8 Months, 4 Weeks ago
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
Reply
#2
Solved: 8 Months, 4 Weeks ago
What plugins are you using?
[Image: ZbrcFs]
Reply
#3
Solved: 8 Months, 4 Weeks ago
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)