Mysql error 1054, unknown column

[lmsservices]

I have modified the notes tab and the history subpanel to show the custom fields I need. All is well until I create a new note and then I get the error message below while trying to view the note in the history subpanel of accounts:

Error retrieving Account list: Query Failed SELECT tasks.id , jt0.name accountname_c , tasks.date_entered , tasks.created_by , ' ' filename , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN accounts jt0 ON tasks_cstm.account_id_c = jt0.id AND jt0.deleted=0 where ( tasks.parent_id= 'af5e70ea-ebd0-c510-8ec4-4a79dc472cbf' AND tasks.parent_type='Accounts' AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT meetings.id , jt0.name accountname_c , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_entered , meetings.created_by , ' ' filename , meetings.assigned_user_id , 'meetings' panel_name FROM meetings LEFT JOIN accounts jt0 ON meetings_cstm.account_id_c = jt0.id AND jt0.deleted=0 where ( meetings.parent_id= 'af5e70ea-ebd0-c510-8ec4-4a79dc472cbf' AND meetings.parent_type='Accounts' AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , jt0.name accountname_c , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_entered , calls.created_by , ' ' filename , calls.assigned_user_id , 'calls' panel_name FROM calls LEFT JOIN accounts jt0 ON calls_cstm.account_id_c = jt0.id AND jt0.deleted=0 where ( calls.parent_id= 'af5e70ea-ebd0-c510-8ec4-4a79dc472cbf' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , jt0.name accountname_c , notes.date_entered , notes.created_by , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.filename , 'notes' panel_name FROM notes LEFT JOIN accounts jt0 ON notes_cstm.account_id_c = jt0.id AND jt0.deleted=0 where ( notes.parent_id= 'af5e70ea-ebd0-c510-8ec4-4a79dc472cbf' AND notes.parent_type='Accounts' AND notes.deleted=0) AND notes.deleted=0 ) ORDER BY date_entered desc LIMIT 0,10::MySQL error 1054: Unknown column 'tasks_cstm.account_id_c' in 'on clause'

The field its refrencing has been deleted. I ran a search and onlyl the log file is showing that field name. I don't understand why I am still getting this error message.

any ideas?

[Angel]

Have you tried performing a rebuild/repair on your system via Admin > Repair?

[lmsservices]

I have tried the rebuld/repair. Same error message

[Angel]

Did you add fields to the tasks module at some point? Is the account_id_c field still listed as one of the custom fields for the Tasks module within studio?

[lmsservices]

I did add the field, but I have since deleted it. After I deleted I ran a rebuild/repair. Same Error message.

[Angel]

Ok, that's kind of what I suspected as this error usually comes up when someone has been adding/deleting fields.

Have you tried clearing the <sugar>/cache/modules/Tasks directory?

[lmsservices]

I tired that and then a rebuild/repair. same error. I'm racking my brain here. I don't know why it only gives this error message when a note is created and saved.

[Angel]

Check the fields_meta_data table to see if the field definition is still there. If it is, delete the correponsding record and then rebuild.

[lmsservices]

sorry. I'm not familiar with that. Can you guide me?

[lmsservices]

nevermind. I found the table in the db. working on it now.