Hi I don't know if this is of any interrest etc, but atleast it is a small little issue from the big, big world.
---------- Forwarded message ---------- Date: 10 May 2002 08:41:19 -0000 From: PHP Bug Database <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Bug #17126 Updated: mysql_pconnect() and mysql_query("LOCK TABLES...") ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=17126&edit=2 ID: 17126 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -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] [EMAIL PROTECTED] 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>"; ?> ------------------------------------------------------------------------ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php