[horde] Error during upgrade

[Jan Schneider]

Zitat von Gastón Sansó <gaston.sanso at gmail.com>:

> On Fri, Nov 13, 2009 at 7:54 AM, Jan Schneider <jan at horde.org> wrote:
>> 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/
>>
>> --
>> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
> Hi Jan, thanks for the reply. I did what you said , first I  updated
> PEAR by selecting option 4 in setup.php. then
>
> ./pear/pear -c pear/horde.ini -d preferred_state=beta upgrade mdb2
> mdb2_driver_pgsql mdb2_schema
>
>
> but when I run option 5 to do the upgrade I'm still getting the same error:
>
> [ 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"
>

So, the bug still exists in the latest version of MDB2_Schema and  
should be reported there.

Jan.

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