MySQL error 1054: Unknown column 'accounts_cstm.id_c'

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

My suiteCRM keeps crashing out. I’ve checked the sugarcrm.log file and it appears to repeatedly have this error:
Query Failed:
SELECT accounts.id , accounts.name , accounts.website , accounts.phone_office , accounts.billing_address_country , accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = 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?

Thanks

#2

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.

Thanks,

Will.

1 Like
#3

Thanks Will, that sorted it