error after creation of CCK filefield with path, on save of field.

core version 5.12

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', '<em>Duplicate entry &amp;#039;filefield_paths_photos_field_picture_file_file_n&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;filefield_paths_photos_field_picture_file_file_name_tolower&amp;#039;, &amp;#039;i:0;&amp;#039;)</em> in <em>/opt/lampp/htdocs/joescopy/drupal/includes/database.mysql.inc</em> on line <em>174</em>.', 2, '', 'http://192.168.2.232/joescopy/drupal/admin/content/types/photos/fields/field_picture_file', 'http://192.168.2.232/joescopy/drupal/admin/content/types/photos/fields/field_picture_file', '192.168.2.7', 1225227866) in /opt/lampp/htdocs/joescopy/drupal/includes/database.mysql.inc on line 174

Comments

deciphered’s picture

Status: Active » Closed (duplicate)

This is a duplicate of #322554: Editing FileField properties.

The issue is the variable name is being truncated.
I will look into shortening the variables so the problem lessens.