SQL Problems
Anonymous (not verified) - April 13, 2003 - 10:33
I don't know what's the Problem...
user error: Access denied for user: 'samsnet_user1@localhost' to database 'samsnet_drupal'
query: LOCK TABLES sequences WRITE in /home/samsnet/public_html/drupal/includes/database.mysql.inc on line 69.
warning: Cannot modify header information - headers already sent by (output started at /home/samsnet/public_html/drupal/includes/common.inc:32) in /home/samsnet/public_html/drupal/includes/common.inc on line 329.
search the site/mailing lists before asking questions
http://drupal.org/node/view/1190
Anybody for this trick?
Here is something I am going to suggest that I have not tested.
If the table lock thing is not going to work for some reason or other, why not try this. Suppress the lock unlock code as said in above solution and instead try to lock a file before the table query. Unlock the file, after the query returns. So different instances will wait for the file to be unlocked before accessing the table. ...In short, if the database is not helping us, try to use file locking, which can be totally controled by us.
I could be totally wrong and am open to corrections.