Summary | Wrong SQL Dates generated |
Queue | Synchronization |
Queue Version | Git master |
Type | Bug |
State | Resolved |
Priority | 2. Medium |
Owners | |
Requester | d-fens (at) 00010111 (dot) de |
Created | 10/23/2010 (5346 days ago) |
Due | |
Updated | 11/16/2010 (5322 days ago) |
Assigned | 11/16/2010 (5322 days ago) |
Resolved | 11/16/2010 (5322 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
State ⇒ Resolved
State ⇒ Feedback
number, and the code that calls listUids looks correct to me. I also
believe the fatal Horde_Date issue was resolved not that long ago as
well.
i found the problem:
in SyncML/Backend/Horde.php Line 916 $registry->{$database}->listUids
is called without a start/end parameter and the sql driver sets it to
0/0 so changes from 1970to 1970 are searched
-
SyncML_Backend::getParameter($databaseURI, 'source'));
+
SyncML_Backend::getParameter($databaseURI, 'source'), $from_ts, $to_ts);
so now i get the events but finally a PHP Fatal error:
Call to undefined method Horde_Date::correct() in
/var/www/_horde/horde/framework/Icalendar/lib/Horde/Icalendar.php on
line 937
this protected call must be removed in Icalender.php as its already
called from the Horde_Date object itself
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Wrong SQL Dates generated
Queue ⇒ Synchronization
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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"]