error Unknown column accounts_cstm.user_id_c

💬 General Discussion
1

I am trying to use the export template for the accounts module but when I do it get the error stated in the subject line. At first I thought that a quick repair and rebuild would resolve the issue but it did not. So I took a peek at the database and sure enough there is no field called user_id_c however there is a field called id_c. but not user_id_c. The following is the error that I receive

04/18/16 12:40:00 [15692][1][FATAL] Error exporting Accounts: <BR>.SELECT
                                accounts.*,
                                email_addresses.email_address email_address,
                                '' email_addresses_non_primary, accounts.name as account_name,
                                users.user_name as assigned_user_name , accounts_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) account_manager_c  FROM accounts LEFT JOIN users
	                                ON accounts.assigned_user_id=users.id  LEFT JOIN  email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1  LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c  LEFT JOIN users relJoin1 ON accounts_cstm.user_id_c = relJoin1.id AND relJoin1.deleted=0 where ( accounts.deleted IS NULL OR accounts.deleted=0 ) Query Failed: SELECT
                                accounts.*,
                                email_addresses.email_address email_address,
                                '' email_addresses_non_primary, accounts.name as account_name,
                                users.user_name as assigned_user_name , accounts_cstm.user_id_c, LTRIM(RTRIM(CONCAT(IFNULL(relJoin1.first_name,''),' ',IFNULL(relJoin1.last_name,'')))) account_manager_c  FROM accounts LEFT JOIN users
	                                ON accounts.assigned_user_id=users.id  LEFT JOIN  email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1  LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c  LEFT JOIN users relJoin1 ON accounts_cstm.user_id_c = relJoin1.id AND relJoin1.deleted=0 where ( accounts.deleted IS NULL OR accounts.deleted=0 ) LIMIT 0,5: MySQL error 1054: Unknown column 'accounts_cstm.user_id_c' in 'field list'

anyone encountered this before.
Background: This is happening on the migrated version however, I have a full version installed on my server as well and it does not have this issue. has anyone had this same issue an if so how was it resolved?

2

Hi,
make a quick repaire rebuild, go to bottom and see if a SQL must be run for update database
check in the database - table metadata if there is a field like that.
check in all file for that word “user_id_c”

3

I ran the repair rebuild and there was no SQL that needed to be run. I checked the database and in the table accounts_cstm there is no field called ‘user_id_c’ however there is a field called ‘id_c’