SQL Error generated by update 6101 on upgrade [#402912]

Upgrading to latest beta(1) and receive this error when executing update.php:
user warning: Table '[myDBname].content_field_mp3a' doesn't exist query: UPDATE content_field_mp3a SET field_mp3a_fid = NULL, field_mp3a_list = NULL WHERE field_mp3a_fid NOT IN (SELECT fid FROM d6_files) in [myDrupalRoot]/sites/all/modules/filefield/filefield.install on line 164.

Square bracket parms "[]" are where I've replaced actual name.

Bumped into similar issues with other modules where root cause is my demo site having a DB table prefix of "d6_". Another site has no DB table prefix and updated just fine. So queries like this have trouble:

The following queries were executed
filefield module
Update #6101

* Failed: UPDATE content_field_mp3a SET field_mp3a_fid = NULL, field_mp3a_list = NULL WHERE field_mp3a_fid NOT IN (SELECT fid FROM {files})

The update target table should be, in my case, "d6_content_field-mp3a".

I see the code: UPDATE {$table} SET that appears to have the curly braces. However the end product is not resolving to the correct table name.

Comment	File	Size	Author
#3	filefield_update_brackets.patch	834 bytes	quicksketch

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

quicksketch

he/him

CreditAttribution: quicksketch commented 15 March 2009 at 23:16

Oh, I bet I know why this is. PHP is resolving those brackets to the name of the variable. Could you try putting double brackets (UPDATE {{$table}} SET) in and rerunning update 6101? It's not going to hurt running the update multiple times.

Comment #2

wtopper CreditAttribution: wtopper commented 15 March 2009 at 23:40

Done. Results as expected:

The following queries were executed
filefield module
Update #6101

* UPDATE {content_field_mp3a} SET field_mp3a_fid = NULL, field_mp3a_list = NULL WHERE field_mp3a_fid NOT IN (SELECT fid FROM {files})

Worked like a charm.

Thanks, Mate!