ID: 38546
Comment by: tobias dot woell at it-basis dot de
Reported By: selecter at gmail dot com
Status: Assigned
Bug Type: PDO related
Operating System: Gentoo Linux x86_64
PHP Version: latest snapshot
Assigned To: wez
New Comment:
Suggestion for workaround (works with PHP 5.1.6 and MySql 4.1.1):
$tmp = (int) $this->getDue_Date_IsWeek();
$stmt->bindParam(':Due_Date_IsWeek' , $tmp , PDO::PARAM_BOOL );
Previous Comments:
------------------------------------------------------------------------
[2007-02-06 16:38:58] hans at velum dot net
This looks to be the same issue as:
http://pecl.php.net/bugs/bug.php?id=9919
------------------------------------------------------------------------
[2007-02-06 16:35:47] hans at velum dot net
I don't think that anyone said this was crashing. It certainly is a
fatal error in that it doesn't work. And using PDO w/ Exception error
mode will (should!) eventually result in a fatal error for the app
that's using it.
This is clearly a PDO bug. If any application that uses PDO has to
check to see if MySQL is being used & then alter that type params passed
to bindValue() then there is NO VALUE in having the small set of
*abstracted* types that PDO does provide.
------------------------------------------------------------------------
[2006-08-22 16:59:46] [EMAIL PROTECTED]
First of all, there is no crash.
Fatal error is the result of your trigger_error() call.
PDOStatement::execute() fails because MySQL API doesn't support boolean
parameters (though they can be "emulated" through PDO).
I'm leaving this to the maintainer to decide.
------------------------------------------------------------------------
[2006-08-22 16:42:10] selecter at gmail dot com
That's what you get: Fatal error: : in /tmp/1.php on line 66
That's all that matters...
Instead of:
'show_email' => (bool) 1,
'show_smiles' => (bool) 1,
Write:
'show_email' => 1,
'show_smiles' => 1,
and the query will be executed successfully.
------------------------------------------------------------------------
[2006-08-22 16:29:14] [EMAIL PROTECTED]
I get:
---
array(1) {
[0]=>
string(5) "00000"
}
Notice: Undefined property: PDO::$errorCode in /tmp/1.php on line 62
Notice: Undefined offset: 2 in /tmp/1.php on line 62
<pre></pre>
Fatal error: : in /tmp/1.php on line 66
---
No crashes. valgrind doesn't show anything wrong there.
------------------------------------------------------------------------
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/38546
--
Edit this bug report at http://bugs.php.net/?id=38546&edit=1
