Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
2.0
-
None
-
PostgreSQL
Description
PostgreSQL users upgrading from Roller 1.3 to Roller 2.0 run into fatal errors during Roller startup.
There are two parts to the problem:
- The first query in upgradeTo200() is not compatible with PostgreSQL
- The 130-to-200 script for PostgreSQL has multiple errors in the ALTER TABLE statements
I've got a fix for this. At a mininum, we'll need to provide fixes for these files:
- WEB-INF/lib/rollerbeans.jar
- WEB-INF/dbscripts/postgresql/130-to-200-migration.sql