[horde] Ansel fails to create gallery issues MDB2 Error: Invalid Number on Postgresql 8.4 backend

[Bill Day]

Mike,

Thanks very much.  One of the things that makes Horde great is the
responsiveness of the developers in addition to the quality of the software.

I did run into a couple of syntax errors in the first line of the script
when I tried to run it.

I changed the first line to read as follows:

ALTER TABLE ansel_shares ALTER attribute_view_mode TYPE VARCHAR(255);

That seemed to work better for me, and I was able to create a new gallery.
I am not an SQL guru by any stretch of the imagination, however, so caveat
lector!

Sincerely,

Bill

On Tue, Apr 28, 2009 at 9:42 AM, Michael Rubinsky <mrubinsk at horde.org>wrote:

>
> Quoting Bill Day <williamson.day at gmail.com>:
>
>  I am trying to set up a gallery for my young daughters in the stable
>> release
>> of Ansel with Postgresql 8.4 as a backend, and I keep getting the
>> following
>> errors when I try to create a gallery.  I have made sure that the pear
>> modules included with horde are in my path.  Any suggestions?
>>
>
> Yup. The postgres database creation script contained an incorrect field
> definition for one of the fields. There is a (just added) upgrade script to
> run located in CVS.
>
>
> http://cvs.horde.org/co.php/ansel/scripts/upgrades/2009-04-14_fix_view_mode.pgsql.sql?r=1.1.2.1
>
>
>
> Thanks,
> mike
>
> --
> The Horde Project (www.horde.org)
> mrubinsk at horde.org
>
> "Time just hates me. That's why it made me an adult." - Josh Joplin
> --
> 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
>



-- 
Bill Day
williamson.day at gmail.com
PGP Fingerprint: EE5D DE55 9EF1 E012 7417
A5F1 1D7D 0847 7785 1146