Reference field: Switching from multifield to singlefield

Ever had message like this?

If you are getting error like this

user warning: Unknown column 'node_data_field_gallery_ref.delta' in 'on clause' query: SELECT node.nid AS nid, node_node_data_field_gallery_ref.type AS node_node_data_field_gallery_ref_type, node_node_data_field_gallery_ref.nid AS node_node_data_field_gallery_ref_nid, node_node_data_field_gallery_ref.vid AS node_node_data_field_gallery_ref_vid, RAND() AS _random FROM node node LEFT JOIN content_type_destination node_data_field_gallery_ref ON node.vid = node_data_field_gallery_ref.vid AND node_data_field_gallery_ref.delta = 0 INNER JOIN node node_node_data_field_gallery_ref ON node_data_field_gallery_ref.field_gallery_ref_nid = node_node_data_field_gallery_ref.nid WHERE (node.type in ('destination')) AND (node_node_data_field_gallery_ref.status <> 0) AND (node_node_data_field_gallery_ref.promote <> 0) ORDER BY _random ASC LIMIT 0, 4 in /srv/www/travelnut.me/public_html/sites/all/modules/views/includes/view.inc on line 771.

And you switched your node reference field from having one field to three fields or vice versa, you could get this error. This is comming from your views where you need to recreate your relationship(s) so that errors is not present anymore.