PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-24949

Incorrect string value: '\xE2\x80\x8F' for column 'subject' at row 1

    Details

    • Similar Issues:
      Show 5 results 

      Description

      Never seen this problem on the 1 version before this. Only see this, seems like related to the Mail portlet issue i raised earlier. Not sure what's wrong?

      Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE2\x80\x8F' for column 'subject' at row 1
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
      at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

        Activity

        Hide
        Szymon Golebiewski added a comment -

        In most cases it means that you don't have UTF-8 collation set for your tables in database. Check database default collation (should be UTF8), then table collation and at the very end collation of column "subject" in table "mail_message".

        Did it help?

        Show
        Szymon Golebiewski added a comment - In most cases it means that you don't have UTF-8 collation set for your tables in database. Check database default collation (should be UTF8), then table collation and at the very end collation of column "subject" in table "mail_message". Did it help?
        Hide
        Szymon Golebiewski added a comment -

        I assume it helped

        This issue can be closed.

        Show
        Szymon Golebiewski added a comment - I assume it helped This issue can be closed.
        Hide
        Michael Saechang added a comment -

        Closing ticket as per Szymon's comment. Thank you for verifying.

        Show
        Michael Saechang added a comment - Closing ticket as per Szymon's comment. Thank you for verifying.

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              3 years, 13 weeks, 5 days ago

              Development

                Structure Helper Panel