[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-16 12:16) wrote:

Well,

actually, since this was a production setup which I didn't actually  
know in what state ended, I rolled everything back to 1.2.3, restored  
the database, modified the horde_alarms table like this:

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

and then successfully upgraded.

I'll try to simulate the steps you propose in another directory with a  
copy of the database but I don't know when I'll have the time (I  
already took a whole morning with this).

What I don't know is how to run the setup script "step by step" so I  
can relocate pear and then run

./horde/pear/pear -c horde/pear/horde.ini upgrade mdb2_driver_mysql-beta
(it is, actually mysql 5.0).