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
