Hi all!
I'm new to Drupal and have managed to make my way through the installation process. However, everytime I try to add a user or post a story I get a LOCK TABLES error.
I have read a lot of the support posts about this problem. I am with GoDaddy and cannot make changes to the MSQL permissions. and tried fixing the file with the following patch;
--- Z:\database.mysql.inc\database.mysql.inc.old Thu Apr 14 18:50:24 2005 UTC
+++ Z:\database.mysql.inc\database.mysql.inc Wed Apr 27 19:06:28 2005 UTC
@@ -148,10 +148,8 @@
*/
function db_next_id($name) {
$name = db_prefix_tables($name);
- db_query('LOCK TABLES {sequences} WRITE');
- $id = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s'", $name)) + 1;
+ $id = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s' FOR UPDATE", $name)) + 1;
db_query("REPLACE INTO {sequences} VALUES ('%s', %d)", $name, $id);
- db_query('UNLOCK TABLES');
return $id;
}
Nevertheless, I continue to get the following error message:
"
user error: Access denied for user: 'NATURALHEALING@%' to database 'NATURALHEALING'
query: LOCK TABLES sequences WRITE in /home/content/j/w/b/jwbabiakr/html/naturalhealing/drupal/includes/database.mysql.inc on line 66.
warning: Cannot modify header information - headers already sent by (output started at /home/content/j/w/b/jwbabiakr/html/naturalhealing/drupal/includes/common.inc:384) in /home/content/j/w/b/jwbabiakr/html/naturalhealing/drupal/includes/common.inc on line 192."
Can anyone please help?
John
