[horde] Error during upgrade

[Jan Schneider]

Zitat von Jan Schneider <jan at horde.org>:

> Zitat von Gastón Sansó <gaston.sanso at gmail.com>:
>
>> Hi, I'm getting the following error while trying to upgrade  Horde
>> Groupware Webmail Edition from version 1.2 to 1.2.4:
>>
>> [ ERROR! ] Reading the existing table structure failed. Error messages:
>> MDB2_Schema Error: schema validation error
>> default value of "pref_scope" is incorrect: "''::character varying" is
>> larger than "16"
>
> This sounds like a bug in MDB2_Schema. I think this is what happens:  
> to update the database mdb2 first reads the existing database  
> schema. As if it doesn't trust its own generated data, it tries to  
> validates the parsed schema. This is the point where it fails,  
> because PostgreSQL returns the default value of the pref_scope  
> tables as "''::character varying". This of course only means '', the  
> last part is just a casting instruction. But the validator doesn't  
> know this, and counts the complete string as the default value,  
> which exceeds the maximum size of 16 characters for that column. Boof.

Try if upgrading MDB2 and MDB2_Schema fixes this. Should work with the  
following from the horde directory:

./pear/pear -c pear/horde.ini -d preferred_state=beta upgrade mdb2  
mdb2_driver_pgsql mdb2_schema

The run the upgrade script again. But first please make sure to have backups.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/