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

* Your Email Address
* Spam protection	Enter the letters below: .__ . .__..__.. . [__)\| \| \|\| \|\ / \| \\|___\|__\|\|__\ \/
Comment	> 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". > >
Attachment
Watch this ticket

Saved Queries