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

* Your Email Address
* Spam protection	Enter the letters below: . ..___..__..__.. . \|\ \| _/ \| \|\| \|\|\ \| \| \\|./__.\|__\|\|__\|\| \\|
Comment	> 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. > > > > > >
Attachment
Watch this ticket

Saved Queries