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 test de SELECT command executing it directly with mysql-client. I > >>> found the same error. > >> > >> Well, if all you did was paste that query into the client, then of > >> course it won't work. The '?' is a placeholder that gets replaced > >> with the real values when the actual query is done. > >> > > Ok, I undestand it, but if it must be replaced, wich is the value > must be registered in the log, the placeholder '?' or the real value?. > > > > I have checked the mydql.log and foungd this: > > > > 1048 Query SELECT event_id, event_uid, > calendar_id, eve > > nt_description, event_location, event_private, event_status, > event_attendees, ev > > ent_keywords, event_title, event_category, event_recurcount, > event_recurtype, ev > > ent_recurenddate, event_recurinterval, event_recurdays, event_start, > event_end, > > event_alarm, event_modified, event_exceptions, event_creator_id FROM > kronolith_e > > vents WHERE event_uid = ? AND calendar_id IN (?) > > > > I think in any case the placeholder '?' is not replaced and it makes > the error. > > > > > >>> The version of sql.php I have installed is > >>> > >>> $Horde: kronolith/lib/Driver/sql.php,v 1.136.2.36 2008/05/14 19:41:02 > >>> chuck Exp $ > >> > >> Again, line 435 in this version of the file would not output that > >> error...are you 100% positive that you have not made local changes to > >> this file? > >> > > > > I attach you my sql.php file > > > >>> Patched with sql.php.patch and sql.php.2.patch. (I patched it after > >>> the error), > >> > >> ...and what patches are these? I have no idea what these patches are. > > > > http://bugs.horde.org/ticket/6946 > > http://bugs.horde.org/ticket/6966 > > > > I'll try to make more intensive test, change the origin calendar, > create new calendars, etc. > > > > > > > >
Attachment
Watch this ticket

Saved Queries