[Tickets #14177] ActiveSync SQL error

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14177
------------------------------------------------------------------------------
  Ticket             | 14177
  Created By         | o+horde at immerda.ch
  Summary            | ActiveSync SQL error
  Queue              | Synchronization
  Version            | FRAMEWORK_5_2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


o+horde at immerda.ch (2015-12-03 08:41) wrote:

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.