php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24244 odbc_errormsg() sometimes returns a bad string when no error occurs
Submitted: 2003-06-18 06:50 UTC Modified: 2015-02-09 19:31 UTC
Votes:13
Avg. Score:4.7 ± 0.6
Reproduced:12 of 12 (100.0%)
Same Version:6 (50.0%)
Same OS:4 (33.3%)
From: bl at btn dot de Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 4.3.2 OS: Red Hat Linux
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2003-06-18 06:50 UTC] bl at btn dot de
Description:
------------
We use the IBMDB2 database on our systems. The following bug occured while writing a class supposed to halt the code on database exceptions. 

While checking for strlen(odbc_errormsg())==0 for aborting the routine PHP sometimes (about once in four calls) returns Bad Strings (see below).

Maybe the "message" is taken from an unallocated space on PHP's heap ?!?

It's not that much of a problem to come up with a workaround but PHP shouldn't return random bits of the memory.



Reproduce code:
---------------
$link = odbc_connect("mydb", "myusr","mypwd");
$sql = "[INSERT FLAWLESS STATEMENT HERE]";
odbc_exec($link,$sql)
if(strlen(odbc_errormsg())>0) {
    echo "SQL-Error " . odbc_errormsg();
}
odbc_close($link);



Expected result:
----------------
If $sql contains a valid statement odbc_errormsg() should return an empty string (according to the PHP-Documentation)

Actual result:
--------------
Sometimes parts of the outstream, a URL, short binary data, PHP-Variable names anything might happen ... as I mentioned above, the data might be part of PHP's heap. Some Examples:

T_URI (?) or

(a variable name ?)

ze:12px; } .menue_common{ [... here it goes on for quite a while ...] width: 140px; margin-bottom: 2p 

(part of our stylesheet) or

?? or

(junk)

?? or

(more junk)

aten_I or

(I have that somewhere earlier but I can't remember)

-urlencoded

(this shouldn't be an errormsg)


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-06-18 06:54 UTC] bl at btn dot de
sorry ... one more thing ...

in my "Actual Results" section I forgot to remove the "or"'s ...

So of course the "or"'s are not part of the string which is returned by odbc_errormsg() ...
 [2003-06-18 10:24 UTC] iliaa@php.net
What does var_dump(odbc_error()) return after a valid query?
 [2003-06-26 04:07 UTC] mb at btn dot de
Output of var_dump(odbc_errormsg()) as follows:

string(146) "31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:"

string(122) "1:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:"

These are only two examples. I had to reproduce the error in a small script to generate these. That's why the variety is not that great like in our production environment where we currently use a dirty workaround.
 [2003-06-26 18:23 UTC] sniper@php.net
Do not add comments to your own report, use this link:
http://bugs.php.net/bug.php?id=24244&edit=2

 [2003-07-27 13:19 UTC] iliaa@php.net
Actually I wanted to see the error id not the error message. So please tell me what is the output of:
var_dump(odbc_error())
 [2003-08-01 06:09 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 [2005-01-31 04:20 UTC] zoop at lone dot ath dot cx
I thought I did have a problem running odbc_error() but it looks like it's been clean everytime but as you can see the errormsg seems to get random stuff.   I'll post to this bug if I see the problem again while useing odbc_error()


I've just ran into this problem myself.  it's with db2. the error is usually less frequent for me but sometimes it will happen many times in a row.

this is the code I used to get the random garbage.

$conn_id = odbc_connect("netmap","user","pass");
$err=odbc_errormsg($conn_id);
if($err) {
        var_dump(odbc_error());
        print ">".$err."<";
}


this is the output of an error.
>@\y????? 5Kbz????>^o??????5Pl????? 0E[r?????/Nn??????+E`|????,@Uk?????!?^~?????? ";Up?


This also happens: I just added the var_dump(odbc_error())here: 

string(0) "" >My Company Ltd [SSL_SERVER_I_DN_CN] => zoop@lone.ath.cx [SSL_SERVER_I_DN_EMAILADDRESS] => zoop@lone.ath.cx [SSL_SERVER_M_SERIAL] => 05 [SSL_SERVER_V_START] => Oct 13 22:08:48 2004 GMT [SSL_SERVER_V_END] => Oct 13 22:08:48 2005 GMT [SSL_SERVER_M_VERSION] => 3 [GATEWAY_IN? 


this one is also odd it seems to be loading other php files and spitting them out here not sure how. this page wasn't being accessed when this error occured. this is an a line for another .php file on the system.

string(0) "" >r:cwa2.jar:. blueAuth ".escapeshellcmd($user)." ".escapeshellcmd($pass)." \"".escapeshellcmd($group) 3

Another:
string(0) "" >??

I now changed the script to be a connect of course first.:

var_dump(odbc_error());
$err=odbc_errormsg($conn_id);
if($err) {
        print ">".$err."<";
}

string(0) "" >??
 [2006-09-15 20:36 UTC] bruno dot faust at ig dot com dot br
Hi
I'm having the same problem with de lastest version of php on iseries 550.

The odbc_error function sometimes return ascii(001) and the odbc_errormsg returns bad string.

php version: 5.1.6 and lastest in cvs today.
OS: Windows XP lastest updates.
 [2015-02-09 13:56 UTC] vaughng at dmsllconline dot net
I know this is a old but but it still seems to be popping up in the latest versions (5.4.36-0+deb7u3) Jan 9th build Debain 7.8 OS, it seems to still be quite intermittent, the same functions will trigger one run but not the next, with the same input. The returned string is ether "?" (minus the quotes) or a non printing char.
 [2015-02-09 19:31 UTC] requinix@php.net
@vaughng: Yes, quite old. Since this bug report seems to have lost its information, can you create a new one?
 [2015-02-12 16:33 UTC] vaughng at dmsllconline dot net
@requinix After more searching I think my issue is likely closely related to a poorly documented error in the the way my ODBC driver vendor returns information to SQLGetInfo function, as I think odbc_errormsg calls SQLGetInfo. So no error in the odbc_errormsg function. Thanks for looking at my mistaken post though.
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Fri Oct 30 17:01:24 2020 UTC