New ticket submitted by Anthony Messina at 2010/09/11 10:47
Tracking System: Bugs
Category: SyncML
Version: Trunk
Status: Open
Completed: 0%
Priority: 5 - medium
Created By: Anthony Messina
Assigned to: Ralf Becker
Summary: #2725 - PostgreSQL explicit cast error
I get the following error using http://www.egroupware.org/viewvc/egroupware?view=rev&revision=32022 when attempting to initiate a sync from my BlackBerry. The sync fails immediately.
ERROR: operator does not exist: timestamp without time zone >= integer at character 359
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT: (SELECT egw_cal.cal_id,cal_start,recur_type FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE (cal_modified >= 1284144947 OR (SELECT MAX(cal_user_modified) FROM egw_cal_user WHERE egw_cal_user.cal_id=cal_id) >= 1284144947) AND cal_deleted IS NULL AND 1281502800 < cal_end AND cal_start < 1349154000 AND cal_user_type=‘u’ AND cal_user_id IN (‘6’,’-1’,’-25’,’-22’,’-24’,’-6’,’-16’,’-17’,’-19’) AND recur_type IS NULL AND cal_recur_date=0)
UNION
(SELECT egw_cal.cal_id,cal_start,recur_type FROM egw_cal JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id WHERE (cal_modified >= 1284144947 OR (SELECT MAX(cal_user_modified) FROM egw_cal_user WHERE egw_cal_user.cal_id=cal_id) >= 1284144947) AND cal_deleted IS NULL AND 1281502800 < cal_end AND cal_start < 1349154000 AND cal_user_type=‘u’ AND cal_user_id IN (‘6’,’-1’,’-25’,’-22’,’-24’,’-6’,’-16’,’-17’,’-19’) AND cal_recur_date=cal_start)
ORDER BY cal_id,cal_start ASC
linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2725&no_popup=1