Error during upgrade

[Gastón Sansó]

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"


Any ideas? Thanks.

Gastón
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Jan Schneider]

Zitat von Gastón Sansó <gaston.sanso@...>:

> 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.

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@...

[Jan Schneider]

Zitat von Jan Schneider <jan@...>:

> Zitat von Gastón Sansó <gaston.sanso@...>:
>
>> 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@...

[Gastón Sansó]

On Fri, Nov 13, 2009 at 7:54 AM, Jan Schneider <jan@...> wrote:

> Zitat von Jan Schneider <jan@...>:
>
>> Zitat von Gastón Sansó <gaston.sanso@...>:
>>
>>> 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@...
>

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"
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Jan Schneider]

Zitat von Gastón Sansó <gaston.sanso@...>:

> On Fri, Nov 13, 2009 at 7:54 AM, Jan Schneider <jan@...> wrote:
>> Zitat von Jan Schneider <jan@...>:
>>
>>> Zitat von Gastón Sansó <gaston.sanso@...>:
>>>
>>>> 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@...
>>
>
> 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/

--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe@...

[Jan Schneider]

Zitat von Jan Schneider <jan@...>:

> Zitat von Gastón Sansó <gaston.sanso@...>:
>
>> On Fri, Nov 13, 2009 at 7:54 AM, Jan Schneider <jan@...> wrote:
>>> Zitat von Jan Schneider <jan@...>:
>>>
>>>> Zitat von Gastón Sansó <gaston.sanso@...>:
>>>>
>>>>> 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@...
>>>
>>
>> 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.

http://pear.php.net/bugs/16798

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@...