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 |
Jump to:
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
This may belong under CCK - I got the same message when trying to update settings>content types for a CCK module
#2
See http://drupal.org/node/76828
Changing the length of the variable name field fixed the problem in my case.
#3
Fixed, thanks jarea.
I hope this change in vairbales do not cause other problems.
#4
#5
The same just happened to me when cloning a view. (drupal 5.7, views 5.x-1.6)
#6
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:\\" in D:\moh\xampplite\htdocs\newd5\includes\database.mysql.inc on line 172