[horde] Database issues (PostgreSQL 8.3.5) webmail 1.2.2
tom burkart
horde at aussec.com
Fri Mar 13 01:47:51 UTC 2009
Hi,
I now get a lot of errors such as the line below (which probably gets
folded to a million lines...):
Mar 13 12:17:21 samsung HORDE[6175]: [turba] MDB2 Error: unknown
error: _doQuery: [Error message: Could not execute statement] [Last
executed query: SELECT DISTINCT s.* FROM turba_shares s LEFT JOIN
turba_shares_users AS u ON u.share_id = s.share_id LEFT JOIN
turba_shares_groups AS g ON g.share_id = s.share_id WHERE
s.share_owner = 'tom' OR (s.perm_creator & 4) != 0 OR (s.perm_default
& 4) != 0 OR ( u.user_uid = 'tom' AND (u.perm & 4) != 0) OR
(g.group_uid IN (635) AND (g.perm & 4)!= 0) ORDER BY s.share_name ASC]
[Native message: ERROR: operator does not exist: character varying =
integer LINE 1: ...id = 'tom' AND (u.perm & 4) != 0) OR (g.group_uid
IN (635) A...
^ HINT: No operator matches the given name and argument type(s).
You might need to add explicit type casts.] [pid 6175 on line 457 of
"/home/httpd/html/horde/lib/Horde/Share/sql.php"]
Basically, it seems that the message is nearly identical but the
sources are as follows:
[pid 6175 on line 457 of "/home/httpd/html/horde/lib/Horde/Share/sql.php"]
[pid 6175 on line 517 of "/home/httpd/html/horde/turba/lib/Turba.php"]
[pid 6175 on line 1330 of
"/home/httpd/html/horde/kronolith/lib/Kronolith.php"]
[pid 6175 on line 281 of "/home/httpd/html/horde/nag/lib/Nag.php"]
The result is that I can see the email summary page, I can look at
emails (I assume I can send emails). I cannot browse the addressbook
(it lists the contacts but clicking on them causes a "no such contact"
error), I can create a new task list (there used to be one there) but
as soon as it is created it disappears.
Any ideas?
tom
More information about the horde
mailing list