Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
4.4.0, 4.5.0
-
None
Description
It happens when the image object is created without the actual image and it is moved to trash.
It seems to work in 4.3
Steps to reproduce
Steps to reproduce:
1. Create an object class Image
1.1. Fill in the name attribute and send it for publishing without adding an image
2. After publishing find the node of the object and click "remove" button
2.1. Make sure that "Move to trash" checkbox is checked.
2.2. Click "OK" button
3. This procedure leads to creating a corrupted SQL query:
SELECT id, contentobject_attribute_id, filepath
FROM ezimagefile WHERE contentobject_attribute_id='XXX' AND filepath IN ( )
and this leads to a fatal error:
Query error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2. Query: SELECT id, contentobject_attribute_id, filepath FROM ezimagefile WHERE contentobject_attribute_id='XXX' AND filepath IN ( )