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

[Bill Day]

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?

Thanks,

Bill


[Last executed query: EXECUTE
mdb2_statement_pgsql_9f27555944e87e42502970a4ff2556d2 (NULL, 'billday', 'Da
Girls!', 'The Wonderful Adventures of Rachel and Talia', 'Family',
'ansel_lightbox', 'rachelandtalia', 0, 'edit', 'Normal', '', 'auto', 0, '',
1240867637, 1240867637, 0, 0, 0, 0, 0, 6)]
[Native message: ERROR:  invalid input syntax for integer: "Normal"]
 [pid 22598 on line 1025 of
"/usr/local/share/horde/lib/Horde/Share/sql.php"]
Apr 27 17:27:17 HORDE [error] [ansel] The gallery "Da Girls!" could not be
created: MDB2 Error: invalid number [pid 22598 on line 3062 of
"/usr/local/share/horde/ansel/lib/Ansel.php"]
Apr 27 17:27:17 HORDE [error] [ansel] The gallery "Da Girls!" couldn't be
created: The gallery "Da Girls!" could not be created: MDB2 Error: invalid
number [pid 22598 on line 274 of "/usr/local/share/horde/ansel/gallery.php"]
Apr 27 18:45:27 HORDE [error] [ansel] MDB2 Error: invalid number: _doQuery:
[Error message: Could not execute statement]
[Last executed query: EXECUTE
mdb2_statement_pgsql_5e06a5e921e00dfb5ba29d8226b90adb (NULL, 'billday', 'Da
Girls!', '', '', 'ansel_lightbox', 'girls', 0, 'edit', 'Normal', '', 'auto',
0, '', 1240872327, 1240872327, 0, 0, 0, 0, 0, 7)]
[Native message: ERROR:  invalid input syntax for integer: "Normal"]
 [pid 23777 on line 1025 of
"/usr/local/share/horde/lib/Horde/Share/sql.php"]
Apr 27 18:45:27 HORDE [error] [ansel] The gallery "Da Girls!" could not be
created: MDB2 Error: invalid number [pid 23777 on line 3062 of
"/usr/local/share/horde/ansel/lib/Ansel.php"]
Apr 27 18:45:27 HORDE [error] [ansel] The gallery "Da Girls!" couldn't be
created: The gallery "Da Girls!" could not be created: MDB2 Error: invalid
number [pid 23777 on line 274 of "/usr/local/share/horde/ansel/gallery.php"]
Apr 28 02:14:48 HORDE [error] [ansel] MDB2 Error: invalid number: _doQuery:
[Error message: Could not execute statement]
[Last executed query: EXECUTE
mdb2_statement_pgsql_4efda170fa641c97892acdf6fbefbad9 (NULL, 'billday', 'Da
Girls!', '', '', 'ansel_lightbox', 'dagirls', 0, 'edit', 'Normal', '',
'auto', 0, '', 1240899288, 1240899288, 0, 0, 0, 0, 0, 8)]
[Native message: ERROR:  invalid input syntax for integer: "Normal"]
 [pid 27625 on line 1025 of
"/usr/local/share/horde/lib/Horde/Share/sql.php"]
Apr 28 02:14:48 HORDE [error] [ansel] The gallery "Da Girls!" could not be
created: MDB2 Error: invalid number [pid 27625 on line 3062 of
"/usr/local/share/horde/ansel/lib/Ansel.php"]
Apr 28 02:14:48 HORDE [error] [ansel] The gallery "Da Girls!" couldn't be
created: The gallery "Da Girls!" could not be created: MDB2 Error: invalid
number [pid 27625 on line 274 of "/usr/local/share/horde/ansel/gallery.php"]


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