Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19985

Unable to apply database upgrade on Postgres SQL

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 5.0.0rc1
    • Upgrading
    • Operating System: RHEL 6.3
      PHP Version: 5.3.3
      Database and version: Posgres 8.4.13
      Browser (and version): Firefox 16.0

    Description

      When I try to import update/database/postgresql/5.0/unstable/dbupdate-4.7.0-to-5.0.0alpha1.sql to my Postgres database I get the following errors

      "
      ERROR: syntax error at or near "ALTER"
      LINE 7: ALTER TABLE ezgeneral_digest_user_settings ADD user_id integ...
      ^
      DELETE 0
      ERROR: column "user_id" of relation "ezgeneral_digest_user_settings" does not exist
      LINE 1: UPDATE ezgeneral_digest_user_settings SET user_id = (SELECT ...
      ^
      ERROR: column "user_id" does not exist
      ALTER TABLE
      CREATE INDEX
      "

      I used today's build (6 Nov 2012) #89

      The command I used to import the update was

      psql -U ezp -d ezp -W < update/database/postgresql/5.0/unstable/dbupdate-4.7.0-to-5.0.0alpha1.sql

      Attachments

        Activity

          People

            Unassigned Unassigned
            pedro.resende-obsolete@ez.no Pedro Resende (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h