After upgrade from SugarCRM CE 6.5.x database error when saving contacts

Hello All,

On a cloned machine I am testing upgrading to SuiteCRM.

When I edit a contact I receive “Database failure. Please refer to sugarcrm.log for details.”

In the log I see:

‘8/13/15 17:43:21 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Missing relationship definition contact_aos_quotes. skipping contact_aos_quotes subpanel
08/13/15 17:43:21 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Missing relationship definition contact_aos_invoices. skipping contact_aos_invoices subpanel
08/13/15 17:43:21 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Missing relationship definition contact_aos_contracts. skipping contact_aos_contracts subpanel
08/13/15 17:43:21 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Missing relationship definition fp_events_contacts. skipping fp_events_contacts subpanel
08/13/15 17:43:21 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Missing relationship definition securitygroups_contacts. skipping securitygroups subpanel
08/13/15 17:46:49 [9280][8f8239b3-9279-b2da-eead-4f64ec132118][FATAL] Error updating table: contacts: Query Failed: UPDATE contacts
SET date_modified=‘2015-08-14 00:46:49’,modified_user_id=‘8f8239b3-9279-b2da-eead-4f64ec132118’,created_by=‘8f8239b3-9279-b2da-eead-4f64ec132118’,description=NULL,assigned_user_id=‘8f8239b3-9279-b2da-eead-4f64ec132118’,salutation=‘Ms.’,first_name=‘Teri’,last_name=‘Werner’,title=‘International Trainer, Coach, Key Note Speaker, Author’,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=NULL,phone_work=‘1’,phone_other=NULL,phone_fax=NULL,primary_address_street=NULL,primary_address_city=NULL,primary_address_state=‘TX’,primary_address_postalcode=NULL,primary_address_country=NULL,alt_address_street=NULL,alt_address_city=NULL,alt_address_state=NULL,alt_address_postalcode=NULL,alt_address_country=NULL,assistant=NULL,assistant_phone=NULL,lead_source=‘LinkedIn_search_sales_coaches’,reports_to_id=’’,birthdate=NULL,campaign_id=’’,joomla_account_id=NULL,portal_account_disabled=0,portal_user_type=‘Single’
WHERE contacts.id = ‘33e8e560-d727-e348-9447-55ccee777f13’ AND deleted=0: MySQL error 1054: Unknown column ‘joomla_account_id’ in ‘field list’

Any help would be appreciated.

~eric

Hi Eric,

It looks like the DB is missing some fields. Can you try running a Quick Repair and Rebuild from the admin section? It should prompt you to add these.

Thanks,
Jim

Thanks. That fixed it. I missed a step in the instructions.