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

Long word in forum text breaks posting + search indexes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Component/s: Forums
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package