[prev in list] [next in list] [prev in thread] [next in thread] 

List:       horde-dev
Subject:    [dev] mariadb migrations issues on master
From:       Ralf Lang <lang () b1-systems ! de>
Date:       2014-02-05 13:46:19
Message-ID: 52F240AB.80502 () b1-systems ! de
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


Hi,

I'm currently having issues running the migrations for Horde_Alarm under
mariadb in current master. When spooling back to tag:horde-5.1.5 I don't
have them. It affects both web and console usage.
Not all migrations break, but for example horde_alarm from clean up:


Debug output:

srv1-14437:~ # phphorde /srv/git/horde/horde/bin/horde-db-migrate
Horde_Alarm --debug
[  INFO  ] Migrating DB up.
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0011s)
        SHOW TABLES
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0008s)
        SHOW TABLES
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0004s)
        SELECT version FROM horde_alarm_schema_info
[  INFO  ] Current Horde_Alarm schema version: 0
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0009s)
        SHOW TABLES
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0002s)
        SELECT version FROM horde_alarm_schema_info
Migrating to HordeAlarmsTable (1)
== 1 HordeAlarmsTable: migrating
==============================================
-- tables()
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0012s)
        SHOW TABLES
   -> 0.0015s
-- createTable('horde_alarms')
   -> 0.0009s
2014-02-05T13:14:15+00:00 DEBUG: SQL  (0.0005s)
        SHOW VARIABLES LIKE 'character_set_results'
2014-02-05T13:14:15+00:00 DEBUG: SQL
        CREATE TABLE `horde_alarms` ( `id` int(10) UNSIGNED NOT NULL
          AUTO_INCREMENT PRIMARY KEY(i, i), `alarm_id` varchar(255) NOT
NULL,
          `alarm_uid` varchar(255), `alarm_start` datetime NOT NULL,
`alarm_end`
          datetime, `alarm_methods` varchar(255), `alarm_params` text,
          `alarm_title` varchar(255) NOT NULL, `alarm_text` text,
`alarm_snooze`
          datetime, `alarm_dismissed` int(1) NOT NULL DEFAULT 0,
          `alarm_internal` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2014-02-05T13:14:15+00:00 ERR: SQL QUERY FAILED: SQLSTATE[42000]: Syntax
error or access violation: 1064 You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the
right syntax to use near '(i, i),
  `alarm_id` varchar(255) NOT NULL,
  `alarm_uid` varchar(255),
  `al' at line 2
        CREATE TABLE `horde_alarms` ( `id` int(10) UNSIGNED NOT NULL
          AUTO_INCREMENT PRIMARY KEY(i, i), `alarm_id` varchar(255) NOT
NULL,
          `alarm_uid` varchar(255), `alarm_start` datetime NOT NULL,
`alarm_end`
          datetime, `alarm_methods` varchar(255), `alarm_params` text,
          `alarm_title` varchar(255) NOT NULL, `alarm_text` text,
`alarm_snooze`
          datetime, `alarm_dismissed` int(1) NOT NULL DEFAULT 0,
          `alarm_internal` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '(i, i),
  `alarm_id` varchar(255) NOT NULL,
  `alarm_uid` varchar(255),
  `al' at line 2




-- 
Ralf Lang
Linux Consultant / Developer
Tel.: +49-170-6381563
Mail: lang@b1-systems.de
B1 Systems GmbH
Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de
GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537


["signature.asc" (application/pgp-signature)]

-- 
dev mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: dev-unsubscribe@lists.horde.org

[prev in list] [next in list] [prev in thread] [next in thread]