Getting duplicate entry in db when adding a new page
Permalink 1 user found helpful
I just upgraded to 5.6.0.2 and it failed with all sorts of messages. I restored a backup I took prior to the upgrade. When I look it says I am running 5.6.0.2 - even though I did a restore. Now when I attempt to add a new page I get the following:
mysql error: [1062: Duplicate entry '395' for key 1] in EXECUTE("insert into Pages (cID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID) values ('395', '1', '1', 'PARENT', '1', '1', 17, 0)")
Any ideas as to why this is happening?
mysql error: [1062: Duplicate entry '395' for key 1] in EXECUTE("insert into Pages (cID, cParentID, uID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cInheritPermissionsFromCID, cDisplayOrder, pkgID) values ('395', '1', '1', 'PARENT', '1', '1', 17, 0)")
Any ideas as to why this is happening?
Have you deleted the upgrades folder? If not it will still be trying to load 5.6.0.2 but the DB won't be matching and thus causing the error
That worked. Thanks so much!
"spoke" too soon. Now when I edit an existing block and click save (content block), I get the following:
An unexpected error occurred. mysql error: [1062: Duplicate entry '1011' for key 1] in EXECUTE("INSERT INTO btContentLocal(bID,content) VALUES ('1011','test')") < Back to Home
In the example above (after trying to edit an existing block), I added a new block and saved it successfully, I then went back in edited it, when I hit save, I received the above message.
An unexpected error occurred. mysql error: [1062: Duplicate entry '1011' for key 1] in EXECUTE("INSERT INTO btContentLocal(bID,content) VALUES ('1011','test')") < Back to Home
In the example above (after trying to edit an existing block), I added a new block and saved it successfully, I then went back in edited it, when I hit save, I received the above message.
