Newscoop
  1. Newscoop
  2. CS-4347

Upgrade process breaks when trying to alter an non-existing table

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.0.1
    • Component/s: Upgrade Scripts
    • Labels:
      None
    • Originating Party:
      Developer

      Description

      When running the newscoop-restore script to restore a backup (on upgrade), it fails throwing this error:

      * Upgrading the database from version 3.5.x...
      ERROR!
      tables.sql (3.5.x) errors on:
      ALTER TABLE `article_datetimes` ADD COLUMN `event_comment` TEXT;
      Table 'newscoop.article_datetimes' doesn't exist

        Activity

        Hide
        Martin Saturka
        added a comment -
        Was that at a regular Newscoop instance, or some instance where its database contains a modified database, i.e. 3.5.x with some added tables?
        The database version checking can fail then (on version before the "Versions" tables started to be used).
        Show
        Martin Saturka
        added a comment - Was that at a regular Newscoop instance, or some instance where its database contains a modified database, i.e. 3.5.x with some added tables? The database version checking can fail then (on version before the "Versions" tables started to be used).
        Hide
        Petr Jasek
        added a comment -
        i think problem was with 3.6 beta3 but not sure if we support that upgrade
        Show
        Petr Jasek
        added a comment - i think problem was with 3.6 beta3 but not sure if we support that upgrade
        Hide
        Martin Saturka
        added a comment -
        AFAIK, we did not have support for upgrades from betas before 4.0 rc2.
        Show
        Martin Saturka
        added a comment - AFAIK, we did not have support for upgrades from betas before 4.0 rc2.

          People

          • Assignee:
            Sebastian Šimon
            Reporter:
            Holman Romero
            Tested by:
            Sebastian Šimon
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 1 hour
              1h
              Remaining:
              Remaining Estimate - 1 hour
              1h
              Logged:
              Time Spent - Not Specified
              Not Specified