By gecki on

HI

The install went fine, except i keep on getting this error when i post (it does not effect the thing, it just looks ugly)

user warning: Access denied for user: 'wootdrupal@%' to database 'wootdrupal' query: LOCK TABLES sequences WRITE in /home/content/t/h/e/thesleekgeek/html/pod/includes/database.mysql.inc on line 120.

What is the problem, thanks

⋅ Categories: Drupal 4.7.x

Comments

heine’s picture

heine commented

See LOCK TABLES sequences WRITE error from the Troubleshooting FAQ. This may mean that you need to contact your host and ask them for Lock tables permission. If you're on Godaddy, don't bother; look for another host (or hostingplan or CMS).
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

gecki’s picture

gecki commented

Oh well, thanks, it works anyway

niosop’s picture

niosop commented

If your site isn't going to have much posting, you could remove (or comment out) the table locking code. This will likely cause issues with the sequences table on busy sites, but should be ok if you're the only one posting and everyone else is just viewing.

I'm thinking of writing a replacement for the locking code because this is a fairly common problem, but I'm lacking in both inspiration and time. Will let you know if I get around to it.

[edit] I found some time and inspiration :) A preliminary idea is at http://drupal.org/node/1190 It hasn't been tested but if you'd like to test it, many would appreciate it I'm sure.

Thanks,
Niosop