XF 1.5 Can not create User anymore

[Freelancer]

Okay with 42 add-ons now this does not come as a real surprise but unexpected.

I can not create any user in the ACP anymore. The following error is displayed NO MATTER what name, password I use... It looks like the form is not processed and the error is the same as if you leave all fields empty.



As per SOP I THEN DEACTIVATED ALL ADD-ONS and when I try to create a user with everything deactivated, I get the following Server Error:

erver 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: XXXXXXXXXXXXXX, 6 minutes ago
Stack Trace
#0 /var/www/clients/client180/web812/web/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /var/www/clients/client180/web812/web/library/XenForo/ControllerAdmin/User.php(513): XenForo_DataWriter->save()
#7 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionSave()
#8 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /var/www/clients/client180/web812/web/admin.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
  ["url"] => string(54) "https://www.xxxxxxxxxxxxxxxx.com/admin.php?users/0/save"
  ["_GET"] => array(1) {
    ["users/0/save"] => string(0) ""
  }
  ["_POST"] => array(45) {
    ["username"] => string(11) "NewTestUser"
    ["email"] => string(0) ""
    ["password"] => string(8) "********"
    ["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) ""
    ["custom_fields"] => array(8) {
      ["FavoriteGun"] => string(0) ""
      ["aim"] => 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(11) "CustomField"
      [1] => string(3) "aim"
      [2] => string(3) "icq"
      [3] => string(5) "yahoo"
      [4] => string(5) "skype"
      [5] => string(5) "gtalk"
      [6] => string(8) "facebook"
      [7] => string(7) "twitter"
    }
    ["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"
    ["style_id"] => string(1) "0"
    ["language_id"] => string(1) "6"
    ["timezone"] => string(16) "Europe/Amsterdam"
    ["enable_rte"] => string(1) "1"
    ["enable_flash_uploader"] => string(1) "1"
    ["content_show_signature"] => string(1) "1"
    ["email_on_conversation"] => string(1) "1"
    ["default_watch_state"] => string(11) "watch_email"
    ["visible"] => string(1) "1"
    ["activity_visible"] => string(1) "1"
    ["receive_admin_email"] => string(1) "1"
    ["allow_view_profile_enable"] => string(1) "1"
    ["allow_view_profile"] => string(7) "members"
    ["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(7) "members"
    ["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(7) "members"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(20) "/admin.php?users/add"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Because I recognized the reference to @Daniel Hood 's "User Essentials" add-on I switched that add-on back to enabled and bingo, the user can be created just as expected.

My logic says now, that UserEss is conflicting with other add-ons, but is the origin of the problem, because it generates server errors even if switched OFF....

Right?

 

[Paul B]

The problem is with the add-on; you will need to post in the add-0n thread for support.

It is specifically related to when the add-on is disabled due to an incorrect setting for the database schema.

 

[Freelancer]

Thank you Brogan for analyzing that. Could you please merge this post into the UserEss discussion thread? If not possible I will post it there again.

Edit: Thread can be deleted.

 

[Freelancer]

Update: After testing, I can say that this is caused by one specific add-on only (not even a conflict).