[
https://issues.apache.org/jira/browse/ROL-2174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17465085#comment-17465085
]
David M. Johnson edited comment on ROL-2174 at 12/24/21, 10:28 PM:
-------------------------------------------------------------------
Fixed by this commit:
[https://github.com/apache/roller/commit/826751ce16f4068736675c91920a4179350e631d]
was (Author: snoopdave):
Fixed by this commit:
[https://github.com/apache/roller/commit/826751ce16f4068736675c91920a4179350e631d]
!image-2021-12-24-17-27-25-519.png|width=537,height=183!
> 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
> Priority: Major
>
> 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)
