Tickets :: Comment on [#12016] kronolith set wrong type

* Your Email Address
* Spam protection	Enter the letters below: .___.__ .__..__.. . [__ \| \\| \|\| \|\|__\| [___\|__/\|__\\|__\\| \|
Comment	> Here is mysqld.log when I create a new event with a tag: > > 130205 10:23:48 3510 Connect horde@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@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@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@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@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@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@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@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@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 ? >
Attachment
Watch this ticket

Saved Queries