When saving the settings of a filefield in 'Manage fields' / Configure, I get the following error:

user warning: Column count doesn't match value count at row 1 query: INSERT INTO filefield_paths (type, field, filename, filepath, filealias) VALUES (...) in filefield_paths/filefield_paths.module on line 281.

The following mini-patch seems to fix this here:

     db_query(
-      "INSERT INTO {filefield_paths} (type, field, filename, filepath, filealias) VALUES ('%s', '%s', '%s', '%s')",
+      "INSERT INTO {filefield_paths} (type, field, filename, filepath, filealias) VALUES ('%s', '%s', '%s', '%s', '%s')",
       $ffp['type'], $ffp['name'], serialize($settings['filename']), serialize($settings['filepath']), serialize($settings['filealias'])
     );

Comments

Docc’s picture

Confirmed. Both the bug and solution

deciphered’s picture

Status: Needs review » Reviewed & tested by the community

Yes, this has been a known issue for a ridiculous amount of time, but I haven't had any time to dedicate to module development.
Will push out fix tonight.

deciphered’s picture

Status: Reviewed & tested by the community » Fixed

Committed to HEAD

deciphered’s picture

Committed to DRUPAL-5

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.