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

XF 1.4 Mysqli error, users cannot create accounts

Discussion in 'Troubleshooting and Problems' started by Niekiletta, Jul 22, 2015.

  1. Niekiletta

    Niekiletta New Member

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

    Mike XenForo Developer Staff Member

    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.
     
  3. Niekiletta

    Niekiletta New Member

    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"
    }
    }
     
    Last edited: Jul 22, 2015

Share This Page