[Tickets #7092] Re: Query's from Drivers/SQl.php incompatibility with Mysql 5

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7092
------------------------------------------------------------------------------
  Ticket             | 7092
  Updated By         | lauren at servicom2000.com
  Summary            | Query's from Drivers/SQl.php incompatibility with
                     | Mysql 5
  Queue              | Kronolith
  Version            | 2.2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


lauren at servicom2000.com (2008-07-23 04:29) wrote:

I have configured horde logging in debug mode an get this:

Jul 23 10:02:03 HORDE [debug] [kronolith]  
Kronolith_Driver_sql::getByUID(): user = "a00ah001"; query = "SELECT  
event_id, event_uid, calendar_id, event_descri
ption, event_location, event_private, event_status, event_attendees,  
event_keywords, event_title, event_category, event_recurcount,  
event_recurtype, event_re
curenddate, event_recurinterval, event_recurdays, event_start,  
event_end, event_alarm, event_modified, event_exceptions,  
event_creator_id FROM kronolith_even
ts WHERE event_uid = ? AND calendar_id IN (?)"; values = "" [pid 1636  
on line 427 of "/var/www/horde/kronolith/lib/Driver/sql.php"]

Jul 23 10:02:03 HORDE [error] [kronolith] DB Error: syntax error:  
SELECT event_id, event_uid, calendar_id, event_description,  
event_location, event_private, event_status, event_attendees,  
event_keywords, event_title, event_category, event_recurcount,  
event_recurtype, event_recurenddate, event_recurinterval,  
event_recurdays, event_start, event_end, event_alarm, event_modified,  
event_exceptions, event_creator_id FROM kronolith_events WHERE  
event_uid = ? AND calendar_id IN (?) [nativecode=1064 ** You have an  
error in your SQL syntax; check the manual that corresponds to your  
MySQL server version for the right syntax to use near '? AND  
calendar_id IN (?)' at line 1] [pid 1636 on line 431 of  
"/var/www/horde/kronolith/lib/Driver/sql.php"]

I thiks this is that the values for the variables are unset.

This occurs on calendar sync process from Funambul 6.5.8/Outlook2007 to Horde.

I can send you horde.log and sync logs if you wish.