[Tickets #12016] Re: kronolith set wrong type_id
noreply at bugs.horde.org
noreply at bugs.horde.org
Tue Feb 5 09:32:59 UTC 2013
DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/12016
------------------------------------------------------------------------------
Ticket | 12016
Updated By | patrick.vangilst at labri.fr
Summary | kronolith set wrong type_id
Queue | Kronolith
Version | 4.0.3
Type | Bug
State | Feedback
Priority | 1. Low
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
patrick.vangilst at labri.fr (2013-02-05 09:32) wrote:
Here is mysqld.log when I create a new event with a tag:
130205 10:23:48 3510 Connect horde at localhost on horde
3510 Query SET NAMES 'utf8'
3510 Query SELECT 1
3510 Query SHOW CHARACTER SET
3510 Query SELECT 1
3510 Query SET NAMES 'utf8'
3511 Connect horde at localhost on horde
3511 Query SET NAMES 'utf8'
3511 Query SELECT 1
3511 Query SHOW CHARACTER SET
3511 Query SELECT 1
3511 Query SET NAMES 'utf8'
3511 Query SELECT 1
3511 Query SELECT g.group_uid AS group_uid, g.group_name AS
group_name FROM horde_groups g, horde_groups_members m WHERE
m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY
g.group_name
3510 Query SELECT 1
3510 Query SELECT DISTINCT s.* FROM kronolith_shares s LEFT JOIN
kronolith_shares_users u ON u.share_id = s.share_id WHERE
s.share_owner = 'vangilst' OR (s.perm_creator & 2) OR (s.perm_default
& 2) OR ( u.user_uid = 'vangilst' AND (u.perm & 2)) ORDER BY
s.attribute_name ASC
3511 Query SELECT 1
3511 Query SELECT g.group_uid AS group_uid, g.group_name AS
group_name FROM horde_groups g, horde_groups_members m WHERE
m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY
g.group_name
3510 Query SELECT 1
3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN
nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner =
'vangilst' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR (
u.user_uid = 'vangilst' AND (u.perm & 2))) ORDER BY s.attribute_name
ASC
3510 Query SELECT 1
3510 Query SELECT * FROM nag_shares WHERE share_name =
'Z2-15KN6MPKsOJYbOJTVuA1'
3511 Query SELECT 1
3511 Query SELECT g.group_uid AS group_uid, g.group_name AS
group_name FROM horde_groups g, horde_groups_members m WHERE
m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY
g.group_name
3510 Query SELECT 1
3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN
nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner =
'vangilst' OR (s.perm_creator & 2) OR (s.perm_default & 2) OR (
u.user_uid = 'vangilst' AND (u.perm & 2))) AND share_owner =
'vangilst' ORDER BY s.attribute_name ASC
3511 Query SELECT 1
3511 Query SELECT g.group_uid AS group_uid, g.group_name AS
group_name FROM horde_groups g, horde_groups_members m WHERE
m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY
g.group_name
3510 Query SELECT 1
3510 Query SELECT DISTINCT s.* FROM nag_shares s LEFT JOIN
nag_shares_users u ON u.share_id = s.share_id WHERE (s.share_owner =
'vangilst' OR (s.perm_creator & 6) OR (s.perm_default & 6) OR (
u.user_uid = 'vangilst' AND (u.perm & 6))) ORDER BY s.attribute_name
ASC
3511 Query SELECT 1
3511 Query SELECT g.group_uid AS group_uid, g.group_name AS
group_name FROM horde_groups g, horde_groups_members m WHERE
m.user_uid = 'vangilst' AND g.group_uid = m.group_uid ORDER BY
g.group_name
3510 Query SELECT 1
3510 Query SELECT DISTINCT s.* FROM kronolith_shares s LEFT JOIN
kronolith_shares_users u ON u.share_id = s.share_id WHERE
(s.share_owner = 'vangilst' OR (s.perm_creator & 2) OR (s.perm_default
& 2) OR ( u.user_uid = 'vangilst' AND (u.perm & 2))) AND s.share_owner
= 'vangilst' ORDER BY s.attribute_name ASC
3510 Query SELECT 1
3510 Query SELECT * FROM kronolith_shares WHERE share_name =
'f0UhDsGiuZFPokNxbgrtcw1'
3512 Connect horde at localhost on horde
3512 Query SET NAMES 'utf8'
3512 Query SELECT 1
3512 Query SHOW CHARACTER SET
3512 Query SELECT 1
3512 Query SET NAMES 'utf8'
3510 Query SELECT 1
3510 Query SELECT object_id, object_name FROM `rampage_objects`
WHERE object_name IN ('') AND type_id = 1
3512 Query SELECT 1
3512 Query INSERT INTO kronolith_events (event_id, event_uid,
event_creator_id, event_title, event_description, event_location,
event_timezone, event_url, event_private, event_status,
event_attendees, event_resources, event_modified, event_start,
event_end, event_allday, event_alarm, event_alarm_methods,
event_recurtype, calendar_id) VALUES ('A88Rpf0sRcGK8kwsEpfSBQ1',
'20130205092348.2SnZwK5ThzMY-vjbxxxVsg1 at webmail2.domainfr',
'vangilst', 'test', '', 'nowhere', '', '', 0, '2', 'a:0:{}', 'a:0:{}',
1360056228, '2013-02-20 00:00:00', '2013-02-20 01:00:00', 0, 0,
'a:0:{}', 0, 'f0UhDsGiuZFPokNxbgrtcw1')
3513 Connect horde at localhost on horde
3513 Query SET NAMES 'utf8'
3513 Query SELECT 1
3513 Query SHOW CHARACTER SET
3513 Query SELECT 1
3513 Query SET NAMES 'utf8'
3513 Query SELECT 1
3513 Query SELECT * FROM horde_histories WHERE object_uid =
'kronolith:f0UhDsGiuZFPokNxbgrtcw1:20130205092348.2SnZwK5ThzMY-vjbxxxVsg1 at webmail2.domain.fr'
3513 Query SELECT 1
3513 Query INSERT INTO horde_histories (object_uid, history_ts,
history_who, history_desc, history_action, history_extra) VALUES
('kronolith:f0UhDsGiuZFPokNxbgrtcw1:20130205092348.2SnZwK5ThzMY-vjbxxxVsg1 at webmail2.domain.fr', 1360056228, 'vangilst', NULL, 'add',
NULL)
3510 Query SELECT 1
3510 Query SELECT object_id, object_name FROM `rampage_objects`
WHERE object_name IN
('20130205092348.2SnZwK5ThzMY-vjbxxxVsg1 at webmail2.domain.fr') AND
type_id = 1
3510 Query SELECT 1
3510 Query INSERT INTO `rampage_objects` (object_name, type_id)
VALUES ('20130205092348.2SnZwK5ThzMY-vjbxxxVsg1 at webmail2.domain.fr', 1)
3510 Query SELECT 1
3510 Query SELECT user_id, user_name FROM `rampage_users` WHERE
user_name IN ('vangilst')
3510 Query SELECT 1
3510 Query SELECT tag_id FROM `rampage_tags` WHERE LOWER(tag_name)
= LOWER('test_tag')
3510 Query SELECT 1
3510 Query INSERT INTO `rampage_tags` (tag_name) VALUES ('test_tag')
3510 Query SELECT 1
3510 Query SELECT 1 from `rampage_tagged` WHERE user_id = 1 AND
object_id = 1 AND tag_id = 1
3510 Query SELECT 1
3510 Query INSERT INTO `rampage_tagged` (user_id, object_id,
tag_id, created) VALUES (1, 1, 1, '2013-02-05T09:23:48')
3510 Query SELECT 1
3510 Query UPDATE `rampage_tag_stats` SET count = count + 1 WHERE
tag_id = 1
3510 Query SELECT 1
3510 Query INSERT INTO `rampage_tag_stats` (tag_id, count) VALUES (1, 1)
3510 Query SELECT 1
3510 Query UPDATE `rampage_user_tag_stats` SET count = count + 1
WHERE user_id = 1 AND tag_id = 1
3510 Query SELECT 1
3510 Query INSERT INTO `rampage_user_tag_stats` (user_id, tag_id,
count) VALUES (1, 1, 1)
3510 Query SELECT 1
3510 Query SELECT pref_scope, pref_name, pref_value FROM
horde_prefs WHERE pref_uid = 'vangilst' AND pref_scope = 'horde'
3510 Query SELECT 1
3510 Query SHOW FIELDS FROM `horde_prefs`
3510 Query SELECT 1
3510 Query SELECT pref_scope, pref_name, pref_value FROM
horde_prefs WHERE pref_uid = 'vangilst' AND pref_scope = 'kronolith'
3510 Query SELECT 1
Any idea ?
More information about the bugs
mailing list