By iamalive on

Can anyone help, please.

I frequently get the following error message when I save some new input:

user error: Access denied for user: 'xxxxx@localhost' to database 'drupal'
query: LOCK TABLES sequences WRITE in /home/public_html/drupal/includes/database.mysql.inc on line 66.
warning: Cannot modify header information - headers already sent by (output started at /home/public_html/drupal/includes/common.inc:384) in /home/public_html/drupal/includes/common.inc on line 192.

I have the drupal site in a folder called drupal. Whenever I do a refresh, the message goes away and the input appears to have been saved. I've looked at the files mentioned, but can't see anything wrong. However, I'm no programmer.

Can anyone interpret this and suggest a remedy?

Comments

scoonz’s picture

scoonz commented

Just go to phpmyadmin and grant all the permissions to user xxxx
This should work
-
Currently I'm moving our music demo studio site to Drupal.

iamalive’s picture

iamalive commented

Thanks for the input again - appreciate any help.

Sadly, I already gave myself all rights in the database.

If I look at the message, it seems to be sending the same info twice:
Cannot modify header information - headers already sent by (output started at /includes/common.inc:384) in /includes/common.inc in Line192.

But I don't understand why.

styro’s picture

styro commented

http://drupal.org/node/17241

http://drupal.org/node/1424

--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
Example Knowledge Base built using Drupal

iamalive’s picture

iamalive commented

Thanks for the hint. It certainly seems relevant.

the second part, I checked and that doesn't seem to be the issue, so I've now contacted my hosting company to ask for the global LOCK TABLES privileges suggested in the FAQ.

I'll keep you informed.

Thanks

iamalive’s picture

iamalive commented

Now I've managed to get the hosting company to give me these privileges, the error messages have gone away.

Great! Thanks!