After a few hours looking into this problem, I found out that the import of the pre-production database onto the real production site, didn’t restore the table structure properly! It missed the auto increment flags (which is the thing that causes this error), and it didn’t restore the proper collation setting.
I made the settings equal for all 11 tables to the pre-production database that I’d still running on my local NAS and problem solved :)!
