Art O Cathain created ROL-2174:
----------------------------------
Summary: DB upgrade fails on MySQL 5.6
Key: ROL-2174
URL: https://issues.apache.org/jira/browse/ROL-2174
Project: Apache Roller
Issue Type: Bug
Affects Versions: 6.1.0
Reporter: Art O Cathain
The following error shows up in the logs
{{{}{}}}{{{}ERROR 2021-12-22 23:21:15 [http-nio-8080-exec-5] DatabaseInstaller
- Problem upgrading database to version 610{}}}
{{com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for th}}
{{e right syntax to use near 'column blacklist to bannedwordslist' at line 1}}
This is debian MySQL version 5.6.30-1.
{{It looks like the 'rename column' syntax isn't supported until MySQL 8:
https://stackoverflow.com/a/30290915}}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
