Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.10.0
-
None
Description
There is a query error when you try to copy a node in admin interface:
ERROR: Duplicate entry '888e7f7cdae36c565673557d36d53f54' for key 2. Query: INSERT INTO ezcontentobject (section_id, owner_id, contentclass_id, name, is_published, published, modified, current_version, status, remote_id, language_mask, initial_language_id) VALUES(1, 57, 49, 'Agenda', 0, 1207654508, 1207654508, 1, 1, '888e7f7cdae36c565673557d36d53f54', 4, 4)
Error: eZDBInterface::commit TRANSID-d150453adcfc19ac27cd296d4393f9d3 Apr 08 2008 13:35:09
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-d150453adcfc19ac27cd296d4393f9d3.
In last update i added unique index for remote_id with this sql.
ALTER TABLE ezcontentobject ADD UNIQUE INDEX ezcontentobject_remote_id(remote_id);
There is a conflict when the function try to copy this object.
Steps to reproduce
Go to admin and try to copy an node.
Attachments
Issue Links
- relates to
-
EZP-9542 ezcontentobject missing DB index on remote_id field
- Closed