MySQL error 1054: Unknown column 'accounts_cstm.id_c'

My suiteCRM keeps crashing out. I’ve checked the sugarcrm.log file and it appears to repeatedly have this error:
Query Failed:
SELECT , , , accounts.phone_office , accounts.billing_address_country , accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON = accounts_cstm.id_c where ((accounts.assigned_user_id = ‘d4e20c80-9709-46aa-ea55-5481a61c08c4’)) AND accounts.deleted=0 ORDER BY accounts.date_entered DESC LIMIT 0,6: MySQL error 1054: Unknown column ‘accounts_cstm.id_c’ in ‘on clause’

I’ve checked the accounts_cstm table in the mysql database and the id_c field is definitely there…any ideas?


Hi there,

Please navigate to Admin -> Repair. Execute a Quick Repair & Rebuild. Once this completes, scroll down and execute any changes shown.

If you still have issues, please let me know.



1 Like

Thanks Will, that sorted it