[ROL-2167] SQL-Update-Skript 400-to-500-migration.sql has several errors in SQL syntax for Oracle (maybe others, too)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 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
• Component/s: Installation & Configuration
• Labels: patch
• Environment: Roller Server on RHEL/Centos Linux 8, Oracle Database , Tomcat 9, OpenJDK 18, Roller 6.0.1
• Browser Version: Firefox 83.0
• Database: Oracle Database Enterprise Ed. 19.0.3
• JDK Version: OpenJDK 18.9
• O/S Version: Red Hat Enterprise Linux release 8.3 (Ootpa)
• Flags: Patch
• Assignee: Unassigned
• Reporter: Peter Ohlerich
• Created: 03/Dec/20 16:37
• Updated: 18/Sep/23 00:07

Description

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)