Task Error on Contacts and Accounts

[matrixweb]

Hey, Everybody.
I´ve been worked with the "Sugar" during a long time, but i´ve never seen an error like this.
Well, every time I access the Accounts Module or Contacts Module it´s not listing the "Tasks" under.
This is in Edit listview.
The fields are showed normally, but the Tasks don´t.

If everyone can help me. It would be very nice.

Tks for you attention.

The error showed...:

Error retrieving Account list: Query Failed: ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name , tasks.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= '6bafe9ec-b9a4-13cd-b6ba-4a7c4c94622a' AND tasks.parent_type='Accounts' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.assigned_user_id , 'meetings' panel_name FROM meetings LEFT JOIN users jt0 ON jt0.id= meetings.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where ( meetings.parent_id= '6bafe9ec-b9a4-13cd-b6ba-4a7c4c94622a' AND meetings.parent_type='Accounts' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id , 'calls' panel_name FROM calls LEFT JOIN users jt0 ON jt0.id= calls.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where ( calls.parent_id= '6bafe9ec-b9a4-13cd-b6ba-4a7c4c94622a' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start desc LIMIT 0,10::MySQL error 1222: The used SELECT statements have a different number of columns

[andopes]

Probably you had modified either the history or activity subpanel for some of the Activities modules.
Explode this query and look for the query item containing a different number of columns.

Cheers