XF 1.3 After some server problem

[ANGEL OF FIRE]

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?

 

[Liam W]

What's the full stack trace?

 

[ANGEL OF FIRE]

#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}

 

[Mike]

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.