Details
-
Bug
-
Resolution: Duplicate
-
Blocker
-
None
-
2014.11
-
None
Description
Hi,
if you add a datetime attribute to a content class, you will get an transaction error.
The sql has an error:
[ Dec 11 2014 16:21:32 ] [127.0.0.1] eZMySQLiDB:
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 '
FROM ezcontentobject_attribute a, ezcontentobject o
WH' at line 2. Query: INSERT INTO ezcontentobject_attribute( contentobject_id, version, contentclassattribute_id, data_type_string, language_code, language_id, data_int, sort_key_int )
SELECT a.contentobject_id, a.version, 877, 'ezdatetime', a.language_code, MAX(a.language_id), ,
FROM ezcontentobject_attribute a, ezcontentobject o
WHERE o.id = a.contentobject_id AND
o.contentclass_id=47
GROUP BY contentobject_id,
version,
language_code
[ Dec 11 2014 16:21:32 ] [127.0.0.1] eZDBInterface::commit TRANSID-c7133c27025315b668a05eab5c1a8848:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-c7133c27025315b668a05eab5c1a8848.
Best wishes,
Georg.
Attachments
Issue Links
- duplicates
-
EZP-23527 ezdatetime with no default value causes class edit to fail
- Closed