Import docx fails (system error)

gord

Any time I try to import a document to a space - i get the following:

 

Cause

org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1366]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:248)

caused by: org.hibernate.exception.GenericJDBCException: could not execute statement
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x89</...' for column 'BODY' at row 1
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)

Shannon S

Gord,

Welcome to Atlassian Community! It's nice to have you.

Can you tell me the following:

1. What version of Confluence are you running?
2. What database version are you running Confluence on? Note: If you are on the embedded H2 database, at this time, you will need to migrate off of it onto a supported database. See Migrating to Another Database.
3. Can you let us know exactly what you're trying to do? Are you attaching a document to a page in Confluence, or are you trying to create a page in a Confluence space using a Word document?
4. What encoding are you using for Confluence and your database? See Troubleshooting Character Encodings for more details.
5. Does this error occur for any documents?
6. When did this last work?
7. Does this occur in other spaces?

Thank you for your help!

Regards,

Shannon