I've got FileField, FileField Paths, and Transliteration installed on my Drupal 5.7 system.

I've created a FileField on a node type and submitted its settings. Then, I clicked "modify" to edit the settings again, changed FileFiled Paths values and clicked "Submit". A PHP error message appeared:

user warning: Duplicate entry 'filefield_paths_article_field_attachments_file_p' for key 1 query: INSERT INTO variable (name, value) VALUES ('filefield_paths_article_field_attachments_file_path_transliterate', 'i:0;') in /home/Altaisoft/site/ongnet/www/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'filefield_paths_article_field_attachments_file_n' for key 1 query: INSERT INTO variable (name, value) VALUES ('filefield_paths_article_field_attachments_file_name_tolower', 'i:1;') in /home/Altaisoft/site/ongnet/www/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'filefield_paths_article_field_attachments_file_n' for key 1 query: INSERT INTO variable (name, value) VALUES ('filefield_paths_article_field_attachments_file_name_transliterate', 'i:1;') in /home/Altaisoft/site/ongnet/www/includes/database.mysql.inc on line 172.

The settings weren't submitted.

I removed the listed rows from the database table 'variable', but with no result.

Comments

criznach’s picture

criznach commented

Your variable names are getting truncated so they step on each other. Your field names are too long. This is a common problem for modules that store CCK-related settings in the variables table. You can shorten your field names (preferred), or you can alter the length of the 'name' column in the variables table.

deciphered’s picture

deciphered
Primary language English
Location Ballarat, Victoria, Australia
commented

Looking into shortening the variables so that this issue can be prevented.

deciphered’s picture

deciphered
Primary language English
Location Ballarat, Victoria, Australia
commented
Status: Active » Closed (fixed)

This has been fixed in the latest Dev build, however as your old fields where stored incorrectly in the first place I would recommend a re-install instead of an upgrade.