Airtime
  1. Airtime
  2. CC-3732

NationTalk Database upgrade fail, from 2.0.3 to 2.1.0

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: None
    • Labels:
      None
    • Originating Party:
      QA
    • OS:
      Ubuntu 11.04
    • Browser:
      Firefox

      Description

      When I try to upgrade from 2.0.3 to 2.1.0 with nationaltalk database, I encounter following errors:

      [PDOException]
        SQLSTATE[23502]: Not null violation: 7 ERROR: column "created" contains null values
                                                                                              


      migrations:migrate [--write-sql] [--dry-run] [--configuration[="..."]] [--db-configuration[="..."]] [-h|--help] [-q|--quiet] [-v|--verbose] [-V|--version] [-a|--ansi] [-n|--no-interaction] command [version]


      PHP Fatal error: Uncaught exception 'PropelException' with message 'Unable to execute SELECT statement [SELECT cc_show_instances.ID, cc_show_instances.STARTS, cc_show_instances.ENDS, cc_show_instances.SHOW_ID, cc_show_instances.RECORD, cc_show_instances.REBROADCAST, cc_show_instances.INSTANCE_ID, cc_show_instances.FILE_ID, cc_show_instances.TIME_FILLED, cc_show_instances.CREATED, cc_show_instances.LAST_SCHEDULED, cc_show_instances.MODIFIED_INSTANCE FROM cc_show_instances WHERE cc_show_instances.STARTS>=:p1] [wrapped: SQLSTATE[42703]: Undefined column: 7 ERROR: column cc_show_instances.created does not exist
      LINE 1: ...instances.FILE_ID, cc_show_instances.TIME_FILLED, cc_show_in...
                                                                   ^]' in /home/airtimeqa/source/airtime/airtime_mvc/library/propel/runtime/lib/query/ModelCriteria.php:1045
      Stack trace:
      #0 /home/airtimeqa/source/airtime/airtime_mvc/library/propel/runtime/lib/query/ModelCriteria.php(909): ModelCriteria->getSelectStatement(Object(PropelPDO))
      #1 /home/airti in /home/airtimeqa/source/airtime/airtime_mvc/library/propel/runtime/lib/query/ModelCriteria.php on line 1045

        Activity

        Hide
        Cliff Wang
        added a comment -
        Do another verification, it fails with same errors
        Show
        Cliff Wang
        added a comment - Do another verification, it fails with same errors
        Hide
        Cliff Wang
        added a comment -
        Fixed, verified at Airtime 2.1.0+b644644
        Show
        Cliff Wang
        added a comment - Fixed, verified at Airtime 2.1.0+b644644

          People

          • Assignee:
            Cliff Wang
            Reporter:
            Cliff Wang
            Implemented by:
            Martin Konecny
            Tested by:
            Cliff Wang
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: