I’m trying to copy simple wordpress from one Local to another (both freshly installed, the second one empty, no add-ons, sites are on preferred configuration) and I can’t import it, because for half of the database it reports duplicate primary key. There is nothing special in the theme or plugins, it’s my standard template and plugin pack I used for years, there is no reason for it to break.
I’ve already exported the site once, but from old Local, 3.3.0 and it imported fine into 5.9.8, now, just slightly changed, it doesn’t. Is the export script broken on 5.9.8?
Here’s the problematic part of log:
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_admin_columns.sql”,“timestamp”:“2021-01-31T18:58:11.159Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_admin_columns.sql”,“timestamp”:“2021-01-31T18:58:11.751Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_comments.sql”,“timestamp”:“2021-01-31T18:58:11.753Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_comments.sql”,“timestamp”:“2021-01-31T18:58:12.398Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_options.sql”,“timestamp”:“2021-01-31T18:58:12.400Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_options.sql”,“timestamp”:“2021-01-31T18:58:13.021Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_postmeta.sql”,“timestamp”:“2021-01-31T18:58:13.023Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘11’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_postmeta.sql”,“timestamp”:“2021-01-31T18:58:13.566Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_posts.sql”,“timestamp”:“2021-01-31T18:58:13.567Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_posts.sql”,“timestamp”:“2021-01-31T18:58:14.102Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_term_relationships.sql”,“timestamp”:“2021-01-31T18:58:14.104Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1-1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_term_relationships.sql”,“timestamp”:“2021-01-31T18:58:14.608Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_term_taxonomy.sql”,“timestamp”:“2021-01-31T18:58:14.609Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_term_taxonomy.sql”,“timestamp”:“2021-01-31T18:58:15.134Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_terms.sql”,“timestamp”:“2021-01-31T18:58:15.135Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_terms.sql”,“timestamp”:“2021-01-31T18:58:15.637Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_usermeta.sql”,“timestamp”:“2021-01-31T18:58:15.638Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_usermeta.sql”,“timestamp”:“2021-01-31T18:58:16.137Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing D:/Local/edge-effects/app/sql/local.wp_users.sql”,“timestamp”:“2021-01-31T18:58:16.138Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1062 (23000) at line 4: Duplicate entry ‘1’ for key ‘PRIMARY’\n at ImporterLocalExport. (%%appPath%%\main\importer\Importer.js:1:9506)\n at Generator.next ()\n at n (%%appPath%%\main\importer\Importer.js:1:132)\n at processTicksAndRejections (internal/process/task_queues.js:94:5)”,“level”:“error”,“message”:“Unable to import D:/Local/edge-effects/app/sql/local.wp_users.sql”,“timestamp”:“2021-01-31T18:58:16.665Z”}