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

XF 1.2 Mysqli statement execute error : Duplicate entry for key 'PRIMARY'

Discussion in 'Troubleshooting and Problems' started by Digital Doctor, Oct 10, 2013.

  1. Digital Doctor

    Digital Doctor Well-Known Member

    Seems like there is an increase in these types of errors ?
    Maybe this thread could be used to troubleshoot them (not sure that is possible).

    The generic error is: Mysqli statement execute error : Duplicate entry for key 'PRIMARY'

    Xenforo search results [here]

    example (1) : Mysqli statement execute error : Duplicate entry '5' for key 'PRIMARY'
    Error vB4 Importer. [thread]

    Note: Chris Deeming got this error by disabling addons in quick succession. [thread]
    Kier added Chris' fix.

    Other example threads with this error.

    http://xenforo.com/community/threads/conversation-essentials-paid.27874/page-21#post-646149

    http://xenforo.com/community/threads/liquidpro-simple-forms-paid.27945/page-36#post-644733

    http://xenforo.com/community/threads/better-blogs.36836/page-46#post-639589
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    These are almost entirely due to add-ons.
     
    Digital Doctor likes this.
  3. Digital Doctor

    Digital Doctor Well-Known Member

    And importing.
     
  4. Alfa1

    Alfa1 Well-Known Member

  5. Jeremy

    Jeremy XenForo Moderator Staff Member

    It's not. If an add-on attempts to write a row with the same ID, it happens.
     
  6. Alfa1

    Alfa1 Well-Known Member

    The issue seems to occur mainly when an import is interrupted (which happens frequently with large databases) and the same ID is written to twice. Can this be the case?

    This issue in its various forms just keeps reoccuring with various addons. Even on fresh installs.
     

Share This Page