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

Textline legacy search indexing causes TransactionError

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Medium Medium
    • Resolution: Fixed
    • Affects Version/s: 4.5.0, 4.6.0, 4.7.0, 5.0, 5.1, 5.2, 2014.11, dev-master
    • Fix Version/s: 2017.12
    • Component/s: Legacy stack
    • Labels:

      Description

      Create a ContentType with Textline field type.
      Enter a long integer value as content f.e. 3851071005 for this field.
      Save content, a fatal error occurs:

      Example SQL:
      INSERT INTO
      ezsearch_object_word_link
      ( word_id,
      contentobject_id,
      frequency,
      placement,
      next_word_id,
      prev_word_id,
      contentclass_id,
      contentclass_attribute_id,
      published,
      section_id,
      identifier,
      integer_value )
      VALUES ( '1800', '462', '0', '8', '1801', '1806', '4', '370', '1472056666', '2', 'zendesk_userid', '3851071005' );

      Causes SQL error:
      #1264 - Out of range value for column 'integer_value' at row 1

      on integerValue generation the value needs to be verified against MySQL's max int value. A patch proposal which fixes this is attached.

        Activity

        Show
        Artur Wawrzynkiewicz added a comment - - edited PR: https://github.com/ezsystems/ezpublish-legacy/pull/1268
        Show
        André Rømcke added a comment - Merged alternative PR 1338: https://github.com/ezsystems/ezpublish-legacy/commit/59d2c2b12e2e8aed99cfc9ce4be2bdef7311af9a

          People

          • Assignee:
            Unassigned
            Reporter:
            Artur Wawrzynkiewicz
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: