Uploaded image for project: 'Ibexa IBX'
  1. Ibexa IBX
  2. IBX-4832

PosgreSQL: Unable to create content with language id higher than 2^32

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      1. Create Ibexa instance installed on PostgreSQL
      2. Create more than 32 languages
      3. Try creating a Content item in language which ID overflows 2^32 (or use the language with the highest ID, if you created more than 32).

      Actual result

      See Database error, e.g.:

      An exception occurred while executing 'INSERT INTO ezcontentobject_name (contentobject_id, content_version, content_translation, name, language_id, real_translation) VALUES(?, ?, ?, ?, (SELECT CASE WHEN (initial_language_id = ? AND (language_mask & ?) <> 0 ) THEN (? | 1) ELSE ? END FROM ezcontentobject WHERE id = ?), ?)' with params [66, 3, "pol-PL", "Article", 281474976710656, 281474976710656, 281474976710656, 281474976710656, 66, "pol-PL"]: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value "281474976710656" is out of range for type integer 

      Expected result

      Content item gets created with no issues.

      Designs

        Attachments

          Activity

            People

              andrew.longosz@ibexa.co Andrew Longosz
              andrew.longosz@ibexa.co Andrew Longosz
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: