Tickets :: Comment on [#9838] Groups will not update

* Your Email Address
* Spam protection	Enter the letters below: __ __ . ,. ..__ / `/ ` \./ \| \|[__) \__.\__. \| \|/\\|[__)
Comment	>> Are there any errors in the (PHP and Horde) logs? > > I turned on DEBUG logged and went to perform the function to add a > group. This is what I found in the log > > I went to Groups, selected the top level and added a group called > test. UI said test added successfully and it showed as new group. > Clicked on the group and it went back to the main group listing with > the new group not showing. > > (paths were changed for security reasons) > > Apr 08 12:43:13 HORDE [debug] [horde] SQL Query by > SessionHandler_mysql::_read(): query = "SELECT session_data FROM > horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' > FOR UPDATE" [pid 12320 on line 139 of > "M:\x\lib\Horde\SessionHandler\mysql.php"] > Apr 08 12:43:13 HORDE [debug] [horde] SQL query by > Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start, > alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text, > alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed > = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze > <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS > NULL OR alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, > alarm_end [pid 12320 on line 151 of "M:\x\lib\Horde\Alarm\sql.php"] > > Apr 08 12:43:14 HORDE [debug] [horde] SQL Query by > SessionHandler_mysql::_read(): query = "SELECT session_data FROM > horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' > FOR UPDATE" [pid 12320 on line 139 of > "M:\x\lib\Horde\SessionHandler\mysql.php"] > Apr 08 12:43:14 HORDE [debug] [horde] Session data unchanged (id = > aq2le5e5eop23p6194cqhbv9v1) [pid 12320 on line 264 of > "M:\x\lib\Horde\SessionHandler.php"] > > Apr 08 12:43:17 HORDE [debug] [horde] SQL Query by > SessionHandler_mysql::_read(): query = "SELECT session_data FROM > horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' > FOR UPDATE" [pid 12320 on line 139 of > "M:\x\lib\Horde\SessionHandler\mysql.php"] > Apr 08 12:43:17 HORDE [debug] [horde] Session data unchanged (id = > aq2le5e5eop23p6194cqhbv9v1) [pid 12320 on line 264 of > "M:\x\lib\Horde\SessionHandler.php"] > > Apr 08 12:43:17 HORDE [debug] [horde] SQL Query by > SessionHandler_mysql::_read(): query = "SELECT session_data FROM > horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' > FOR UPDATE" [pid 12320 on line 139 of > "M:\x\lib\Horde\SessionHandler\mysql.php"] > Apr 08 12:43:17 HORDE [debug] [horde] SQL query by > Horde_History::getHistory(): SELECT * FROM horde_histories WHERE > object_uid = ?, values: horde:group:3 [pid 12320 on line 244 of > "M:\x\lib\Horde\History.php"] > Apr 08 12:43:17 HORDE [debug] [horde] SQL query by > Horde_History::log(): INSERT INTO horde_histories (history_id, > object_uid, history_ts, history_who, history_desc, history_action, > history_extra) VALUES (?, ?, ?, ?, ?, ?, ?), values: > 2189,horde:group:3,1302280997,user@user.com,,add, [pid 12320 on line > 217 of "M:\x\lib\Horde\History.php"] > Apr 08 12:43:17 HORDE [debug] [horde] SQL query by > Horde_Alarm_sql::_list(): SELECT alarm_id, alarm_uid, alarm_start, > alarm_end, alarm_methods, alarm_params, alarm_title, alarm_text, > alarm_snooze, alarm_internal FROM horde_alarms WHERE alarm_dismissed > = 0 AND ((alarm_snooze IS NULL AND alarm_start <= ?) OR alarm_snooze > <= ?) AND (alarm_end IS NULL OR alarm_end >= ?) AND (alarm_uid IS > NULL OR alarm_uid = ? OR alarm_uid = ?) ORDER BY alarm_start, > alarm_end [pid 12320 on line 151 of "M:\x\lib\Horde\Alarm\sql.php"] > > Apr 08 12:43:18 HORDE [debug] [horde] SQL Query by > SessionHandler_mysql::_read(): query = "SELECT session_data FROM > horde_sessionhandler WHERE session_id = 'aq2le5e5eop23p6194cqhbv9v1' > FOR UPDATE" [pid 15516 on line 139 of > "M:\x\lib\Horde\SessionHandler\mysql.php"] > Apr 08 12:43:18 HORDE [debug] [turba] Hook _horde_hook_share_init in > application horde not called. [pid 15516 on line 1736 of > "M:\x\lib\Horde.php"] > Apr 08 12:43:18 HORDE [debug] [turba] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM turba_shares s > LEFT JOIN turba_shares_users u ON u.share_id = s.share_id LEFT JOIN > turba_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner > = 'user@user.com' OR (s.perm_creator & 4) OR (s.perm_default & 4) OR > ( u.user_uid = 'user@user.com' AND (u.perm & 4)) OR (g.group_uid IN > ('1') AND (g.perm & 4)) ORDER BY s.share_name ASC [pid 15516 on line > 469 of "M:\x\lib\Horde\Share\sql.php"] > Apr 08 12:43:18 HORDE [debug] [turba] Cache hit: > perm_sql_exists_turba:sources:localsql (Id > 9bc50e66eeb54ada9a0cc36981d3424a newer than 1302194598) [pid 15516 on > line 175 of "M:\x\lib\Horde\Cache\sql.php"] > Apr 08 12:43:19 HORDE [debug] [kronolith] Hook _horde_hook_share_init > in application horde not called. [pid 15516 on line 1736 of > "M:\x\lib\Horde.php"] > Apr 08 12:43:19 HORDE [debug] [kronolith] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM > kronolith_shares s LEFT JOIN kronolith_shares_users u ON u.share_id > = s.share_id LEFT JOIN kronolith_shares_groups g ON g.share_id = > s.share_id WHERE s.share_owner = 'user@user.com' OR (s.perm_creator & > 2) OR (s.perm_default & 2) OR ( u.user_uid = 'user@user.com' AND > (u.perm & 2)) OR (g.group_uid IN ('1') AND (g.perm & 2)) ORDER BY > s.attribute_name ASC [pid 15516 on line 469 of > "M:\x\lib\Horde\Share\sql.php"] > Apr 08 12:43:19 HORDE [debug] [kronolith] > Kronolith_Driver_sql::listEventsConditional(): user = > "user@user.com"; query = "SELECT event_id, event_uid, > event_description, event_location, event_private, event_status, > event_attendees, event_keywords, event_title, event_category, > event_recurcount, event_recurtype, event_recurenddate, > event_recurinterval, event_recurdays, event_start, event_end, > event_alarm, event_modified, event_exceptions, event_creator_id FROM > kronolith_events WHERE calendar_id = ? AND event_alarm > ? AND > ((event_end >= ?) OR (event_recurenddate >= ? AND event_recurtype <> > ?))"; values = "user@user.com,0,2011-04-08 00:00:00,2011-04-08 > 00:00:00,0" [pid 15516 on line 318 of > "M:\x\kronolith\lib\Driver\sql.php"] > Apr 08 12:43:19 HORDE [debug] [nag] Hook _horde_hook_share_init in > application horde not called. [pid 15516 on line 1736 of > "M:\x\lib\Horde.php"] > Apr 08 12:43:19 HORDE [debug] [nag] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM nag_shares s > LEFT JOIN nag_shares_users u ON u.share_id = s.share_id LEFT JOIN > nag_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = > 'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( > u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN > ('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on > line 469 of "M:\x\lib\Horde\Share\sql.php"] > Apr 08 12:43:19 HORDE [debug] [nag] SQL alarms list by user@user.com: > table = nag_tasks; query = "SELECT * FROM nag_tasks WHERE task_owner > = ? AND task_alarm > 0 AND (task_due - (task_alarm * 60) <= ?) AND > task_completed = 0" [pid 15516 on line 514 of > "M:\x\nag\lib\Driver\sql.php"] > Apr 08 12:43:19 HORDE [debug] [nag] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM nag_shares s > LEFT JOIN nag_shares_users u ON u.share_id = s.share_id LEFT JOIN > nag_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner = > 'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR ( > u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN > ('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on > line 469 of "M:\x\lib\Horde\Share\sql.php"] > Apr 08 12:43:19 HORDE [debug] [mnemo] Hook _horde_hook_share_init in > application horde not called. [pid 15516 on line 1736 of > "M:\x\lib\Horde.php"] > Apr 08 12:43:19 HORDE [debug] [mnemo] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM mnemo_shares s > LEFT JOIN mnemo_shares_users u ON u.share_id = s.share_id LEFT JOIN > mnemo_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner > = 'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR > ( u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN > ('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on > line 469 of "M:\x\lib\Horde\Share\sql.php"] > Apr 08 12:43:19 HORDE [debug] [mnemo] SQL query by > Horde_Share_sql::listShares: SELECT DISTINCT s.* FROM mnemo_shares s > LEFT JOIN mnemo_shares_users u ON u.share_id = s.share_id LEFT JOIN > mnemo_shares_groups g ON g.share_id = s.share_id WHERE s.share_owner > = 'user@user.com' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR > ( u.user_uid = 'user@user.com' AND (u.perm & 2)) OR (g.group_uid IN > ('1') AND (g.perm & 2)) ORDER BY s.attribute_name ASC [pid 15516 on > line 469 of "M:\x\lib\Horde\Share\sql.php"] > > > > > >
Attachment
Watch this ticket

Saved Queries