By somatics on

When I check a box for a Module in the Module admin page to enable that Module and then save it, the result I get is a white web page with the following error message:

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'taxonomy_theme_nodetype|casetracker_basic_projec' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('taxonomy_theme_nodetype|casetracker_basic_project', 's:9:\\"THEMENAMEWASHERE\\";') in /web/docs/drupal/includes/database.mysql.inc on line 172.', 2, '', 'http://mydomain.com/admin/build/modules/list/confirm', 'http://mydomain.com/admin/build/modules', '76.102.55.998', 1183334652) in /web/docs/drupal/includes/database.mysql.inc on line 172

The only things I changed in the above error message was:

the theme name (although it has done this with every theme I've used);

the IP address (which seemed to be my router's client IP address -- I'm on a wireless router with a randomly assigned by my cable internet provider, and it was a real public IP address, not a internal, router-generated one);

I changed my site's actual domain name to mydomain.com

Anyway, this happens every time, but everytime, the module is enabled. What do I fix, upgrade, or otherwise change so I don't always get this message?

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

The only way to fix that error is to insure your MySQL DB has LOCK permissions allowed. If on a shared hosting platform, you must ask the host to enable if you don't have the ability to do so yourself in your hosts DB admin panel.

as per the system requirements: http://drupal.org/requirements

NOTE: Drupal makes use of some features not available on some inexpensive hosting plans so please check that your host allows database accounts with the following rights:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES

somatics’s picture

somatics commented

Thanks for your reply. We actually operate our own server, and so I had already enabled all rights you list above for the database user set up for our drupal site. Any other reason we are getting this error message?