#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause

From:	marcel dot esser at gmail dot com	Date:	Sat, 22 Aug 2009 05:59:07 +0000
Subject:	#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-141385@lists.php.net to get a copy of this message

 ID:               40740
 Comment by:       marcel dot esser at gmail dot com
 Reported By:      phpbugs at filofox dot com
 Status:           No Feedback
 Bug Type:         PDO related
 Operating System: Linux Debian Sarge 3.1
 PHP Version:      5.2.1
 Assigned To:      wez
 New Comment:

Same problem on 5.2.6, Ubuntu Jaunty.


Previous Comments:
------------------------------------------------------------------------

[2009-06-16 17:49:09] tony at tonybibbs dot com

Same issue on 5.3.0RC2 using pretty much the same code in the initial
bug report.

------------------------------------------------------------------------

[2009-02-18 08:51:00] nduteil at freedev dot org

Hi,
Still not fixed in the 5.2.8 release. If PDOStatement::bindParam or
PDOStatement::bindValue is used to specified the parameter type (ie : 
PDO::PARAM_INT) everything works as expected. Not forcing the parameter
type to integer generates an error in Mysql.

------------------------------------------------------------------------

[2008-11-26 10:57:40] miha dot vrhovnik at domenca dot si

I re-compiled pdo and pdo_mysql from 5.2.7 RC4 and overwritten
libraries from php 5.2.6. Is this enough? If it is, then this issue is
not fixed.

------------------------------------------------------------------------

[2008-11-12 01:00:01] php-bugs at lists dot php dot net

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

------------------------------------------------------------------------

[2008-11-04 15:25:02] felipe@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/



------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/40740

-- 
Edit this bug report at http://bugs.php.net/?id=40740&edit=1



   

Thread (18 messages)

• phpbugs at filofox dot comTue, 06 Mar 2007 17:13:44 +0000
  • vrana@php.netFri, 23 Mar 2007 15:12:21 +0000#40740 [Opn]: PDO::execute() errors when parameters are used in LIMIT clause
  • tony2001@php.netMon, 26 Mar 2007 09:59:52 +0000#40740 [Opn->Asn]: PDO::execute() errors when parameters are used in LIMIT clause
  • lsmith@php.netFri, 25 May 2007 13:07:55 +0000#40740 [Asn]: PDO::execute() errors when parameters are used in LIMIT clause
  • libertus at libertini dot netMon, 04 Jun 2007 12:14:57 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • jmalis at malisphoto dot comFri, 29 Aug 2008 01:46:16 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • dev at bcdiv dot comSun, 02 Nov 2008 03:43:00 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • felipe@php.netTue, 04 Nov 2008 15:25:02 +0000#40740 [Asn->Fbk]: PDO::execute() errors when parameters are used in LIMIT clause
  • miha dot vrhovnik at domenca dot siWed, 26 Nov 2008 10:57:40 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • nduteil at freedev dot orgWed, 18 Feb 2009 08:51:01 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • tony at tonybibbs dot comTue, 16 Jun 2009 17:49:09 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • marcel dot esser at gmail dot comSat, 22 Aug 2009 05:59:07 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • seb117 at free dot frWed, 26 Aug 2009 16:36:35 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • weblab dot solutions at gmail dot comTue, 08 Sep 2009 12:56:51 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • weblab dot solutions at gmail dot comTue, 08 Sep 2009 13:00:44 +0000#40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • uw@php.netWed, 23 Sep 2009 21:13:01 +0000#40740 [NoF]: PDO::execute() errors when parameters are used in LIMIT clause
  • elim dot css at gmail dot comSat, 11 Dec 2010 06:52:47 +0000Bug #40740 [Com]: PDO::execute() errors when parameters are used in LIMIT clause
  • mightyuhu@php.netSun, 26 Jan 2014 18:16:28 +0000Bug #40740 [NoF->Dup]: PDO::execute() errors when parameters are used in LIMIT clause