Tickets :: Comment on [#9339] Wrong SQL Dates generated

* Your Email Address
* Spam protection	Enter the letters below: .__ .__ .___..__ . , [__)\| \ \| [__) \./ [__)\|__/ \| \| \ \|
Comment	> hi, > > have a look at this output of current git, the sql dates do not match > the timespan as announced in the "compiling server changes" message, > its after a reset from server > > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [horde] Compiling server > changes from 1970-01-01 01:00:00 to 2010-10-23 13:54:42 [pid 6151 on > line 640 of "/var/www/_horde/horde/framework/SyncML/SyncML/Sync.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [kronolith] SQL (0.0005s) > SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE > pref_uid = 'x@xxx.xx' AND pref_scope = 'kronolith' [pid > 6151 on line 761 of > "/var/www/_horde/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [kronolith] SQL (0.0002s) > 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 = > 'x@xxx.xx' AND g.group_uid = m.group_uid ORDER BY > g.group_name [pid 6151 on line 761 of > "/var/www/_horde/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [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 WHERE s.share_owner = 'x@xxx.xx' OR (s.perm_creator & 2) > OR (s.perm_default & 2) OR ( u.user_uid = 'x@xxx.xx' AND (u.perm & > 2)) ORDER BY s.attribute_name ASC [pid 6151 on line 477 of > "/var/www/_horde/horde/framework/Share/lib/Horde/Share/Sql.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [turba] SQL (0.0005s) > SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE > pref_uid = 'x@xxx.xx' AND pref_scope = 'turba' [pid 6151 on > line 761 of > "/var/www/_horde/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [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 WHERE > s.share_owner = 'x@xxx.xx' OR (s.perm_creator & 4) OR (s.perm_default > & 4) OR ( u.user_uid = 'x@xxx.xx' AND (u.perm & 4)) ORDER BY > s.share_name ASC [pid 6151 on line 477 of > "/var/www/_horde/horde/framework/Share/lib/Horde/Share/Sql.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [turba] SQL (0.0002s) > SELECT COUNT() FROM horde_perms WHERE perm_name = > 'turba:sources:localsql' [pid 6151 on line 761 of > "/var/www/_horde/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [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 WHERE (s.share_owner = 'x@xxx.xx' OR (s.perm_creator & > 2) OR (s.perm_default & 2) OR ( u.user_uid = 'x@xxx.xx' AND (u.perm & > 2))) AND s.share_owner = 'x@xxx.xx' ORDER BY s.attribute_name ASC > [pid 6151 on line 477 of > "/var/www/_horde/horde/framework/Share/lib/Horde/Share/Sql.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [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 WHERE s.share_owner = 'x@xxx.xx' OR (s.perm_creator & 4) > OR (s.perm_default & 4) OR ( u.user_uid = 'x@xxx.xx' AND (u.perm & > 4)) ORDER BY s.attribute_name ASC [pid 6151 on line 477 of > "/var/www/_horde/horde/framework/Share/lib/Horde/Share/Sql.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [kronolith] > Kronolith_Driver_Sql::_listEventsConditional(): user = "x@xxx.xx"; > query = "SELECT event_id, event_uid, event_description, > event_location, event_private, event_status, event_attendees, > event_title, event_recurcount, event_url, event_recurtype, > event_recurenddate, event_recurinterval, event_recurdays, > event_start, event_end, event_allday, event_alarm, > event_alarm_methods, event_modified, event_exceptions, > event_creator_id, event_resources, event_baseid, > event_exceptionoriginaldate FROM kronolith_events WHERE calendar_id = > ? AND event_baseid = '' AND ((event_end >= ? AND event_start <= ?) OR > (event_recurenddate >= ? AND event_start <= ? AND event_recurtype <> > ?))"; values = "x@xxx.xx,1969-12-31 23:00:00,1970-01-01 > 22:59:59,1969-12-31 23:00:00,1970-01-01 22:59:59,0" [pid 6151 on line > 349 of "/var/www/_horde/horde/kronolith/lib/Driver/Sql.php"] > 2010-10-23T13:54:43+02:00 DEBUG: HORDE [horde] Sending 0 server > changes for client URI event [pid 6151 on line 640 of > "/var/www/_horde/horde/framework/SyncML/SyncML/Sync.php"] >
Attachment
Watch this ticket

Saved Queries