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

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Blocker 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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: