Re: Ansel "MDB2 Error: unknown error" problem
Jan Schneider <[email protected]> Thu, 11 Nov 2010 23:21:15 +0100
| Newsgroups | gmane.comp.horde.ansel |
|---|---|
| Message-ID | <[email protected]> |
Zitat von [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] > Please create a ticket on http://bugs.horde.org/. Jan. -- Do you need professional PHP or Horde consulting? http://horde.org/consulting/ -- ansel mailing list - Join the hunt: http://horde.org/bounties/#ansel Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]