Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hello!
I've recently migrated our Laravel application to DigitalOcean, and I keep getting this error: "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '20' for key 'drag_drop_pages.PRIMARY' (SQL: insert into drag_drop_pages (artwork, draggables, draggablesText, updated_at, created_at) values (, [], ["dictation","frac","life"], 2022-10-30 10:07:21, 2022-10-30 10:07:21))". I'm not sure what could be happening here? It worked fine before we moved the database over to the new servers.
Any help would be greatly appreciated!
A constraint violation means that a duplicate entry for a unique field is trying to be created. There is already a row (id of 20) in your `drag_drop_pages' table, that has a unique value for which ever field is set to be unique.
are you getting this error when using the app? Or when running migrate?
Show the migration for the table and the code that causes the error
Some rows are having the same value 20 for the primary key on drag_drop_pages table, when you are seeding the database, make sure your primary key can auto-increment, or manually check the rows if they have duplicate values.
Please or to participate in this conversation.