I added a content type, filefield, flashfield. Then I added a new content type, added the EXISTING filefield & flashfield, and got the following error:
user warning: Unknown column 'field_flash_filefield' in 'field list' query: UPDATE content_type_page SET field_flash_filefield = 'field_flash_file' in /var/www/bigfix/sites/default/modules/flashfield/flashfield.widget.inc on line 257.

Comments

aimevp’s picture

aimevp
Primary language Dutch
Location Belgium
commented

I have this too.
Apparently the update query doesn't take the table prefix in consideration...
I have for example "d6_" as a prefix to my tables.

Edit:

I just remembered I saw that same kind of error in the Filefield module. (see #402912: SQL Error generated by update 6101 on upgrade)
They had a patch for it. I looked at the code, compared it with the one in Flashfield and it seems the solution is the same for both.

On line 254 you have this line of code:

db_query("UPDATE {$table_name} SET $field_name = '%s'", $new_field_name);

I changed it to:

db_query("UPDATE {" . $table_name . "} SET $field_name = '%s'", $new_field_name);

and the error is gone...
However, maybe it's adviced to check if this is wright, i'm not an experienced drupal developer (yet :-p)

Grtzzz,
Hatznie