Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I am upgrading a site to a new domain and server. Drupal is going from 5.14 to 5.18. I forgot to upload the Imagefield module when I first updated the site, now it appears that all my image fields have been deleted.
user warning: Unknown column 'node_data_field_image.field_image_fid' in 'field list' query: SELECT node.nid, node.created AS node_created_created, node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node.title AS node_title, node.changed AS node_changed, node_data_field_teasertext.field_teasertext_value AS node_data_field_teasertext_field_teasertext_value, node_data_field_teasertext.field_teasertext_format AS node_data_field_teasertext_field_teasertext_format FROM node node LEFT JOIN content_field_teasertext node_data_field_teasertext ON node.vid = node_data_field_teasertext.vid WHERE (node.type IN ('article')) AND (node.promote = '1') ORDER BY node_created_created DESC LIMIT 0, 1 in /home/youthpts/public_html/includes/database.mysql.inc on line 174.
CCK 5.x-1.10
Imagefield 5.x-2.6
tmp and files permissions 777
download public
Comments
Comment #1
quicksketchDid you update CCK at the same time, or just from Drupal 5.14 to 5.18? If you've updated CCK and ImageField was not available at the time of the update, your database may be improperly updated and the only thing that you can do is restore a database backup, make sure all the modules are in place, then run update.php again.
If you didn't update CCK at the same time, the updates to core shouldn't make a difference to ImageField. Check the contents of your database and check that the table "node_data_field_image" exists. I believe CCK renamed these tables at some point to something like "content_field_image". So if you have some tables named "content_field_*" and some tables named "node_data_field_*", then your database has been mangled and you'll need to restore a back up like I described.
Comment #2
nancydruNo, I did not have to update CCK. Here are the tables I see:
content_field_image
content_field_kicker
content_field_medium_rectangle_ad
content_field_related
content_field_reviewer
content_field_rider
content_field_skyscraper_ad
content_field_sponsor
content_field_teasertext
content_field_teasertitle
content_type_ad
content_type_advpoll_binary
content_type_advpoll_ranking
content_type_alert
content_type_article
content_type_blog
content_type_convert
content_type_event
content_type_forum
content_type_mt_video
content_type_page
content_type_panel
content_type_photo
content_type_poll
content_type_story
content_type_tip
content_type_video
node_field
node_field_instance
node_group
node_group_fields
I am in the process of rebuilding the database.
Comment #3
quicksketchSo that's good news. It looks like your data is still intact (it's probably in "content_field_image"), but whatever is doing that SQL query just needs to be updated. Looks like a Views query to me.
Comment #4
nancydruSince this is a domain/server change, I will just rebuild the database and re-upgrade.
Comment #5
quicksketchGreat, I'll mark as fixed. Please reopen if you have further questions.