Problems with MYSQL queries "Query failed : Can't lock file (errno: 116)"
Posted on 2005-04-28
Here is the backgroun data:
I am running phpMyAdmin 2.5.7
MySQL is 3.23.56
I do not have SSH access, I dont even have access to the local server.
All i have are applications I can develop to acess the backbone.
The backbone itself is not even cpanel so i am in a tuff bind.
I am getting a Query failed : Can't lock file (errno: 116) when I do a simple select off a table.
Here is what is odd.
when I run phpMyAdmin there is no problem: i can see the select and I can do ANYTHING I want to it
Then minute I run a php Code (update, select, insert) It refuse and it gives me a Query failed : Can't lock file (errno: 116)
Is there anything I can do?
I have tried reloading the database, it does not work
I have tried flushing the table and found out I cant flush tables.
What can I do? It has been happening recently since I have updated to phpMyAdmin 2.6.2-rc1 but because of those problems I have decided to go back to 2.5.7-pl1. I am still having the same problem.
Also the php code is simple
Connect to the database with username and password and which database.
with a mysql_connecT()
then do a $query = "SELECT * FROM database";
then do a mysql_query($query)
and it fails.