Tickets :: Comment on [#14177] ActiveSync SQL error

* Your Email Address
* Spam protection	Enter the letters below: .___..__ \ /.__ . _/ [ __ >< \| \\| ./__.[_.// \\|__/\|___
Comment	> currently our logs are filled with those (postgres) SQL errors: > > 2015-12-03T08:33:33+00:00 ERR: HORDE Returning HTTP 500 while > handling Sync command. Error is: Protocol error [pid 20755 on line > 160 of "www/rpc.php"] > 2015-12-03T08:33:33+00:00 ERR: HORDE Error in communicating with > ActiveSync server: Protocol error [pid 20755 on line 165 of > "pear/php/Horde/Rpc/ActiveSync.php"] > 2015-12-03T08:33:33+00:00 ERR: HORDE #0 > pear/php/Horde/ActiveSync/Request/Sync.php(201): > Horde_ActiveSync_Request_Sync->_parseSyncFolders() > #1 pear/php/Horde/ActiveSync/Request/Base.php(253): > Horde_ActiveSync_Request_Sync->_handle() > #2 pear/php/Horde/ActiveSync.php(803): > Horde_ActiveSync_Request_Base->handle() > #3 pear/php/Horde/Rpc/ActiveSync.php(143): > Horde_ActiveSync->handleRequest('Sync', 'SEC17314EC9E896...') > #4 www/rpc.php(160): Horde_Rpc_ActiveSync->getResponse(NULL) > #5 {main} [pid 20755 on line 165 of "pear/php/Horde/Rpc/ActiveSync.php"] > 2015-12-03T08:33:33+00:00 ERR: HORDE Buffer contents: [pid 20755 on > line 165 of "pear/php/Horde/Rpc/ActiveSync.php"] > 2015-12-03T09:35:15+01:00 ERR: HORDE [kronolith] SQL QUERY FAILED: > SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not > exist: character varying = integer > LINE 1: ...ginaldate FROM kronolith_events WHERE calendar_id = 0 AND ev... > ^ > HINT: No operator matches the given name and argument type(s). You > might need to add explicit type casts. > SELECT event_id, event_uid, event_description, event_location, > event_private, event_status, event_attendees, event_title, > event_recurcount, event_url, event_timezone, 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 = 0 AND event_alarm > 0 AND ((event_end >= '2015-12-02 > 23:00:00') OR (event_recurenddate >= '2015-12-02 23:00:00' AND > event_recurtype <> 0)) [pid 24338 on line 234 of > "pear/php/Horde/Db/Adapter/Pdo/Base.php"] > > Not exactly sure how the problem presents to users. The affected > clients seem to cause quite more sync traffic though.
Attachment
Watch this ticket

Saved Queries