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

[Digital Doctor]

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

 

[Jeremy]

These are almost entirely due to add-ons.

 

[Digital Doctor]

And importing.

 

[Alpha1]

http://xenforo.com/community/threads/extended-smilie-sql-import.58913/#post-653956
http://xfaddons.com/threads/duplicate-entry-1087-for-key-primary.211/

I'm beginning to wonder if this is a XF 1.2 bug.

 

[Jeremy]

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

 

[Alpha1]

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

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.