[Tickets #10902] MySQL syntax wrong in initial install

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10902
------------------------------------------------------------------------------
  Ticket             | 10902
  Created By         | chandleg at wizardsworks.org
  Summary            | MySQL syntax wrong in initial install
  Queue              | Horde Base
  Version            | 4.0.13
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


chandleg at wizardsworks.org (2012-01-05 02:58) wrote:

root at binary:/usr/local/apache2/htdocs/horde# webmail-install

Installing Horde Groupware Webmail Edition

Configuring database settings

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

Type your choice []: mysql
Request persistent connections?
     (1) Yes
     (0) No

Type your choice [0]:

Username to connect to the database as* [] {removed}
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* [] localhost

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

Database name to use* [] Horde-Mail

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:
SQLSTATE[42000]: Syntax error or access violation: 1064 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

1. Horde_Core_Bundle->migrateDb() /usr/local/bin/webmail-install:32
2. Horde_Db_Migration_Migrator->up()  
/usr/local/lib/php/Horde/Core/Bundle.php:107
3. Horde_Db_Migration_Migrator->_doMigrate()  
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:102
4. Horde_Db_Migration_Base->migrate()  
/usr/local/lib/php/Horde/Db/Migration/Migrator.php:182
5. KronolithUpgradeAddAllDay->up()  
/usr/local/lib/php/Horde/Db/Migration/Base.php:121
6. KronolithUpgradeAddAllDay->execute()  
/usr/local/apache2/htdocs/wizardsworks.org/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
7. Horde_Db_Migration_Base->__call()  
/usr/local/apache2/htdocs/wizardsworks.org/horde/kronolith/migration/3_kronolith_upgrade_addallday.php:24
8. call_user_func_array() /usr/local/lib/php/Horde/Db/Migration/Base.php:86
9. Horde_Db_Adapter_Base->execute()

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