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

Unable to apply database upgrade on Postgres SQL

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.0.0rc1
    • Component/s: Upgrading
    • Labels:
    • Environment:

      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

        Activity

        Show
        Damien Pobel (Inactive) added a comment - Fixed in ezpublish: master: http://github.com/ezsystems/ezpublish/commit/b3088c8a58bec407b48059bd37f2247b5ccee3e5
        Hide
        Pedro Resende (Inactive) added a comment -

        Tested and approved by Q.A.

        Show
        Pedro Resende (Inactive) added a comment - Tested and approved by Q.A.

          People

          • Assignee:
            Unassigned
            Reporter:
            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