Warning: Table 'watchdog' was not locked with LOCK TABLES query

dtabach - September 12, 2006 - 23:20
Project:Drupal
Version:5.7
Component:other
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

The message above appears when I try to save configuration in administer » settings » content types.

The content type is a cck.

Also this message appears when I go back to the settings page:

user warning: Duplicate entry 'usernodes_proflink_content_ficha_de_empregoestgi' for key 1 query: INSERT INTO variable (name, value) VALUES ('usernodes_proflink_content_ficha_de_empregoestgio', 'i:0;') in /home/dtabach/public_html/includes/database.mysql.inc on line 120.

#1

jarea - September 15, 2006 - 18:23

This may belong under CCK - I got the same message when trying to update settings>content types for a CCK module

#2

jarea - September 15, 2006 - 18:35

See http://drupal.org/node/76828

Changing the length of the variable name field fixed the problem in my case.

#3

dtabach - September 25, 2006 - 15:59
Status:active» fixed

Fixed, thanks jarea.

I hope this change in vairbales do not cause other problems.

#4

Anonymous - October 9, 2006 - 16:01
Status:fixed» closed

#5

fxarte - May 20, 2008 - 21:05
Project:» Drupal
Version:4.7.x-1.x-dev» 5.7
Component:Code» other

The same just happened to me when cloning a view. (drupal 5.7, views 5.x-1.6)

#6

esmailzadeh - May 27, 2008 - 08:57

when i install webform i see this error:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 206813 bytes) in D:\moh\xampplite\htdocs\newd5\includes\database.mysql.inc on line 380

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', 'Table 'sessions' was not locked with LOCK TABLES\nquery: SELECT sid FROM sessions WHERE sid = '3124c9510930bced5b65b7da85ed04ec' in D:\\moh\\xampplite\\htdocs\\newd5\\includes\\database.mysql.inc on line 172.', 2, '', 'http://localhost/newd5/en/admin/build/modules/list/confirm', 'http://localhost/newd5/en/admin/build/modules', '127.0.0.1', 1211881987) in D:\moh\xampplite\htdocs\newd5\includes\database.mysql.inc on line 172

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', 'Table 'sessions' was not locked with LOCK TABLES\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('3124c9510930bced5b65b7da85ed04ec', 1, 0, '127.0.0.1', 'language|s:2:\\"en\\";FCKeditor|a:2:{s:13:\\"UserFilesPath\\";s:0:\\"\\";s:21:\\"UserFilesAbsolutePath\\";s:0:\\"\\";}imcetotal|i:42590;form|a:19:{s:32:\\"d71a6a9b863e8fd64fa3b41df7224445\\";a:2:{s:9:\\"timestamp\\";i:1211801873;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\&quot in D:\moh\xampplite\htdocs\newd5\includes\database.mysql.inc on line 172

 
 

Drupal is a registered trademark of Dries Buytaert.