[Tickets #12998] git HEAD: DB migration fails

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12998
------------------------------------------------------------------------------
  Ticket             | 12998
  Created By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | git HEAD: DB migration fails
  Queue              | Horde Base
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2014-02-27 10:11) wrote:

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