[kronolith] DB errors on fresh install

[Dmitry E. Mikhailov]

Hi everyone,

While installing kronolith-3.0.13 as a part of groupware-4.0.5, installation 
fails: 

<QUOTE>
Creating and updating database tables...
====================

Fatal Error:
QUERY FAILED: You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near '1 
= event_end' at line 1

UPDATE kronolith_events SET event_allday = 1 WHERE event_start + 
INTERVAL 'DAY' 1 = event_end

1. Horde_Core_Bundle->migrateDb() /usr/bin/groupware-install:32
2. Horde_Db_Migration_Migrator->up() /usr/share/pear/Horde/Core/Bundle.php:107
3. 
Horde_Db_Migration_Migrator->_doMigrate() /usr/share/pear/Horde/Db/Migration/Migrator.php:102
4. 
Horde_Db_Migration_Base->migrate() /usr/share/pear/Horde/Db/Migration/Migrator.php:182
5. 
KronolithUpgradeAddAllDay->up() /usr/share/pear/Horde/Db/Migration/Base.php:121
6. 
KronolithUpgradeAddAllDay->execute() /var/www/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
7. 
Horde_Db_Migration_Base->__call() /var/www/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
8. call_user_func_array() /usr/share/pear/Horde/Db/Migration/Base.php:86
9. Horde_Db_Adapter_Mysqli->execute()

====================
</QUOTE>

If I comment line 24 in the 
offending 'kronolith/migration/3_kronolith_upgrade_addallday.php', 
installation is completed successfully.

Subsequent 'upgrade-install' has no such problem.

Is there an error in the upgrade script?

Best regards,
	Dmitry Mikhailov.


Full install procedure follows. (tried both mysql and mysqli drivers)

# pear install horde/groupware
Did not download optional dependencies: horde/Horde_Test, pear/Date_Holidays, 
use --alldeps to download automatically
Did not download optional dependencies: horde/Horde_Test, use --alldeps to 
download automatically
Did not download optional dependencies: horde/Horde_Test, use --alldeps to 
download automatically
horde/kronolith can optionally use package "horde/Horde_Test" (version >= 
1.3.0, version <= 2.0.0, excluded versions: 2.0.0)
horde/kronolith can optionally use package "pear/Date_Holidays" (version >= 
0.21.0)
horde/mnemo can optionally use package "horde/Horde_Test" (version >= 1.2.0, 
version <= 2.0.0, excluded versions: 2.0.0)
horde/nag can optionally use package "horde/Horde_Test" (version >= 1.2.0, 
version <= 2.0.0, excluded versions: 2.0.0)
downloading groupware-4.0.5.tgz ...
Starting to download groupware-4.0.5.tgz (57,815 bytes)
..............done: 57,815 bytes
downloading kronolith-3.0.13.tgz ...
Starting to download kronolith-3.0.13.tgz (2,594,730 bytes)
...done: 2,594,730 bytes
downloading mnemo-3.0.4.tgz ...
Starting to download mnemo-3.0.4.tgz (1,353,512 bytes)
...done: 1,353,512 bytes
downloading nag-3.0.7.tgz ...
Starting to download nag-3.0.7.tgz (1,757,062 bytes)
....done: 1,757,062 bytes
install ok: channel://pear.horde.org/kronolith-3.0.13
install ok: channel://pear.horde.org/mnemo-3.0.4
install ok: channel://pear.horde.org/nag-3.0.7
install ok: channel://pear.horde.org/groupware-4.0.5
[root at infocoms config]# groupware-install

Installing Horde Groupware

Configuring database settings

What database backend should we use?
    (false) [None]
    (mysql) MySQL / PDO
    (mysqli) MySQL (mysqli)
    (pgsql) PostgreSQL
    (sqlite) SQLite

Type your choice []: mysqli

Username to connect to the database as* [] horde
Password to connect with
How should we connect to the database?
    (unix) UNIX Sockets
    (tcp) TCP/IP

Type your choice [unix]: tcp

Database server/host* [] 10.100.10.3

Port the DB is running on, if non-standard [3306]

Database name to use* []
This field is required.

Database name to use* [] infocs_horde

Internally used charset* [utf-8]
Use SSL to connect to the server?
    (1) Yes
    (0) No

Type your choice [0]:

Certification Authority to use for SSL connections []
Split reads to a different server?
    (false) Disabled
    (true) Enabled

Type your choice [false]:

Writing main configuration file... done.

Creating and updating database tables...
====================

Fatal Error:
QUERY FAILED: You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near '1 
= event_end' at line 1

UPDATE kronolith_events SET event_allday = 1 WHERE event_start + 
INTERVAL 'DAY' 1 = event_end

1. Horde_Core_Bundle->migrateDb() /usr/bin/groupware-install:32
2. Horde_Db_Migration_Migrator->up() /usr/share/pear/Horde/Core/Bundle.php:107
3. 
Horde_Db_Migration_Migrator->_doMigrate() /usr/share/pear/Horde/Db/Migration/Migrator.php:102
4. 
Horde_Db_Migration_Base->migrate() /usr/share/pear/Horde/Db/Migration/Migrator.php:182
5. 
KronolithUpgradeAddAllDay->up() /usr/share/pear/Horde/Db/Migration/Base.php:121
6. 
KronolithUpgradeAddAllDay->execute() /var/www/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
7. 
Horde_Db_Migration_Base->__call() /var/www/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
8. call_user_func_array() /usr/share/pear/Horde/Db/Migration/Base.php:86
9. Horde_Db_Adapter_Mysqli->execute()

====================