Error occurs on viewing CiviMail queue.

When viewing civicrm/mailing/queue:

CiviMail

unrecoverable error
Sorry. A non-recoverable error has occurred.

Database Error Code: Unknown column 'civicrm_contact.id' in 'field list', 1054

Return to CiviCRM menu.

error

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => INSERT IGNORE INTO I_1 (email_id, contact_id)
SELECT DISTINCT civicrm_email.id as email_id,
civicrm_contact.id as contact_id
FROM civicrm_contact contact_a LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
contact_a.id = civicrm_location.entity_id AND civicrm_location.is_primary = 1) LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT JOIN X_1
ON civicrm_contact.id = X_1.contact_id
WHERE
civicrm_contact.do_not_email = 0
AND civicrm_contact.is_opt_out = 0
AND civicrm_location.is_primary = 1
AND civicrm_email.is_primary = 1
AND civicrm_email.on_hold = 0

AND X_1.contact_id IS null [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'field list']
[type] => DB_Error
[user_info] => INSERT IGNORE INTO I_1 (email_id, contact_id)
SELECT DISTINCT civicrm_email.id as email_id,
civicrm_contact.id as contact_id
FROM civicrm_contact contact_a LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
contact_a.id = civicrm_location.entity_id AND civicrm_location.is_primary = 1) LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT JOIN X_1
ON civicrm_contact.id = X_1.contact_id
WHERE
civicrm_contact.do_not_email = 0
AND civicrm_contact.is_opt_out = 0
AND civicrm_location.is_primary = 1
AND civicrm_email.is_primary = 1
AND civicrm_email.on_hold = 0

AND X_1.contact_id IS null [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO I_1 (email_id, contact_id)
SELECT DISTINCT civicrm_email.id as email_id,
civicrm_contact.id as contact_id
FROM civicrm_contact contact_a LEFT JOIN civicrm_location ON (civicrm_location.entity_table = 'civicrm_contact' AND
contact_a.id = civicrm_location.entity_id AND civicrm_location.is_primary = 1) LEFT JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT JOIN X_1
ON civicrm_contact.id = X_1.contact_id
WHERE
civicrm_contact.do_not_email = 0
AND civicrm_contact.is_opt_out = 0
AND civicrm_location.is_primary = 1
AND civicrm_email.is_primary = 1
AND civicrm_email.on_hold = 0

AND X_1.contact_id IS null [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'field list']"]
)

Robin