SubPanel Error

[k.almutairi]

Dear All
i install sugarCrm 5 and i install only Opensale module
and i get this SQL error in account Detail View
------------------------------
Error running count query for Account List: Query Failed SELECT count(*) c FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((taskscontacts.status='Not Started' OR taskscontacts.status='In Progress' OR taskscontacts.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((calls.status='Planned')) AND calls.deleted=0 )::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id A' at line 3
----------------------------------

any one can help me

thanks

[MatR]

Hello k.almutairi,

Have you repaired database and relationships into "Admin" ?