php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #47764 PDO_DBLIB: statement blank page
Submitted: 2009-03-24 18:02 UTC Modified: 2009-05-08 01:00 UTC
From: dimas at webimpact dot com Assigned: fb-req-jani (profile)
Status: No Feedback Package: PDO related
PHP Version: 5.2.9 OS: Linux wiaspweb17 2.6.9-34.ELsmp
Private report: No CVE-ID: None
View Developer Edit
 [2009-03-24 18:02 UTC] 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 = 700000 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 = 700000;
$oStatement->execute();	

$val = 1000;
$oStatement->execute();

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-03-24 19:09 UTC] kalle@php.net 
Does your webserver log show anything that could might have been more of help here?
 [2009-03-24 20:05 UTC] 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-25 10:06 UTC] kalle@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-25 14:02 UTC] dimas at webimpact dot com 
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?
 [2009-04-30 10:51 UTC] jani@php.net 
Have you tried to run the script on command line using the PHP CLI 
binary? Does it crash or what happens?
 [2009-05-08 01:00 UTC] 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".
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sat Nov 08 19:00:01 2025 UTC