Unable to Move Pages - Tree is Not Displayed in Edit Mode Due to DB Case Sensitivity
There may be a small performance hit due to the workaround described in Unable to Move Pages - Tree is Not Displayed in Edit Mode Due to DB Case Sensitivity.
- url: /pages/children.action | userName: ******** | action: children | space: 13205506 ognl.OgnlException: JSONString [org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar ; nested exception is java.sql.SQLException: Invalid column name 'title'.
Queries that use 'lower' do not use index because of case sensitivity.
Set the database collation to case-insensitive. Be aware that some complications could arise later down the track if you use case-insensitive database collation during migration. For more information, please refer to the Migrate to Another Database document in the Confluence documentation space.