[horde] horde webmail upgrade issue

[tom burkart]

Quoting tom burkart <horde at aussec.com>:

> Hi,
> I have two issues with setup.php when upgrading from horde webmail
> 1.0.6 to 1.2.2 (Apache 2.2.10, PHP 5.2.6, SUSE 11.1):

Further to my previous observations, I have noted the following:
horde webmail 1.2.2 with a clean (empty) database seems to work ok.
Hence the problem lies with either the "historical garbage" left by  
previous versions of horde in the database or the setup.php upgrade  
script.  I am inclined to think it is a mixture of both:

When examining the databse schema between the "clean" install and the  
"upgraded" database there are quite a few significant (in my opinion)  
differences.

quite a few tables have:
clean:
perm_name character varying(255) NOT NULL,
upgraded:
perm_name character varying(255) DEFAULT NULL::character varying NOT NULL,

horde_locks has an extra field lock_scope in the upgraded version

SET default_with_oids = ...; changes regularly in the upgraded version

There are several differences for timestamps where bigint is used in  
the clean version and int is used in the upgraded version.
Similarly with text and bytea respectively.


tom