[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-22 12:34) wrote:

> I'm not sure I understand your issue.  That query uses bind
> parameters and goes through the DB abstraction layer before going to
> mysql.  Also, your report states this is from version 2.2 of
> Kronolith, but the line number given in the error message does not
> correspond to any line in 2.2 that would produce such a message.
> Lastly, this works fine for me on 3 different boxes using various
> flavors of mysql 5.0.x
>

Hi Michael,

I will try to clarify you the question.

I find the error reported to you on horde.log.

I test de SELECT command executing it directly with mysql-client. I  
found the same error.

I think is a problem with the use of  the character '?' on the select.  
I think you are using it on some places in sql.php i.e.:

line 502: "WHERE event_id = ?'"

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 $

Patched with sql.php.patch and sql.php.2.patch. (I patched it after  
the error),

Can be it is a problem of backward compatibility of Mysql 5, and I  
need to set any parameter on my.cnf, I'm checking it.

If you consider this is not a bug I can to continue this discussion on  
the mailing list.

Thanks in advance.