#47764 [Opn]: PDO statement blank page
ID: 47764 User updated by: dimas at webimpact dot com Reported By: dimas at webimpact dot com Status: Open Bug Type: PDO related Operating System: Linux wiaspweb17 2.6.9-34.ELsmp PHP Version: 5.2.9 New Comment: Good day, yes I cannot reproduce this problem on MySQL, it looks like its only dblib issue. I noticed it said that extension is experimental. Is there anything can be done to have it fixed? Previous Comments: [2009-03-25 10:06:03] ka...@php.net I tried with the PDO_MySQL driver but I can't reproduce the problem, does this only happen with dblib and on Linux? [2009-03-24 20:05:52] dimas at webimpact dot com Thanks for a quick reply, that is the problem that absolutely no errors loged by the server and no exceptions by PDO :-( [2009-03-24 19:09:29] ka...@php.net Does your webserver log show anything that could might have been more of help here? [2009-03-24 18:02:32] dimas at webimpact dot com Description: Good day, we are using PDO and got into the funny problem, The code below shows that we are trying to simple reuse the statement but when first query with ci_id = 70 brings not result, PDO dies on a second execute. We see only blank page, if first query brings some results everything is fine. Can u please help. Thank you. Reproduce code: --- $oDbConn = new PDO(dblib:dbname=;host=:1433, , ); $oDbConn-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $oStatement = $oDbConn-prepare('SIMPLE SELECT QUERY WHERE ci_id = :ci_id'); $oStatement-bindParam(':ci_id', $val, PDO::PARAM_INT); $val = 70; $oStatement-execute(); $val = 1000; $oStatement-execute(); -- Edit this bug report at http://bugs.php.net/?id=47764edit=1
#47764 [NEW]: PDO statement blank page
From: dimas at webimpact dot com Operating system: Linux wiaspweb17 2.6.9-34.ELsmp PHP version: 5.2.9 PHP Bug Type: PDO related Bug description: PDO statement blank page Description: Good day, we are using PDO and got into the funny problem, The code below shows that we are trying to simple reuse the statement but when first query with ci_id = 70 brings not result, PDO dies on a second execute. We see only blank page, if first query brings some results everything is fine. Can u please help. Thank you. Reproduce code: --- $oDbConn = new PDO(dblib:dbname=;host=:1433, , ); $oDbConn-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $oStatement = $oDbConn-prepare('SIMPLE SELECT QUERY WHERE ci_id = :ci_id'); $oStatement-bindParam(':ci_id', $val, PDO::PARAM_INT); $val = 70; $oStatement-execute(); $val = 1000; $oStatement-execute(); -- Edit bug report at http://bugs.php.net/?id=47764edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47764r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47764r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47764r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47764r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47764r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47764r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47764r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47764r=needscript Try newer version: http://bugs.php.net/fix.php?id=47764r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47764r=support Expected behavior: http://bugs.php.net/fix.php?id=47764r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47764r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47764r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47764r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47764r=php4 Daylight Savings:http://bugs.php.net/fix.php?id=47764r=dst IIS Stability: http://bugs.php.net/fix.php?id=47764r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47764r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47764r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47764r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47764r=mysqlcfg
#47764 [Opn]: PDO statement blank page
ID: 47764 User updated by: dimas at webimpact dot com Reported By: dimas at webimpact dot com Status: Open Bug Type: PDO related Operating System: Linux wiaspweb17 2.6.9-34.ELsmp PHP Version: 5.2.9 New Comment: Thanks for a quick reply, that is the problem that absolutely no errors loged by the server and no exceptions by PDO :-( Previous Comments: [2009-03-24 19:09:29] ka...@php.net Does your webserver log show anything that could might have been more of help here? [2009-03-24 18:02:32] dimas at webimpact dot com Description: Good day, we are using PDO and got into the funny problem, The code below shows that we are trying to simple reuse the statement but when first query with ci_id = 70 brings not result, PDO dies on a second execute. We see only blank page, if first query brings some results everything is fine. Can u please help. Thank you. Reproduce code: --- $oDbConn = new PDO(dblib:dbname=;host=:1433, , ); $oDbConn-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $oStatement = $oDbConn-prepare('SIMPLE SELECT QUERY WHERE ci_id = :ci_id'); $oStatement-bindParam(':ci_id', $val, PDO::PARAM_INT); $val = 70; $oStatement-execute(); $val = 1000; $oStatement-execute(); -- Edit this bug report at http://bugs.php.net/?id=47764edit=1