error in subpanel display

[atik]

hi all,

i m using sugarcrm 5.1 and i m new in sugar so help me to solve this prob..
i m getting error in d subpanel display in error is:
Error retrieving Account list: Query Failed: SELECT contracts.id , contracts.name , contracts.type , contracts.status , contracts.expiry_date , jt0.user_name assigned_user_name, contracts.assigned_user_id , 'contracts' panel_name FROM contracts AND jt0.deleted=0 where ( contracts.account_id= '2a042447-6750-8c1b-a24f-4896347eb481' AND contracts.deleted=0) AND contracts.deleted=0 ORDER BY contracts.id asc LIMIT 0,10::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 jt0.deleted=0 where ( contracts.account_id= '2a042447-6750-8c1b-a24f-4896347' at line 1

i check my sugarbean.php file but confused so anyone tell me how to solve this problem..

thank you

[daniel.passarini]

Hi Atik

The string "AND jt0.deleted=0" is in the wrong place.
Can you clarify how did you install/configure/customize your SugarCRM installation?

[atik]

Thanks for reply..
i just follow wizard and do the installation.. please dont mind if i m not getting what r u saying
please tell me how to remove this error.

i need to configure my sugar again or repair it ???