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

Textline legacy search indexing causes TransactionError

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 2017.12
    • 4.5.0, 4.6.0, 4.7.0, 5.0, 5.1, 5.2, 2014.11, dev-master
    • Legacy stack

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ae86293c-2b95-4cf0-8e9e-5d57dd46c648@accounts.ibexa.co Artur Wawrzynkiewicz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: