Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-910

Errors in PostgreSQL upgrade script and code for Roller 2.0

    Details

    • Database:
      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

        Attachments

          Activity

            People

            • Assignee:
              djohnson David Johnson
              Reporter:
              djohnson David Johnson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: