ID: 38546 Updated by: [EMAIL PROTECTED] Reported By: selecter at gmail dot com Status: Assigned Bug Type: PDO related Operating System: Gentoo Linux x86_64 -PHP Version: latest snapshot +PHP Version: 5.2.4 Assigned To: wez New Comment:
Fixed the version number. Please don't invent your own versions. The first char in the version field is supposed to be the major version number!! I'm assuming this still exist in PHP 5.2.4. If not, close this. Previous Comments: ------------------------------------------------------------------------ [2007-04-11 15:26:21] tobias dot woell at it-basis dot de 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 ); ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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