XF 1.4 Mysqli error, users cannot create accounts

[Niekiletta]

This has been happening since. I had my host roll back the website several days. what does it mean? how do I fix it?

 

[Mike]

This has been happening since. I had my host roll back the website several days

Because of this, it means they didn't roll back the site properly, which means there's inconsistent data in the database (there are records in tables pointing to users that don't exist).

The ideal world would be a fresh restore to ensure that the data is consistent, but I don't know how their backups are taken or what their restore process is specifically. If this isn't viable, we may be able to work out an alternative, but the database being in this state isn't ideal and it concerns me about what issues might be found in other tables.

 

[Niekiletta]

They keep backups for 5 days, is that's not really an option. I took a look at the user table, there are no users between 294 and 309?!? 309, 310, 311 are users I created.. But when I try to log in as them, they do not exist

I hope the following server error log will give you further insight.

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '308' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Lucent, Today at 2:43 AM
Stack Trace
#0 /home/safegami/public_html/community/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/safegami/public_html/community/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/safegami/public_html/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/safegami/public_html/community/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user_profile', Array)
#4 /home/safegami/public_html/community/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
#5 /home/safegami/public_html/community/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
#6 /home/safegami/public_html/community/library/*******/Credits/DataWriter/User.php(23): XenForo_DataWriter->save()
#7 /home/safegami/public_html/community/library/XenForo/ControllerAdmin/User.php(513): *******_Credits_DataWriter_User->save()
#8 /home/safegami/public_html/community/library/*******/Credits/ControllerAdmin/User.php(7): XenForo_ControllerAdmin_User->actionSave()
#9 /home/safegami/public_html/community/library/XenForo/FrontController.php(347): *******_Credits_ControllerAdmin_User->actionSave()
#10 /home/safegami/public_html/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/safegami/public_html/community/admin.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
["url"] => string(58) "Safe Gaming Zone - Admin Control Panel Login | Admin CP - Safe Gaming Zone"
["_GET"] => array(1) {
["users/0/save"] => string(0) ""
}
["_POST"] => array(46) {
["username"] => string(8) "Testing "
["email"] => string(21) "Testing@somewhere.com"
["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) ""
["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(7) {
["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(7) {
[0] => string(3) "aim"
[1] => string(3) "icq"
[2] => string(5) "yahoo"
[3] => string(5) "skype"
[4] => string(5) "gtalk"
[5] => string(8) "facebook"
[6] => string(7) "twitter"
}
["style_id"] => string(1) "0"
["language_id"] => string(1) "1"
["timezone"] => string(16) "America/New_York"
["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(14) "watch_no_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(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) "followed"
["credits"] => string(1) "0"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(30) "/community/admin.php?users/add"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}