
eZ Publish - Object Relation Attributes - Reckless Cleanup
This is NOT A FIX for the code, but if you are getting confusing results for queries due to relationships between object relation attributes which were deleted from content classes, you may use this query:
Backup your database first
This is not for the faint of heart
There are no warranties or other guarantees - use this at your own risk.
DELETE FROM ezcontentobject_link WHERE contentclassattribute_id != 0 AND NOT EXISTS (SELECT * FROM ezcontentclass_attribute WHERE ezcontentclass_attribute.id = ezcontentobject_link.contentclassattribute_id);
Print article | This entry was posted by elvis on 07/21/14 at 02:58:00 pm . Follow any responses to this post through RSS 2.0. |