[Tickets #7914] Re: MDB2_Schema Error: schema validation error

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7914
------------------------------------------------------------------------------
  Ticket             | 7914
  Updated By         | el.baby at gmail.com
  Summary            | MDB2_Schema Error: schema validation error
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2.2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          | 1.2.4
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


el.baby at gmail.com (2009-09-21 13:30) wrote:

Well, that is, unless your users had actually set alarms for a future  
date and they intend for them to work... if you delete the  
horde_alarms table, you automatically deleted all your users alarms.

You can, however, modify the structure of the table before the upgrade  
in order that it completes sucessfully:

ALTER TABLE `horde_alarms` CHANGE `alarm_start` `alarm_start` DATETIME
NOT NULL DEFAULT '0000-00-00 00:00:00'

This will NOT erase the alarms since it only changes the structure of  
the table and, actually, it only changes the DEFAULT value (which is  
used for newly inserted records and doesn't affect existing records).