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

Server Error / Duplicate Entry

Discussion in 'Installation, Upgrade, and Import Support' started by Onimua, Feb 22, 2011.

  1. Onimua

    Onimua Well-Known Member

    When trying to run the upgrade, it stalls almost as soon as it starts with this:

    Server Error
    Mysqli statement execute error : Duplicate entry '1147-0' for key 'definition_id_style_id'
       1. Zend_Db_Statement_Mysqli->_execute() in /Applications/MAMP/htdocs/XenForo/library/Zend/Db/Statement.php at line 297
       2. Zend_Db_Statement->execute() in /Applications/MAMP/htdocs/XenForo/library/Zend/Db/Adapter/Abstract.php at line 479
       3. Zend_Db_Adapter_Abstract->query() in /Applications/MAMP/htdocs/XenForo/library/Zend/Db/Adapter/Abstract.php at line 574
       4. Zend_Db_Adapter_Abstract->insert() in /Applications/MAMP/htdocs/XenForo/library/XenForo/DataWriter.php at line 1500
       5. XenForo_DataWriter->_insert() in /Applications/MAMP/htdocs/XenForo/library/XenForo/DataWriter.php at line 1489
       6. XenForo_DataWriter->_save() in /Applications/MAMP/htdocs/XenForo/library/XenForo/DataWriter.php at line 1291
       7. XenForo_DataWriter->save() in /Applications/MAMP/htdocs/XenForo/library/XenForo/Model/StyleProperty.php at line 1180
       8. XenForo_Model_StyleProperty->updateStylePropertyValue() in /Applications/MAMP/htdocs/XenForo/library/XenForo/Model/StyleProperty.php at line 2272
       9. XenForo_Model_StyleProperty->importStylePropertiesFromArray() in /Applications/MAMP/htdocs/XenForo/library/XenForo/Model/StyleProperty.php at line 2146
      10. XenForo_Model_StyleProperty->importStylePropertyXml() in /Applications/MAMP/htdocs/XenForo/library/XenForo/Model/StyleProperty.php at line 2079
      11. XenForo_Model_StyleProperty->importStylePropertyDevelopmentXml() in /Applications/MAMP/htdocs/XenForo/library/XenForo/CacheRebuilder/ImportMasterData.php at line 42
      12. XenForo_CacheRebuilder_ImportMasterData->rebuild() in /Applications/MAMP/htdocs/XenForo/library/XenForo/ControllerHelper/CacheRebuild.php at line 26
      13. XenForo_ControllerHelper_CacheRebuild->rebuildCache() in /Applications/MAMP/htdocs/XenForo/library/XenForo/Install/Controller/Upgrade.php at line 181
      14. XenForo_Install_Controller_Upgrade->actionRebuild() in /Applications/MAMP/htdocs/XenForo/library/XenForo/FrontController.php at line 310
      15. XenForo_FrontController->dispatch() in /Applications/MAMP/htdocs/XenForo/library/XenForo/FrontController.php at line 132
      16. XenForo_FrontController->run() in /Applications/MAMP/htdocs/XenForo/install/index.php at line 17
    Not sure where I should look or what to do to try and resolve it.
  2. Mike

    Mike XenForo Developer Staff Member

    Not something I've seen before. Does it happen on a refresh? Do you have any add-ons installed?

    Can you dump the contents of the xf_style_property, xf_style_property_definition, and xf_style_property_group tables?
  3. Onimua

    Onimua Well-Known Member

    I disabled add-ons before upgrading, and I do have a couple of styles but I have been able to upgrade previously with no issues. I've tried rerunning it but it doesn't want to go through.

    I had also created style property groups but deleted them; would that have any effect on this?

    Attached Files:

  4. Onimua

    Onimua Well-Known Member

    Actually, if I try rerunning it, it increments the ID error.

    Mysqli statement execute error : Duplicate entry '1148-0' for key 'definition_id_style_id'
    It's now '1148'.
  5. Mike

    Mike XenForo Developer Staff Member

    Well, I can reproduce it with your data, so that's a good sign... :)
  6. Mike

    Mike XenForo Developer Staff Member

    Hmm, I reproduced it once and then it worked -- really weird.
  7. Mike

    Mike XenForo Developer Staff Member

    Aha, the reason is that you have style properties that correspond to definitions that don't exist (1144 - 1148). I'm not totally sure how this would happen. That explains why it fixes itself after one run, as 1148 is the last conflict.
  8. Onimua

    Onimua Well-Known Member

    Hm... what if I created a style property group, then created options with in it but deleted it. And it just so happens they don't get removed because XenForo doesn't delete them from the database... I happen to notice and delete them manually. This was related to this bug I reported earlier.

    And... after double checking, it's present in RC3 (not deleting the group/definitions even though you select Delete and confirm it). Guess it's a bug?

    Does that mean if I run the install again it should work and there shouldn't be any problems in the future from this?
  9. Mike

    Mike XenForo Developer Staff Member

    Yeah, the next run should get you out of the overlapping elements and it will import correctly.

    If you're finding that things aren't deleted when you expect, please report that as a bug.
  10. Onimua

    Onimua Well-Known Member

    Ah, it went through. :)

    I'll go report that other issue.

Share This Page