From: [EMAIL PROTECTED]
Operating system: RedHat Linux 7.2 with updates
PHP version: 4.0CVS-2002-05-09
PHP Bug Type: MySQL related
Bug description: mysql_pconnect() and mysql_query("LOCK TABLES...")
This is a test-thing from one of my projects. The problem is the LOCK
TABLES not beeing unlocked again.. This is a userproblem, but can
sometimes be hard to track when you rerun the script, and hit another
Apache-PID and tables still beeing locked.. maybe when a Link identifier
is destroyed, or new database is selected, an "UNLOCK TABLES" should be
ommited?
testsource from project:
<?
unset ( $ROOT ); $ROOT = "../";
include_once ( $ROOT."include/setup.php" );
include_once ( $INCLUDE."mysql.php" );
MySQL_DoConnect();
echo "Locking...";
mysql_query("LOCK TABLES Ansatt WRITE;");
echo "Done (".mysql_error().")<br>";
?>
--
Edit bug report at http://bugs.php.net/?id=17126&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=17126&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=17126&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=17126&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=17126&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=17126&r=support
Expected behavior: http://bugs.php.net/fix.php?id=17126&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=17126&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=17126&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=17126&r=globals
