[dev] mariadb migrations issues on master

[Ralf Lang]

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 at 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 263 bytes
Desc: OpenPGP digital signature
URL: <http://lists.horde.org/archives/dev/attachments/20140205/27317d3f/attachment.bin>