Tickets :: Comment on [#12998] git HEAD: DB migration fails

* Your Email Address
* Spam protection	Enter the letters below: . . ..__ .__..__ \| \ /[__)\| \|[__) \|___ \/ \| \|__\|[__)
Comment	> I've modified the code that outputs the SQL query error to show a > stack trace: > > 2014-02-27T11:22:20+01:00 ERR: HORDE [horde] SQL STACK TRACE: #0 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php(197): > PDO->query('CREATE TEMPORAR...') > #1 [internal function]: Horde_Db_Adapter_Pdo_Base->execute('CREATE > TEMPORAR...', NULL, NULL) > #2 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Sqlite.php(182): call_user_func_array(Array, > Array) > #3 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Sqlite.php(134): Horde_Db_Adapter_Pdo_Sqlite->_catchSchemaChanges('execute', > Array) > #4 [internal function]: Horde_Db_Adapter_Pdo_Sqlite->execute('CREATE > TEMPORAR...') > #5 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(166): call_user_func_array(Array, > Array) > #6 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(569): Horde_Db_Adapter_Base_Schema->__call('execute', > Array) > #7 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/Schema.php(569): Horde_Db_Adapter_Sqlite_Schema->execute('CREATE > TEMPORAR...') > #8 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base/TableDefinition.php(203): > Horde_Db_Adapter_Base_Schema->endTable(Object(Horde_Db_Adapter_Base_TableDefinition)) > #9 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(624): > Horde_Db_Adapter_Base_TableDefinition->end() > #10 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(557): Horde_Db_Adapter_Sqlite_Schema->_copyTable('turba_shares', 'altered_turba_s...', Array, > NULL) > #11 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(529): Horde_Db_Adapter_Sqlite_Schema->_moveTable('turba_shares', 'altered_turba_s...', > Array) > #12 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Sqlite/Schema.php(308): Horde_Db_Adapter_Sqlite_Schema->_alterTable('turba_shares', Array, > '?lambda_1') > #13 [internal function]: > Horde_Db_Adapter_Sqlite_Schema->changeColumn('turba_shares', > 'share_parents', 'string', Array) > #14 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php(255): > call_user_func_array(Array, Array) > #15 [internal function]: Horde_Db_Adapter_Base->__call('changeColumn', Array) > #16 [internal function]: > Horde_Db_Adapter_Pdo_Sqlite->changeColumn('turba_shares', > 'share_parents', 'string', Array) > #17 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Base.php(86): > call_user_func_array(Array, Array) > #18 > /datastore/DEVEL/horde/turba/migration/11_turba_upgrade_parents.php(31): > Horde_Db_Migration_Base->__call('changeColumn', Array) > #19 > /datastore/DEVEL/horde/turba/migration/11_turba_upgrade_parents.php(31): > TurbaUpgradeParents->changeColumn('turba_shares', 'share_parents', > 'string', Array) > #20 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Base.php(121): > TurbaUpgradeParents->up() > #21 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Migrator.php(182): > Horde_Db_Migration_Base->migrate('up') > #22 > /datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Migration/Migrator.php(102): > Horde_Db_Migration_Migrator->_doMigrate() > #23 /datastore/DEVEL/horde/horde/admin/config/index.php(126): > Horde_Db_Migration_Migrator->up() > #24 {main} > CREATE TEMPORARY TABLE "altered_turba_shares" ( "share_id" INTEGER > PRIMARY KEY AUTOINCREMENT NOT NULL(I, I) NOT NULL, "share_name" > varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL, > "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL > DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0, > "perm_guest" int NOT > NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, > "attribute_desc" varchar(255), "attribute_params" text, > "share_parents" text ) [pid 5590 on line 201 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] >
Attachment
Watch this ticket

Saved Queries