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

XF 1.3 After some server problem

Discussion in 'Troubleshooting and Problems' started by ANGEL OF FIRE, Jul 8, 2014.


    ANGEL OF FIRE Member

    After some server problem an error occurred and new user registration does not work now. We have a backup, but not want to roll back.

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '139309' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214
    array(3) {
      ["url"] => string(49) "https://www.xxxxxxxx.net/forum/register/register"
      ["_GET"] => array(0) {
      ["_POST"] => array(14) {
        ["username"] => string(9) "dsfasfdsf"
        ["email"] => string(18) "dafsdfa@googpl.com"
        ["password"] => string(8) "********"
        ["password_confirm"] => string(8) "********"
        ["dob_month"] => string(1) "1"
        ["dob_day"] => string(2) "12"
        ["dob_year"] => string(4) "1980"
        ["gender"] => string(4) "male"
        ["timezone"] => string(16) "Europe/Amsterdam"
        ["recaptcha_challenge_field"] => string(228) "03AHJ_VuuYVLvWk6nslsZNzcmwt0UY7t5V57migeYmM_MnuuG22q5ij9oQaNSD5TuGDrSL6dg9Iq8hm8vsSWDSjPjO9jvzHNf2qbPRpp5vp9e5PQMURHmtjmX62qSHtnVF6hMqtj9gEl9uAUh6ZqAStfxyYpsd752jCBr0M29zn5Z7J0XAGbvUPWcjkByexlmWOPxxejD3GMHHyHfPB1BTpKe54dxCQzso8g"
        ["recaptcha_response_field"] => string(15) "pndivera Barcia"
        ["agree"] => string(1) "1"
        ["_xfToken"] => string(8) "********"
        ["reg_key"] => string(32) "b153e1f87260c8a87bdcc725ea91f2dc"
    How to fix this error?
  2. Liam W

    Liam W Well-Known Member

    What's the full stack trace?

    ANGEL OF FIRE Member

    #0 /var/www/xxxxxxx.net/htdocs/forum/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/xxxxxxx.net/htdocs/forum/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/xxxxxxx.net/htdocs/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user_profile', Array)
    #4 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/ControllerPublic/Register.php(281): XenForo_DataWriter->save()
    #7 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Register->actionRegister()
    #8 /var/www/xxxxxxx.net/htdocs/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/xxxxxxx.net/htdocs/forum/index.php(13): XenForo_FrontController->run()
    #10 {main}
  4. Mike

    Mike XenForo Developer Staff Member

    Based on that, you have some amount of corrupt/out of sync data in your DB -- at least one table (xf_user) is missing data that exists in another (xf_user_profile). Strictly speaking, I would recommend reverting to a known, consistent backup. You may be able to get away with attempting to register until it goes through (it should eventually; the number in the error should keep going up), but that doesn't account for inconsistent data elsewhere.

Share This Page