[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