Ansel "MDB2 Error: unknown error" problem

[email protected] Thu, 11 Nov 2010 22:56:57 +0200
Newsgroups gmane.comp.horde.ansel
Message-ID <[email protected]>
   Good day!

   >


   I installed horde (and PostgreSQL as SQL server) oh FreeBSD 8.1 and
   most of the "production" applications (not from ports; clean install
   according to docs/INSTALL) and everything seem to work fine. But I
   can’t use photos (The "Ansel" v1.1.2) - I can’t create new gallery!
   Then I try to create it I have a "The gallery "Test galery" could not
   be created: MDB2 Error: unknown error". Also I have following in
   /var/log/messages from "horde postgres":

   [3-1] ERROR:  column "attribute_age" is of type integer but expression
   is of type text at character 339
   [3-2] HINT:  You will need to rewrite or cast the expression.
   [3-3] STATEMENT:  PREPARE
   mdb2_statement_pgsql_a4dbb2ffc768658549837aa57bc977af (text, text,
   text, text, text, text, text, text, text,
   [3-4]  text, text, text, text, text, text, text, text, text, text,
   text, text, text)  AS INSERT INTO ansel_shares (share_parents,
   [3-5]  share_owner, attribute_name, attribute_desc,
   attribute_category, attribute_style, attribute_slug, attribute_age,
   [3-6]  attribute_download, attribute_view_mode, attribute_passwd,
   attribute_default_type, attribute_default,
   [3-7]  attribute_default_prettythumb, attribute_date_created,
   attribute_last_modified, attribute_images, perm_creator, perm_default,
   [3-8]  perm_guest, share_flags, share_id) VALUES ($1, $2, $3, $4, $5,
   $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18,[3-9] 
   $19, $20, $21, $22)

   >


   Seems like some kind of data types problem... I tried to find solution
   but I’m not a PHP programmer and can’t fix it by myself... Try to
   Google it, but no luck.

   >

   Is there any solution or workaround?

   >
-- 
ansel mailing list - Join the hunt: http://horde.org/bounties/#ansel
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]