error on registration?

moshbit

moshbit

Member
Reactions
20
hey, i don't have many of these errors in my server error log, but they both happened when folks were registering so i thought i'd post it here:

Code: 
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'useress_tags' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, Thursday at 9:36 PM
Stack Trace
#0 /home/*/domains/squattheplanet.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/*/domains/squattheplanet.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/*/domains/squattheplanet.com/public/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/*/domains/squattheplanet.com/public/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/*/domains/squattheplanet.com/public/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/*/domains/squattheplanet.com/public/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/*/domains/squattheplanet.com/public/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#7 /home/*/domains/squattheplanet.com/public/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#8 /home/*/domains/squattheplanet.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/*/domains/squattheplanet.com/public/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
  ["url"] => string(44) "https://squattheplanet.com/register/register"
  ["_GET"] => array(1) {
    ["/register/register"] => string(0) ""
  }
  ["_POST"] => array(15) {
    ["username"] => string(0) ""
    ["da9aa13d053f29147ade9fefe734e1b6"] => string(11) "JerzeeDevil"
    ["43ea681d64039e3b30c8c05c9c5db3aa"] => string(19) "[email protected]"
    ["0d21288575ba4beefeb464c5a15ac81d"] => string(4) "male"
    ["dob_month"] => string(1) "6"
    ["dob_day"] => string(2) "19"
    ["dob_year"] => string(4) "1997"
    ["location"] => string(10) "New Jersey"
    ["be52a41622213053923105a2e54bdca2"] => array(1) {
      ["yjdhzmzmnjlhzwq5"] => string(0) ""
    }
    ["custom_fields_shown"] => array(1) {
      [0] => string(16) "yjdhzmzmnjlhzwq5"
    }
    ["04519a461c2c54696671439e194848b5"] => string(16) "America/New_York"
    ["g-recaptcha-response"] => string(1081) "03AHJ_Vuu0oLHvwGSDoPAYIBkuguOXDsyq5Qi6B8SL9QWXwI8ey6esX9HBHvwYqJ4Y6oyaO6RNdooAPdQlp-qIxdDYLKj4fAB_bt5ym2mxLpLh3jA37eW5gDK3WvFNCCHdiqtMK4yXjwPBbLGztfbJfAedvh2VqRj2svr-XMa_LKyT20Wol_VybnoqAM_gLchWqQcsYUb8IkoQOapN9u_CNH0pq5d9pyCOd5OL-MtTek1aVrjo0WWb3VQwm4xXuaFqNIw9pQQuOeEFENBptrm18GcYoPtPbu4jKZD9p8xHgpyIHuZdr-xjf61O7KmH-5ZJBawty1tURwy8jyZ2z_cvHl_OF-XDWDKTXv5ZCIgtXs5UK4yYYtgRH-JVmduzLZSpva2joqC3zvXeLC1yRqba0lvgbjVEvcff4FapTuQEne6X09NdFt7iJhPZTjFzOMYb6r6tPXmpFZy8zF1AAL4U0AwZpXoPIb3vxk_twR5pSdxfSPW2hJmQf5Z5gIc_wUW7nx5HxMnei8hlxnx8r585HE7stH2jEpLGixSPedzrUzLysnWWDDL8pnZRpBPO0j1Poad5jAX6Kn1ON6CuVNyOEOeRN7CZq5bfPvNsMuf0EQ5pzRttAmwT6bM0jdPWrdj_IBMwHj_-IXO7C5NbvR4DGn8-oVMC7T4GoniWCGyQRYq-HoetyHkKqKXask64Entm2rnveZVxPirMhcH9iP0s3ZBcj26GxXT8W0u-BgFwsjibmbrtMhqNG6iQXfWROSHKLb3vrMOuLI499ZvJVCN0wUXtD2uJy13pFjBdk_abY3lMAv5hdjik2IfrXnHnvUAjfqwPH6cUsDlPWtusoMcf7NMtZC8kf8AjCGjV3I7AfBHWlGik0_jR09qnL3XWzRWPhN-vICNAeqX0WbXwgOw5kIHOf-YjIcN2vCPcBGqMY9yASuYXDqgtX21KHP22dJpN_AJsiFoaFxFpzKo0JaOCxS6sG-WvaoaPbmXtfkWLQcLGHqJiSx8gOdZUYrAfNnE5QH6G_WKfGX1BErCpAvuPkveEOwXWubTbaYIiuYBHX7K41DdNDifnxK8"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "b7afff69aed9103e30dad5e60dd36c1f"
  }
}

it appears to be related to the user essentials addon, which i have version 2.6.4.2 installed (and xf 1.5.9).
 
@moshbit yuck. This looks to happen when you have User Essentials installed but disabled.

Can you run the following query:
Code: 
ALTER TABLE `xf_user` MODIFY `useress_tags` MEDIUMBLOB;

This should fix it, I'll release a patched version tomorrow.
 
Xon said:
@moshbit yuck. This looks to happen when you have User Essentials installed but disabled.

Can you run the following query:
Code: 
ALTER TABLE `xf_user` MODIFY `useress_tags` MEDIUMBLOB;

This should fix it, I'll release a patched version tomorrow.
Click to expand...
Click to shrink...

hmm, i didn't have it disabled, but i'll give the query a go and see how that turns out. thanks!
 
Xon said:
Code: 
ALTER TABLE `xf_user` MODIFY `useress_tags` MEDIUMBLOB;

This should fix it, I'll release a patched version tomorrow.
Click to expand...
Click to shrink...


Code: 
 MySQL returned an empty result set (i.e. zero rows). (Query took 0.9880 seconds.)

i don't really know mysql well, but i'm not sure that did anything :(
 
That is the expected response. You shouldn't get any of the errors mentioned in the OP now.
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top