on create user via acp Code: Mysqli statement execute error : Incorrect integer value: '' for column 'advanced_rules' at row 1 Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574 Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591 XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580 XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381 XenForo_DataWriter->save() in XenForo/ControllerAdmin/User.php at line 481 XenForo_ControllerAdmin_User->actionSave() in XenForo/FrontController.php at line 310 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132 XenForo_FrontController->run() in /var/www/xenforo-clear/admin.php at line 13
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'advanced_rules' at row 1 -library/Zend/Db/Statement/Mysqli.php:214 Code: #0 /var/www/xenforo-clear/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array) #1 /var/www/xenforo-clear/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /var/www/xenforo-clear/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array) #3 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1591): Zend_Db_Adapter_Abstract->insert('xf_user', Array) #4 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1580): XenForo_DataWriter->_insert() #5 /var/www/xenforo-clear/library/XenForo/DataWriter.php(1381): XenForo_DataWriter->_save() #6 /var/www/xenforo-clear/library/XenForo/ControllerAdmin/User.php(481): XenForo_DataWriter->save() #7 /var/www/xenforo-clear/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_User->actionSave() #8 /var/www/xenforo-clear/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch)) #9 /var/www/xenforo-clear/admin.php(13): XenForo_FrontController->run() #10 {main} Code: array(3) { ["url"] => string(57) "http://domain.com/xenforo-clear/admin.php?users/0/save" ["_GET"] => array(1) { ["users/0/save"] => string(0) "" } ["_POST"] => array(43) { ["username"] => string(5) "test1" ["email"] => string(0) "" ["password"] => string(5) "test1" ["user_group_id"] => string(1) "2" ["user_state"] => string(5) "valid" ["gender"] => string(0) "" ["dob_month"] => string(0) "" ["dob_day"] => string(0) "" ["dob_year"] => string(0) "" ["location"] => string(0) "" ["occupation"] => string(0) "" ["homepage"] => string(0) "" ["about"] => string(0) "" ["custom_title"] => string(0) "" ["signature"] => string(0) "" ["message_count"] => string(1) "0" ["like_count"] => string(1) "0" ["trophy_points"] => string(1) "0" ["custom_fields"] => array(8) { ["aim"] => string(0) "" ["msn"] => string(0) "" ["icq"] => string(0) "" ["yahoo"] => string(0) "" ["skype"] => string(0) "" ["gtalk"] => string(0) "" ["facebook"] => string(0) "" ["twitter"] => string(0) "" } ["custom_fields_shown"] => array(8) { [0] => string(3) "aim" [1] => string(3) "msn" [2] => string(3) "icq" [3] => string(5) "yahoo" [4] => string(5) "skype" [5] => string(5) "gtalk" [6] => string(8) "facebook" [7] => string(7) "twitter" } ["style_id"] => string(1) "0" ["language_id"] => string(1) "1" ["timezone"] => string(13) "Europe/London" ["enable_rte"] => string(1) "1" ["content_show_signature"] => string(1) "1" ["visible"] => string(1) "1" ["receive_admin_email"] => string(1) "1" ["show_dob_date"] => string(1) "1" ["show_dob_year"] => string(1) "1" ["allow_view_profile_enable"] => string(1) "1" ["allow_view_profile"] => string(8) "everyone" ["allow_post_profile_enable"] => string(1) "1" ["allow_post_profile"] => string(7) "members" ["allow_receive_news_feed_enable"] => string(1) "1" ["allow_receive_news_feed"] => string(8) "everyone" ["allow_send_personal_conversation_enable"] => string(1) "1" ["allow_send_personal_conversation"] => string(7) "members" ["allow_view_identities_enable"] => string(1) "1" ["allow_view_identities"] => string(8) "everyone" ["_xfToken"] => string(53) "1,1356644783,43baf913d1b45a8b09c58a785fa7018c3d927514" ["_xfRequestUri"] => string(34) "/xenforo-clear/admin.php?users/add" ["_xfNoRedirect"] => string(1) "1" ["_xfResponseType"] => string(4) "json" } }