Issues with database migration from Mac OS X to Debian Linux

[Andrew Preece]

Error occurred during template rendering: Invocation of method 'getLogoForGlobalcontext' in class $Proxy43 threw exception org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.CONTENT' doesn't exist at template/includes/macros.vm line 1351, column 43 . Contact your administrator for assistance.

[Bruna Griebeler · Accepted solution]

Hi Andy.

In fact this table should exists but I believe your MySQL should be set to understand the table names both in upper and lowercase.

I suggest you to include the lower_case_table_names = 1 line on the mysqld section on your /etc/mysql/my.cnf.

Example:

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
lower_case_table_names = 1
transaction-isolation=READ-COMMITTED

After that, restart both, Mysql and Confluence.

Hope it helps!