[Tickets #4370] enable / disable, moving of rules, not being saved the first time

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4370
-----------------------------------------------------------------------
 Ticket             | 4370
 Updated By         | bruno at konjz.org
 Summary            | enable / disable, moving of rules, not being saved the first time
 Queue              | Ingo
 Version            | HEAD
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


bruno at konjz.org (2006-09-18 17:41) wrote:

Some debug info. I log in, select Mail, then Filters. I want to turn on
default Spam Filter. It has a red cross under disabled column. I click on
it, and from horde.log:
-----
Sep 18 20:32:10 HORDE [debug] [] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_p
arents FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER
BY datatree_id [on line 275 of "/v
ar/www/pear/lib/Horde/DataTree/sql.php"]
Sep 18 20:32:10 HORDE [debug] [] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_name, c
.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'horde.perms'  [on line 144 of
"/var/www/pear/lib/Horde/DataTree/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_v
alue FROM horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope
= 'horde') ORDER BY pref_scope [on
 line 159 of "/var/www/pear/lib/Horde/Prefs/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_v
alue FROM horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope
= 'horde') ORDER BY pref_scope [on
 line 159 of "/var/www/pear/lib/Horde/Prefs/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_v
alue FROM horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope
= 'horde') ORDER BY pref_scope [on
 line 159 of "/var/www/pear/lib/Horde/Prefs/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_v
alue FROM horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope
= 'horde') ORDER BY pref_scope [on
 line 159 of "/var/www/pear/lib/Horde/Prefs/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_v
alue FROM horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope
= 'horde') ORDER BY pref_scope [on
 line 159 of "/var/www/pear/lib/Horde/Prefs/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatr
ee_parents FROM horde_datatree WHERE datatree_name = ? AND group_uid = ?
ORDER BY datatree_id [on line 275 of
 "/var/www/pear/lib/Horde/DataTree/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_nam
e, c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'horde.perms'  [on line 144
 of "/var/www/pear/lib/Horde/DataTree/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatr
ee_parents FROM horde_datatree WHERE datatree_name = ? AND group_uid = ?
ORDER BY datatree_id [on line 275 of
 "/var/www/pear/lib/Horde/DataTree/sql.php"]
Sep 18 20:32:11 HORDE [debug] [ingo] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_nam
e, c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'horde.perms'  [on line 144
 of "/var/www/pear/lib/Horde/DataTree/sql.php"]
-----

The red cross turns into green checkmark. On top it says:
"Rule Enabled"
"Script successfully activated"

On backend, indeed there is an entry in ingo.script.
I log out, log back in, go to Mail -> Filters, and instead of seeing a
green checkmark for Spam Filter, there is a red cross. Still, it is
enabled on backend imap server.

CVS HEAD, SQL DB for preferances, Horde defaults.
In Ingo, for storage driver selected is "preferences system".