Unable to start confluence

[Michael Spears]

Hello,

I'm getting the following error after moving my Confluence database to a new server:

could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

How would I be able to fix this?

[Michael Spears]

Ended up being a matter of the db import not going through properly... all fixed now.

[Samu Hynynen]

Good to hear everything went down OK. Did you manage to find out what went wrong with the import?

[JP _AC Bielefeld Leader_]

Hi,

I assume the new database server is the exact same version & has the exact same access control as the old server. Can you access the new database server & confluence database using the credentials configured in Confluence? 

Best

JP

[Samu Hynynen]

Sounds like you're facing a collation or character set issue with the new database. You should read this trough:

https://confluence.atlassian.com/confkb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-670958160.html