We just pulled the latest code and when trying to via the admin control panel, we ge the following:
string(20234) "12 error(s) encountered during migration
========================================
Error #1 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'region_id'. Failing Query: "ALTER TABLE addresses ADD region_id INT DEFAULT '0' NOT NULL"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE add...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE add...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('addresses', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 84)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #2 - SQLSTATE[HY000]: General error: 1005 Can't create table 'shineisp0.#sql-69a_180d' (errno: 150). Failing Query: "ALTER TABLE addresses ADD CONSTRAINT addresses_region_id_regions_region_id FOREIGN KEY (region_id) REFERENCES regions(region_id)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE add...')
#1 /home/shineisp/web/library/Doctrine/Export.php(524): Doctrine_Connection->execute('ALTER TABLE add...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(184): Doctrine_Export->createForeignKey('addresses', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedForeignKey(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 85)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #3 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'addresses_region_id_idx'. Failing Query: "CREATE INDEX addresses_region_id_idx ON addresses (region_id)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE INDEX ad...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE INDEX ad...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('addresses', 'addresses_regio...', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 85)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #4 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'callback_url'. Failing Query: "ALTER TABLE orders_items ADD callback_url VARCHAR(200)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders_items', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 86)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #5 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'uuid'. Failing Query: "ALTER TABLE orders_items ADD uuid VARCHAR(50)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders_items', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 86)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #6 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_access_tokens' already exists. Failing Query: "CREATE TABLE oauth_access_tokens (id INT UNSIGNED AUTO_INCREMENT, access_token VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_access_to...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #7 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_authorization_codes' already exists. Failing Query: "CREATE TABLE oauth_authorization_codes (id INT UNSIGNED AUTO_INCREMENT, authorization_code VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, redirect_url TEXT, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_authoriza...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #8 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_clients' already exists. Failing Query: "CREATE TABLE oauth_clients (id INT UNSIGNED AUTO_INCREMENT, client_id VARCHAR(250) NOT NULL, secret VARCHAR(250) NOT NULL, redirect_url TEXT, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_clients', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #9 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_refresh_tokens' already exists. Failing Query: "CREATE TABLE oauth_refresh_tokens (id INT UNSIGNED AUTO_INCREMENT, refresh_token VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_refresh_t...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #10 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'uuid'. Failing Query: "ALTER TABLE orders ADD uuid VARCHAR(50)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #11 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'uuid_idx'. Failing Query: "CREATE UNIQUE INDEX uuid_idx ON orders (uuid)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE UNIQUE I...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE UNIQUE I...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('orders', 'uuid', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 88)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
Error #12 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'uuid_idx'. Failing Query: "CREATE UNIQUE INDEX uuid_idx ON orders_items (uuid)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE UNIQUE I...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE UNIQUE I...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('orders_items', 'uuid', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 88)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
"
Please advise... Thank you...