#12038 [Com]: problem with closing database handles

ID: 12038 Comment by: dennis at benade dot co dot za Reported By: kirill at mns dot ru Status: Bogus Bug Type: InterBase related Operating System: RedHat 7.1 PHP Version: 4.0.6 New Comment: I had exactly the same problem and got it to work by using: ibase_free_result($res); before: ibase_close($dbhandle); This solved the problem for me. Previous Comments: ------------------------------------------------------------------------ [2002-07-01 07:15:43] sniper@php.net Better try the CVS snapshots as there have been few fixes in CVS for interbase.. ------------------------------------------------------------------------ [2002-07-01 06:22:14] derick@php.net Thank you for taking the time to report a problem with PHP. Unfortunately your version of PHP is too old -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PHP. ------------------------------------------------------------------------ [2001-07-11 04:26:56] kirill at mns dot ru Here is warning for sample code: Warning: InterBase: invalid statement handle in /var/www/users/kirill/bug.php on line 2 ------------------------------------------------------------------------ [2001-07-11 04:25:14] kirill at mns dot ru PHP reports warning about invalid statement handle after I use ibase_close() to close opened with ipbase_connect() database connection. If I comment ibase_close that removes this warning (all this code must be in function to get warning,in plain use - there are no warnings in any case). I think that it's a bug in cleanup code at shutdown. <? first_connect(); function first_connect(){ $dbh = ibase_connect("localhost:/usr/interbase/data/db.gdb", "login","password", none, 100, 3, "role"); if (!$dbh) { echo "An error occured while connecting!!!\n"; exit; } else { $username = "KIRILL"; $qry = "SELECT * FROM GETUSERROLE('$username')"; $sth = ibase_query ($dbh, $qry); while ($row = ibase_fetch_object ($sth)){} ibase_close($dbh); } } ?> './configure' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-shared' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8' '--with-xml' '--with-mod_charset' '--without-pgsql' '--without-interbase' '--without-recode' '--without-mhash' '--without-sablot' ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=12038&edit=1