[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
+New Attachment     | sql.php
------------------------------------------------------------------------------


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

>> 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.