[
https://issues.apache.org/jira/browse/ROL-2167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17442323#comment-17442323
]
Michael Bien commented on ROL-2167:
-----------------------------------
would you like to contribute a pull request on github for this issue?
> SQL-Update-Skript 400-to-500-migration.sql has several errors in SQL syntax
> for Oracle (maybe others, too)
> ----------------------------------------------------------------------------------------------------------
>
> Key: ROL-2167
> URL: https://issues.apache.org/jira/browse/ROL-2167
> Project: Apache Roller
> Issue Type: Bug
> Components: Installation & Configuration
> Affects Versions: 5.0.3, 5.0.4, 5.1.0, 5.1.1, 5.1.2, 5.2.0, 5.2.1, 5.2.2,
> 5.2.3, 5.2.4, 6.0.0, 6.0.1
> Environment: Roller Server on RHEL/Centos Linux 8, Oracle Database ,
> Tomcat 9, OpenJDK 18, Roller 6.0.1
> Reporter: Peter Ohlerich
> Priority: Major
> Labels: patch
> Attachments: 400-to-500-migration.sql.patch
>
>
> The update script 400-to-500-migration.sql has several syntax errors in
> SQL-syntax. Even one error ( Fix for
> https://issues.apache.org/jira/browse/ROL-1760 ) contains a problem when a
> column is populated when updating from a version prior 5.0.0.
>
> This problem occurred when trying to update the database from an inherited
> ancient Roller 4.x database...
> Attached here is a possible fix for the problem as "diff -u "-patch.
>
> (now working on 500-to-510-migration.sql to provide fixes for errors in that
> script)
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
