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

* Your Email Address
* Spam protection	Enter the letters below: .__.. .. .\ /. . \| \|\| \|\| \| >< \ / \|__\\|/\\|\|/\\|/ \ \/
Comment	> Hi, > > I just tried updating my horde git HEAD installation to the latest commit. > (The system was last updated in November 2013 or so) > > Some DB migration query fails with an sqlite backend: > > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_kronolith_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_color" varchar(7), > "share_parents" text ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_nag_shares" ( "share_id" INTEGER > PRIMARY KEY AUTOINCREMENT NOT NULL(I, I) NOT NULL, "share_name" > varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" > int(2) NOT NULL DEFAULT 0, "perm_creator" int(2) NOT NULL > DEFAULT 0, > "perm_default" int(2) NOT NULL DEFAULT 0, "perm_guest" > int(2) NOT NULL > DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" > varchar(255), "attribute_color" varchar(7), "share_parents" text, > "attribute_issmart" int DEFAULT 0, "attribute_search" text > ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_mnemo_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), "share_parents" text ) [pid > 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_gollem_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, "share_parents" text, > "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 ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_horde_groups" ( "group_uid" INTEGER > PRIMARY KEY AUTOINCREMENT NOT NULL(I, I) NOT NULL, "group_name" > varchar(255) NOT NULL, "group_parents" varchar(255) NOT NULL, > "group_email" varchar(255) ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TABLE "horde_imap_client_data" ( "messageid" INTEGER PRIMARY > KEY AUTOINCREMENT NOT NULL(I, I), "hostspec" varchar(255) NOT NULL, > "mailbox" varchar(255) NOT NULL, "modified" bigint, "port" int NOT > NULL, "username" varchar(255) NOT NULL ) [pid 5436 on line > 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TABLE "horde_queue_tasks" ( "task_id" INTEGER PRIMARY KEY > AUTOINCREMENT NOT NULL(I, I), "task_queue" varchar(255) NOT NULL, > "task_fields" text NOT NULL ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > 2014-02-27T11:06:21+01:00 ERR: HORDE [horde] SQL QUERY FAILED: > SQLSTATE[HY000]: General error: 1 near "(": syntax error > CREATE TEMPORARY TABLE "altered_horde_vfs" ( "vfs_id" INTEGER PRIMARY > KEY AUTOINCREMENT NOT NULL(I, I) NOT NULL, "vfs_type" int NOT NULL, > "vfs_path" varchar(255) NOT NULL, "vfs_name" varchar(255) NOT NULL, > "vfs_modified" int NOT NULL, "vfs_owner" varchar(255) NOT NULL, > "vfs_data" blob ) [pid 5436 on line 200 of > "/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Pdo/Base.php"] > > Cheers, > Thomas >
Attachment
Watch this ticket

Saved Queries