The Sandman
Well-known member
Every so often I get an error like the one below. I'm assuming it's a spammer or spambot trying to register with a stupid long username (or it's trying to spam the server itself). Is the error correct behavior in a case like this or do I have an issue somewhere that should be addressed?
Code:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'username' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Yesterday at 1:37 PM
Stack Trace
#0 /home/adminx/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/adminx/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/adminx/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/adminx/public_html/library/RegFormTimer/ControllerPublic/Register.php(92): Zend_Db_Adapter_Abstract->insert('xf_reg_form_tim...', Array)
#4 /home/adminx/public_html/library/UserEss/ControllerPublic/Register.php(68): RegFormTimer_ControllerPublic_Register->actionRegister()
#5 /home/adminx/public_html/library/XenForo/FrontController.php(337): UserEss_ControllerPublic_Register->actionRegister()
#6 /home/adminx/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/adminx/public_html/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(39) "http://adminextra.com/register/register"
["_GET"] => array(0) {
}
["_POST"] => array(16) {
["username"] => string(485) ",Review,howto,Marketing,Education,General,Misc,Miscellaneous,Business,Career,Other,Travel,Jobs,Electronics,computer,Internet,web,self,work,learn,Blogging,lifestyle,offtopic,news,uncategorized,forex,entertainment,updates,interiordesign,furniture,homeimprovement,decor,energy,solar,lawn,landscape,xbox,wedding,phones,iphoneapps,iphone,blackberry,used,insurance,loan,garden,software,realestate,property,debt,freebies,Hobbies,personaldevelopment,entrepreneurship,religious,instruments,wine"
["email"] => string(36) "serpdom6@metaboliccookingreviews.org"
["password"] => string(8) "********"
["password_confirm"] => string(8) "********"
["dob_month"] => string(1) "4"
["dob_day"] => string(1) "3"
["dob_year"] => string(4) "1973"
["gender"] => string(0) ""
["custom_fields"] => array(2) {
["interested"] => string(0) ""
["whatdoyouwant"] => string(0) ""
}
["custom_fields_shown"] => array(3) {
[0] => string(10) "interested"
[1] => string(13) "software_used"
[2] => string(13) "whatdoyouwant"
}
["timezone"] => string(16) "America/New_York"
["photo_captcha_sid"] => string(32) "5d1531995e21f909a19d38c217788e35"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "0ce7ace99844917284bd6fed680d49a9"
["time"] => string(10) "1382549833"
}
}
