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

Bill Day williamson.day at gmail.com
Wed Apr 29 05:22:24 UTC 2009


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



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

More information about the horde mailing list