#35830 [Opn->Asn]: Type mismatch with bind variables

From: Date: Thu, 29 Dec 2005 09:09:00 +0000
Subject: #35830 [Opn->Asn]: Type mismatch with bind variables
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-91212@lists.php.net to get a copy of this message 
 ID:               35830
 Updated by:       sniper@php.net
 Reported By:      nate-php at seekio dot com
-Status:           Open
+Status:           Assigned
 Bug Type:         PDO related
 Operating System: Debian 3.1 Sarge
-PHP Version:      5.1.1
+PHP Version:      5CVS-2005-12-29 (snap)
-Assigned To:      
+Assigned To:      wez
 New Comment:

Assigned to the PDO maintainer.


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

[2005-12-29 01:32:54] nate-php at seekio dot com

Same thing:

Exception at line 19 of file testdb.php: SQLSTATE[22005]: Error in
assignment: -99999 [IBM][CLI Driver] CLI0112E  Error in assignment.
SQLSTATE=22005 (SQLExecute[-99999] at
/usr/local/src/php5.1-200512282330/ext/pdo_odbc/odbc_stmt.c:133)

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

[2005-12-29 01:20:26] tony2001@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip



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

[2005-12-29 01:02:59] nate-php at seekio dot com

Yes, I'm quite sure.  I can install 5.1.0 and it works fine, touch
nothing but the version and it stops working.  Here is the configure
line for php, which I forgot to give earlier:

./configure  --with-apache=../apache_1.3.34 --with-mysql
--with-pdo-mysql --with-gd --with-zlib --with-gettext
--with-pdo-odbc=ibm-db2,/home/db2inst1/sqllib

The php.ini is just the php.ini-recommended from the tarball with no
changes, and nothing in the apache conf overriding anything other than
the include path.

Thanks,
Nate

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

[2005-12-28 21:06:41] tony2001@php.net

>The same code that worked fine in 5.1.0
Are you sure?
The only difference between 5.1.0 and 5.1.1 is that 5.1.1 doesn't have
Date class, which obviously doesn't affect PDO in any way.

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

[2005-12-28 20:39:20] nate-php at seekio dot com

Oops, that create table statement should read:

create table nate.testdb (a int, b varchar(50))

(I had cut and pasted in the wrong schema)

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

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/35830

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

Thread (10 messages)

« previous php.bugs (#91212) next »