[dev] postgress errors

[Jos W. van der Woude]

Hi all,

For a while now I am experiencing the following errors in imp:

1. messages will *sometimes* refuse to be deleted

2. the unread property does *sometimes* not disappear after reading the 
message.


I have yet to discover what triggers the *sometimes*, seems random.

I am using the lastest code from cvs, a postgress database, pear 
modules are up to date and the latest framework is installed.

The - hopefully relevant - horde.log entries are as follows:

Jun 15 19:29:30 HORDE [debug] [imp] SQL Query by 
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parent
s FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER 
BY datatree_id [on line 261 of "/usr/local/lib/
php/Horde/DataTree/sql.php"]
Jun 15 19:29:30 HORDE [debug] [imp] SQL Query by DataTree_sql::_load(): 
SELECT c.datatree_id, c.datatree_name, c.data
tree_parents, c.datatree_order FROM horde_datatree c WHERE c.group_uid 
= 'horde.perms'  [on line 130 of "/usr/local/l
ib/php/Horde/DataTree/sql.php"]
Jun 15 19:29:30 HORDE [debug] [imp] SQL Query by 
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parent
s FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER 
BY datatree_id [on line 261 of "/usr/local/lib/
php/Horde/DataTree/sql.php"]
Jun 15 19:29:30 HORDE [debug] [imp] SQL Query by DataTree_sql::_load(): 
SELECT c.datatree_id, c.datatree_name, c.data
tree_parents, c.datatree_order FROM horde_datatree c WHERE c.group_uid 
= 'horde.perms'  [on line 130 of "/usr/local/l
ib/php/Horde/DataTree/sql.php"]


And the postgress log is:

Jun 15 19:29:30 toshibax postgres[19193]: [1-1] ERROR:  syntax error at 
or near "AND" at character 82
Jun 15 19:29:30 toshibax postgres[19193]: [1-2] STATEMENT:  SELECT 
datatree_id, datatree_parents FROM horde_datatree
WHERE datatree_name = ? AND group_uid = ? ORDER BY
Jun 15 19:29:30 toshibax postgres[19193]: [1-3]  datatree_id
Jun 15 19:29:30 toshibax postgres[19193]: [2-1] ERROR:  syntax error at 
or near "AND" at character 82
Jun 15 19:29:30 toshibax postgres[19193]: [2-2] STATEMENT:  SELECT 
datatree_id, datatree_parents FROM horde_datatree
WHERE datatree_name = ? AND group_uid = ? ORDER BY
Jun 15 19:29:30 toshibax postgres[19193]: [2-3]  datatree_id
Jun 15 19:29:35 toshibax postgres[19198]: [1-1] ERROR:  syntax error at 
or near "AND" at character 82
Jun 15 19:29:35 toshibax postgres[19198]: [1-2] STATEMENT:  SELECT 
datatree_id, datatree_parents FROM horde_datatree
WHERE datatree_name = ? AND group_uid = ? ORDER BY
Jun 15 19:29:35 toshibax postgres[19198]: [1-3]  datatree_id


Any ideas?

Regards
Jos

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3013 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.horde.org/archives/dev/attachments/20050615/44da5b57/smime.bin