6.0.0-alpha12
6/12/25

[#9339] Wrong SQL Dates generated
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

History
11/16/2010 07:02:03 AM Michael Rubinsky Comment #4
State ⇒ Resolved
Reply to this comment
Well, *now* it's resolved, anyway :)
11/16/2010 06:56:31 AM Michael Rubinsky Comment #3
State ⇒ Feedback
Reply to this comment
Is this still an issue? Current SyncML code doesn't contain that line 
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.
11/08/2010 10:22:11 AM d-fens (at) 00010111 (dot) de Comment #2 Reply to this comment
hi,

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


10/24/2010 12:21:39 PM Jan Schneider Version ⇒ Git master
 
10/23/2010 12:09:33 PM d-fens (at) 00010111 (dot) de Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Wrong SQL Dates generated
Queue ⇒ Synchronization
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this 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"]

Saved Queries