[Tickets #9339] Wrong SQL Dates generated

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/9339
------------------------------------------------------------------------------
  Ticket           | 9339
  Erstellt Von     | d-fens at 00010111.de
  Zusammenfassung  | Wrong SQL Dates generated
  Warteschlange    | SyncML
  Typ              | Bug
  Status           | Unconfirmed
  Priorität       | 2. Medium
  Milestone        |
  Patch            |
  Zuständige      |
------------------------------------------------------------------------------


d-fens at 00010111.de (2010-10-23 08:09) hat geschrieben:

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 at 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 at 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 at xxx.xx' OR (s.perm_creator & 2) OR  
(s.perm_default & 2) OR ( u.user_uid = 'x at 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 at 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 at xxx.xx' OR (s.perm_creator & 4) OR (s.perm_default  
& 4) OR ( u.user_uid = 'x at 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 at xxx.xx' OR (s.perm_creator & 2)  
OR (s.perm_default & 2) OR ( u.user_uid = 'x at xxx.xx' AND (u.perm &  
2))) AND s.share_owner = 'x at 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 at xxx.xx' OR (s.perm_creator & 4) OR  
(s.perm_default & 4) OR ( u.user_uid = 'x at 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 at 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 at 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"]