[ansel] Ansel "MDB2 Error: unknown error" problem

maed at ukr.net maed at ukr.net
Thu Nov 11 20:56:57 UTC 2010


   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?

   >


More information about the ansel mailing list