We have CRM Logs.


Unknown column 'outbound_email.preferred_sending_account' in 'field list'
Wed Jan 25 18:08:02 2023 [29369][1][FATAL] An exception occurred while executing 'SELECT outbound_email.id, outbound_email.eapm_id, outbound_email.name, outbound_email.type, outbound_email.user_id,
outbound_email.email_address_id, outbound_email.authorized_account, outbound_email.mail_authtype, outbound_email.reply_to_name, outbound_email.reply_to_email_address_id, outbound_email.mail_sendtype, outbound_email.mail_smtptype,
outbound_email.mail_smtpserver, outbound_email.mail_smtpport, outbound_email.mail_smtpuser, outbound_email.mail_smtppass, outbound_email.mail_smtpauth_req, outbound_email.mail_smtpssl, outbound_email.preferred_sending_account, outbound_email.deleted,
outbound_email.team_id, outbound_email.team_set_id, outbound_email.acl_team_set_id, teams_tn.name tn_name, teams_tn.name_2 tn_name_2, case when jt0_favorite_link.id IS NOT NULL then 1 else 0 end my_favorite FROM outbound_email LEFT JOIN teams teams_tn ON
(outbound_email.team_id = teams_tn.id) AND (teams_tn.deleted = ?) LEFT JOIN sugarfavorites outboundemail_favorite ON (outbound_email.id = outboundemail_favorite.record_id) AND (outboundemail_favorite.deleted = ?) AND (outboundemail_favorite.module = ?) AND
(outboundemail_favorite.created_by = ?) LEFT JOIN users jt0_favorite_link ON (jt0_favorite_link.id = outboundemail_favorite.modified_user_id) AND (jt0_favorite_link.deleted = ?) WHERE (outbound_email.id = ?) AND (outbound_email.deleted = ?) LIMIT 1'
with params [0, "0", "OutboundEmail", "1", 0, "a93c9252-b1ca-11e9-85f8-02a401d5b724", 0]:


Thanks

Hi Manish kumar,

The outbound_email database table had some schema updates when upgrading from version 11 to 12. With the above error indicating the preferred_sending_account column is not present, this is a symptom that schema updates in the upgrade did not complete. I recommend checking your upgrade log files to see if there were any errors encountered that may have resulted in the SQL updates from being run. If you cannot find anything in the upgrade log files, I recommend restoring the original version and attempting the upgrade to 12.0.2 via silent upgrade as James Banbury advised.

Chris

Hello Manish kumar

Could this be linked to this problem : 

https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/5604/error-during-upgrade-11-0-3-to-12

Perhaps you have to convert from pro to ent, then migrate to V12.

By the way, V12 is the worst upgrade I ever did, a lot of problem ... this is verry annoying.

Best regards,

Enes

My Current Version is Ent so need to convert it ?

My Current Version is Ent so need to convert it ?

If the current version is ENT, then no need to run the conversion package.

Yes But  getting 500 Error