• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Register throws a server error: Field 'password' doesn't have a default value

#1
After i update 1.5.13 i can't register. Here the error i get:

Mysqli statement execute error : Field 'password' doesn't have a default value
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
  7. XenForo_DataWriter->save() in XenForo/ControllerPublic/Register.php at line 416
  8. XenForo_ControllerPublic_Register->actionRegister() in XenForo/FrontController.php at line 351
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /home/www/xenforo2/index.php at line 13
Here server logs:

array(3) {
["url"] => string(52) "https://***/register/register"
["_GET"] => array(0) {
}
["_POST"] => array(14) {
["username"] => string(0) ""
["02126a6f91075c549e0a6ac29463ce58"] => string(6) "gdsgsa"
["db83c808d089d1c7b3b61ffbaaac803a"] => string(14) "ygsd@gmail.com"
["1c12d3031e6df35619d29da6e180d835"] => string(0) ""
["dob_month"] => string(2) "10"
["dob_day"] => string(1) "3"
["dob_year"] => string(4) "1998"
["bdb22e54b3b4a19df5f8c6bbd3368b5a"] => array(1) {
["odjjzwqwztcy"] => string(0) ""
}
["custom_fields_shown"] => array(1) {
[0] => string(12) "odjjzwqwztcy"
}
["17b98d11917465ab9a085e2682980084"] => string(13) "Europe/Moscow"
["g-recaptcha-response"] => string(356) "03AIezHSbwH9NdZtHXR_Wk5gXSDF7VuRwBtG-2tBtkhwfB6cBly4DvuOfqIwk-aiEYdPKxHIP1kom2dJ_3e1liwBqvcLKEqgBnYnQ3spXsqHRz6jFuHxkRwfgnIngMFGP7fLDl8IssVRXJOx-tpbmpQvGmqCSDC9DB81c3UJwU_a-oqPv_KRS4elWmM_GUcVsXc1qLEl0151B4Gb-Gdnxc23KByue_-4ccgHbjMf5z5dSl6tlXOdgT_dY3dO2MiJU_F1hxZq4QqfdOTWmqLfP63Mc0fal1JE1eJfuTYuXGvPgNlddMzDhW6HDZ77wXTFl3fHkz8vrPlByqlS9SokncT0E37JNIVb4raw"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "82ced0e72f4abc961e31bdd69bced8c4"
}
}
 
#3
I disabled all of my addons, converted to default style and tried to register again. Unfortunately i took same error.
Mysqli statement execute error : Field 'password' doesn't have a default value
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
  7. XenForo_DataWriter->save() in XenForo/ControllerPublic/Register.php at line 416
  8. XenForo_ControllerPublic_Register->actionRegister() in XenForo/FrontController.php at line 351
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /home/www/xenforo2/index.php at line 13

array(3) {
["url"] => string(52) "https://*/register/register"
["_GET"] => array(0) {
}
["_POST"] => array(15) {
["username"] => string(0) ""
["d6d1f187dd5395ba835009da7828e3ce"] => string(5) "asdf3"
["433fbb5115394d08cc190412e601a90f"] => string(0) ""
["70013fe581cfedc81a247a92798952d9"] => string(14) "1234@gmail.com"
["280fb327ba93b8526ec648d7740c947b"] => string(4) "male"
["dob_month"] => string(1) "5"
["dob_day"] => string(2) "31"
["dob_year"] => string(4) "1995"
["1f852be6b6e27dc6ab8451ab8fec101b"] => array(1) {
["nzvjmjgyzjm"] => string(0) ""
}
["custom_fields_shown"] => array(1) {
[0] => string(11) "nzvjmjgyzjm"
}
["7ffc2197b4d62cb8142abc70e399aa66"] => string(13) "Europe/Moscow"
["g-recaptcha-response"] => string(356) "03AIezHSZ3n--vxG7pa6lfrDfFVFRZSDuvqwGWQD_188Ni3kvfcNhrCwtGx45uyWT_LrMjLJoPllffiWWQg61abr7wnVEdkCXb_py4m3jBhp6-VuaSOtDwyWVxgQVqoxw7yHAplcgRxINBmDA2TwWwlq8--OEqlXCaZVOA4ybB9kygSLcG7vsmgPsuDKjEgD2lMJ2hLaI8eEccb3wpAx0syz0K1L8KQWV6pb3itV-MyphE2bhoiUnroxvKMVP30jnbyBA8SKxl-SBHAWSzus1MERfOowCJ6ZE_oGNThBNuMFZDaGw7eawTtpQuguDZnFbn_Z0hnS7qJw6t3p9Oura_zpn-0xIWL7CnCQ"
["agree"] => string(1) "1"
["_xfToken"] => string(8) "********"
["reg_key"] => string(32) "75c282f384177a7938db9c7ac4b1fb05"
}
}
 

Brogan

XenForo moderator
Staff member
#7
The error is typically caused by an add-on which has added a field to a table in the database without a default value - in this instance disabling add-ons will actually trigger the error.

Which add-ons do you have installed?
 

Brogan

XenForo moderator
Staff member
#8
Can you run this query?

Code:
select table_name, column_name
from information_schema.columns
where column_name like '%password%'
 
#9
Can you run this query?

Code:
select table_name, column_name
from information_schema.columns
where column_name like '%password%'
Thank you for the code. I found why is this happening. I sycnhronize my Xenforo forum and Minecraft server with Authme plugin. Seems like Authme plugin created password field in xf_user and this field cant be empty, have no default value. I changed these and problem solved.