Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-23787

Fatal error at adding ezdatetime to a content class

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • None
    • 2014.11
    • Database related
    • 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

          Activity

            People

              Unassigned Unassigned
              emil.webber emil.webber
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: