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.

Comments

jarea’s picture

jarea commented

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

jarea’s picture

jarea commented

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

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

dtabach’s picture

dtabach commented
Status: Active » Fixed

Fixed, thanks jarea.

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

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
fxarte’s picture

fxarte commented
Project: » Drupal core
Version: » 5.7
Component: Code » other

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

esmailzadeh’s picture

esmailzadeh commented

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

WeRockYourWeb.com’s picture

WeRockYourWeb.com commented

I get the LOCK TABLES error as well in the latest Drupal 5.x when trying to add a webform component.

WeRockYourWeb.com’s picture

WeRockYourWeb.com commented

Completely uninstalling webform and re-installing it fixed the issue. I also increased the name varchar for the variable table from 128 to 255, but that was earlier and didn't seem to affect anything.