ExportXMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Normal
    • Component/s: 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.

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

              Created:
              Updated:
              Resolved:

                Version Package