[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