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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.