Mysql Error

Questions on subjects not related to other forums (installing on other hostings, etc.). DigitaldDruid.Net staff will not answer here.

Moderator: marco

Post Reply
mhlspn
Posts: 3
Joined: Mon May 11, 2009 9:10 am

Mysql Error

Post by mhlspn »

Hello,

I am getting the following error message:

ERROR IN: lock tables res_prenota2009 write,res_personalizza read
1044: Access denied for user 'xxxxxx'@'%' to database 'xxxxxx'

I have read the board and found out that it has to do with the lock table privilege. So I contacted my provider and have now the lock table privilege.

mysql> SHOW PRIVILEGES;

gives:
...
Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege)
...

Still I cannot get rid of this ERROR IN: lock tables res_prenota2009 write....

It drives me nuts ;-)

Any hints, ideas or help is very much appreciated.

Michael
Mac
Posts: 1
Joined: Tue Jan 12, 2010 10:21 am

Re: Mysql Error

Post by Mac »

i had the same error. After i while i found a way to simply remove the line from the code wich generates the error message. So the error still excisted, (but does not affect functionality). And when you use the program you won't notice anything!
This is the file you must open with a php-editor (or notepad) /php-residence/includes/funzioni_mysql.php then goto line number 173, where you'll find "if (!$risul) echo "<br>ERROR IN: lock tables $lista_tabelle<br>".mysql_errno().": ".mysql_error()."<br>";" now simply remove "echo "<br>ERROR IN: lock tables $lista_tabelle<br>".mysql_errno().": ".mysql_error()."<br>";" and that's it! it should work now. Note: when you make an template, you have to remove "echo "<br>ERROR IN: lock tables $lista_tabelle<br>".mysql_errno().": ".mysql_error()."<br>";" " from the template file too..

Hope this will help you!
Post Reply