Two possibly related issues, Old Emails not displaying and Mail Scanner not importing
We have upgraded from v6.5 to v7.0.1 and then applied patches to fix bugs that have been reported elsewhere.
Old Emails not displaying: When looking at any contact/organisation record no emails are displayed. However if you create a new email, or import one with MailManager then it displays properly.
MailScanner not importing: If I run mail scanner manually, I get the following error:
Record you are trying to access can not be found
On turning on debugging - I found the following error - which seems to be related to the vtiger_contacts_user_field
table not being included in the JOIN. (No idea if this is related).
Wed Aug 30 14:12:10 2017,868 [14156] INFO VT - PearDatabase ->ADODB error Query Failed:SELECT vtiger_contactdetails.salutation AS vtiger_contactdetailssalutationtype,vtiger_contactdetails.firstname AS vtiger_contactdetailsfirstname,vtiger_contactdetails.contact_no AS vtiger_contactdetailscontact_no,vtiger_contactdetails.phone AS vtiger_contactdetailsphone,vtiger_contactdetails.lastname AS vtiger_contactdetailslastname,vtiger_contactdetails.mobile AS vtiger_contactdetailsmobile,vtiger_contactdetails.accountid AS vtiger_contactdetailsaccount_id,vtiger_contactsubdetails.homephone AS vtiger_contactsubdetailshomephone,vtiger_contactsubdetails.leadsource AS vtiger_contactsubdetailsleadsource,vtiger_contactsubdetails.otherphone AS vtiger_contactsubdetailsotherphone,vtiger_contactdetails.title AS vtiger_contactdetailstitle,vtiger_contactdetails.fax AS vtiger_contactdetailsfax,vtiger_contactdetails.department AS vtiger_contactdetailsdepartment,vtiger_contactsubdetails.birthday AS vtiger_contactsubdetailsbirthday,vtiger_contactdetails.email AS vtiger_contactdetailsemail,vtiger_contactdetails.reportsto AS vtiger_contactdetailscontact_id,vtiger_contactsubdetails.assistant AS vtiger_contactsubdetailsassistant,vtiger_contactdetails.secondaryemail AS vtiger_contactdetailssecondaryemail,vtiger_contactsubdetails.assistantphone AS vtiger_contactsubdetailsassistantphone,vtiger_contactdetails.donotcall AS vtiger_contactdetailsdonotcall,vtiger_contactdetails.emailoptout AS vtiger_contactdetailsemailoptout,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_contactdetails.reference AS vtiger_contactdetailsreference,vtiger_contactdetails.notify_owner AS vtiger_contactdetailsnotify_owner,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_customerdetails.portal AS vtiger_customerdetailsportal,vtiger_customerdetails.support_start_date AS vtiger_customerdetailssupport_start_date,vtiger_customerdetails.support_end_date AS vtiger_customerdetailssupport_end_date,vtiger_contactaddress.mailingstreet AS vtiger_contactaddressmailingstreet,vtiger_contactaddress.otherstreet AS vtiger_contactaddressotherstreet,vtiger_contactaddress.mailingcity AS vtiger_contactaddressmailingcity,vtiger_contactaddress.othercity AS vtiger_contactaddressothercity,vtiger_contactaddress.mailingstate AS vtiger_contactaddressmailingstate,vtiger_contactaddress.otherstate AS vtiger_contactaddressotherstate,vtiger_contactaddress.mailingzip AS vtiger_contactaddressmailingzip,vtiger_contactaddress.otherzip AS vtiger_contactaddressotherzip,vtiger_contactaddress.mailingcountry AS vtiger_contactaddressmailingcountry,vtiger_contactaddress.othercountry AS vtiger_contactaddressothercountry,vtiger_contactaddress.mailingpobox AS vtiger_contactaddressmailingpobox,vtiger_contactaddress.otherpobox AS vtiger_contactaddressotherpobox,vtiger_contactdetails.imagename AS vtiger_contactdetailsimagename,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_contactdetails.isconvertedfromlead AS vtiger_contactdetailsisconvertedfromlead,vtiger_contactscf.cf_777 AS vtiger_contactscfcf_777,vtiger_contactscf.cf_779 AS vtiger_contactscfcf_779,vtiger_contactscf.cf_799 AS vtiger_contactscfcf_799,vtiger_contactscf.cf_801 AS vtiger_contactscfcf_801,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_contacts_user_field.starred AS vtiger_contacts_user_fieldstarred,vtiger_contactdetails.tags AS vtiger_contactdetailstags,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_contactdetails ON (vtiger_contactdetails.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactaddress ON (vtiger_contactaddress.contactaddressid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactsubdetails ON (vtiger_contactsubdetails.contactsubscriptionid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactscf ON (vtiger_contactscf.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_customerdetails ON (vtiger_customerdetails.customerid = vtiger_crmentity.crmid ) WHERE vtiger_crmentity.crmid=? LIMIT 1
::->[1054]Unknown column 'vtiger_contacts_user_field.starred' in 'field list'
When MailScanner runs on a schedule it never completes.
Any help would be much appreciated. Liam