Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.10.0, 3.9.4, 4.0.0alpha2
-
None
Description
Execute the following SQL and you will see it:
SELECT * FROM ezcontentobject_name e where NOT EXISTS ( select * from ezcontentobject_version v where v.contentobject_id=e.contentobject_id and v.version = e.content_version );
SQL to remove:
DELETE FROM ezcontentobject_name e WHERE NOT EXISTS (SELECT * FROM ezcontentobject_version v WHERE v.contentobject_id=e.contentobject_id AND v.version = e.content_version);