I’m getting this error when I try to update a customer’s record.
“Database failure. Please refer to suitecrm.log for details.”
I have tried to use the Quick Repair and Rebuild as mentioned by many others with this same error but that did not work.
Below is the exact error that is causing this. Can someone please look at the error and see if you can decipher what is causing the error. It seems to be a “unknown column” but I’m not sure which one and where to look.
Mon Jan 30 17:28:26 2017 [8553][ab2aa622-e3e3-0fbf-92f9-55c9a290adf8][FATAL] Error updating table: contacts: Query Failed: UPDATE contacts
SET date_modified=‘2017-01-30 17:28:26’,modified_user_id=‘ab2aa622-e3e3-0fbf-92f9-55c9a290adf8’,created_by=‘ab2aa622-e3e3-0fbf-92f9-55c9a290adf8’,description=‘Zero\r\n’,assigned_user_id=‘ab2aa622-e3e3-0fbf-92f9-55c9a290adf8’,salutation=NULL,first_name=‘Joe’,last_name=‘Campos’,title=NULL,photo=NULL,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=‘818-383-4126’,phone_work=NULL,phone_other=NULL,phone_fax=NULL,primary_address_street=‘12262 Newgard Ave’,primary_address_city=‘Sylmar’,primary_address_state=‘CA’,primary_address_postalcode=‘91342’,primary_address_country=‘USA’,alt_address_street=‘12262 Newgard Ave’,alt_address_city=‘Sylmar’,alt_address_state=‘CA’,alt_address_postalcode=‘91342’,alt_address_country=‘USA’,assistant=NULL,assistant_phone=NULL,lead_source=NULL,reports_to_id=’’,birthdate=NULL,campaign_id=’’,joomla_account_id=NULL,portal_account_disabled=0,portal_user_type=‘Single’,``=NULL
WHERE contacts.id = ‘1a547922-55ea-dcf6-f896-588f733788ee’ AND deleted=0: MySQL error 1054: Unknown column ‘’ in ‘field list’