[ansel] Ansel "MDB2 Error: unknown error" problem
Jan Schneider
jan at horde.org
Thu Nov 11 22:21:15 UTC 2010
Zitat von maed at ukr.net:
> 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: ansel-unsubscribe at lists.horde.org
>
Please create a ticket on http://bugs.horde.org/.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
More information about the ansel
mailing list