Peter Ohlerich created ROL-2167:
-----------------------------------
Summary: 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: 6.0.1, 6.0.0, 5.2.4, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.2,
5.1.1, 5.1.0, 5.0.4, 5.0.3
Environment: Roller Server on RHEL/Centos Linux 8, Oracle Database ,
Tomcat 9, OpenJDK 18, Roller 6.0.1
Reporter: Peter Ohlerich
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.3.4#803005)
