Uploaded image for project: 'Other'
  1. Other
  2. OTHER-234

Long word in forum text breaks posting + search indexes

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • Forums
    • None

      Trying to insert a post with long word with Cyrillic characters ("Константинович") totally breaks search index insert:

      ```
      Sorry! The page could not be loaded.

      This is probably a temporary error. Just refresh the page and retry. If problem continues, please check back in 5-10 minutes.

      Database reported: ERROR: value too long for type character varying(20) .

      Failed query: INSERT INTO search_words (word) VALUES('константинович')

      The error occurred on line 151 in /home/forums/htdocs/include/search_idx.php
      ```

      From my POV, that's a shooting offense for a programmer who thought that "20 bytes would be enough for everybody". Also, it's probably a sign of screwed up SQL scheme, i.e. missing encodings.

            Unassigned Unassigned
            greycat Mikhail Yakshin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package