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

Database transaction error when search phrase longer than 250 characters

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • 3.10.0, 3.9.4, 4.0.0
    • Database related, Search
    • None

    • eZ Publish 3.9 - 4.5

    Description

      In content/search, insert a phrase longer than 250 characters. You will get a database transaction error, due to the 250 length limit of the phrase column in ezsearch_search_phrace table.

      Query error: Data too long for column 'phrase' at row 1. Query: INSERT INTO
                              ezsearch_search_phrase ( phrase, phrase_count, result_count )
                         VALUES ( 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...

      Attachments

        Activity

          People

            jv@ez.no jv@ez.no
            cyberwolf cyberwolf
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: