Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-695

OfOffline table should use longtext for message storing

    XMLWordPrintable

    Details

      Description

      To store non-latin messages in the offline storage UTF8 should be enabled in the database. But with the current setup (text type field) it can't store UTF8 text and throws error:

      at java.lang.Thread.run(Unknown Source)
      2013.09.06 10:46:11 org.jivesoftware.openfire.OfflineMessageStore - Internal server error
      java.sql.SQLException: Incorrect string value: '\xD0\xBF\xD1\x80\xD0\xBE...' for column 'stanza' at row 1

      Changing stanza to longtext type should fix this issue. Probably all database scripts should be updated.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              wroot wroot
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: