Error deleting user [message #2236] |
Mon, 06 May 2002 16:28 ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
![](http://fudforum.org/forum/images/custom_avatars/177.jpg) |
esm2002
![United States United States](/forum/images/flags/us.png) Messages: 339 Registered: May 2002 Location: Atlanta Georgia
Karma: 0
|
Senior Member |
|
|
Tried to delete a user test01 and received the following error message:
Warning: Unlink failed (No such file or directory) in /home/saint351/public_html/fudforum/nb/include/users_adm.inc on line 171 unable to remove users external settings
other than the Admin user, test01 was the only user.
Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
|
|
|
Re: Error deleting user [message #2237 is a reply to message #2236] |
Mon, 06 May 2002 16:31 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
Ilia
![Canada Canada](/forum/images/flags/ca.png) Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Fixed in CVS.
Affected file users_adm.inc.t
Patched file attached to the message.
FUDforum Core Developer
|
|
|
|
Re: Error deleting user [message #2241 is a reply to message #2239] |
Mon, 06 May 2002 17:10 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
Ilia
![Canada Canada](/forum/images/flags/ca.png) Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Hmmm....
That error was actually pretty harmless it merely indicated that a file that did not exist could not be deleted.
Try re-starting your browser and accessing the forum again...
FUDforum Core Developer
|
|
|
|
|
|
Re: Error deleting user [message #2248 is a reply to message #2247] |
Mon, 06 May 2002 18:13 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) ![Go to next message Go to next message](/forum/theme/default/images/down.png) |
hackie
![Canada Canada](/forum/images/flags/ca.png) Messages: 177 Registered: January 2002
Karma: 0
|
Senior Member Core Developer |
![1610671](/forum/theme/default/images/icq.png)
|
|
esm2002 wrote on Mon, 06 May 2002 2:08 PM | just sits there and never does get to the FUD forum
|
Okie, this is little snafu with persistant connections and mysql table locking and php's ineptness....
Basically, what is currently happening is that your PHP script when it got that error left the MySQL tables locked, and since php's dumb and didn't excute the atexit function which unlocks the tables because of that error.
So, you really have two solutions that you can try:
First you can restart your webserver which will fix this (because upon restart php will close all mysql connections and therefor drop the locks)
Second you can use mysqladmin utlity to get the list of all the active mysql threads, and kill off the thread that is holding the tables hostage ![Smile](images/smiley_icons/icon_smile.gif)
Also, in the future to prevent this from happening disable persistant connections in the globals control pannel, while they do enchance the preformance a bit, because php is broken in some cases it's now safe to use it, as you've just found out.
If you require more help resolving this prob ask away
cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
|
|
|
|
Re: Error deleting user [message #2256 is a reply to message #2255] |
Mon, 06 May 2002 18:54 ![Go to previous message Go to previous message](/forum/theme/default/images/up.png) |
Ilia
![Canada Canada](/forum/images/flags/ca.png) Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
In 99% of the cases it is safe, especially since we have hadlers for errors that check for table locks and clear them. I suspect on some PHP versions error handler functions do not work as advertised and such problems occur.
This is actually the 1st time such an error has occured outside of our test servers. Under normal conditions ONLY fatal parse error (cannot be handled by php error handling) could in some cases result in a left over table lock.
As a rule generally persistant connections are better then opening a socket everytime.
FUDforum Core Developer
|
|
|