Bug #17126 Updated: mysql_pconnect() and mysql_query("LOCK TABLES...")

ID: 17126 Updated by: sander@php.net Reported By: stian@nixia.no -Status: Open +Status: Closed Bug Type: MySQL related Operating System: RedHat Linux 7.2 with updates PHP Version: 4.0CVS-2002-05-09 New Comment: PHP is not the appropriate place to do this. If you want auto-unlocking, bug the MySQL-people or learn to write proper code. Previous Comments: ------------------------------------------------------------------------ [2002-05-09 15:08:49] stian@nixia.no 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 this bug report at http://bugs.php.net/?id=17126&edit=1