Zucker reports not working after upgrade

[Ali Akbar]

I have upgraded from SugarCRM 5.2.0h to 5.5.0, the reports are not working.
I am using Zucker reports
Do any one know the fix???????

[salesagility]

What error messages are you getting?

[Ali Akbar]

I am getting the following error

Error retrieving ListingTemplate list: Query Failed: SELECT zucker_listingtemplates.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name modified_user_name , jt2.created_by modified_user_name_owner , 'Users' modified_user_name_mod , jt3.user_name modified_by_name , jt3.created_by modified_by_name_owner , 'Users' modified_by_name_mod FROM zucker_listingtemplates LEFT JOIN users jt0 ON jt0.id= zucker_reporttemplate.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= zucker_reporttemplate.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= zucker_listingtemplate.modified_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt3 ON jt3.id= zucker_listingtemplate.modified_user_id AND jt3.deleted=0 AND jt3.deleted=0 where zucker_listingtemplates.deleted=0 ORDER BY zucker_listingtemplates.name LIMIT 0,1000::MySQL error 1054: Unknown column 'zucker_reporttemplate.assigned_user_id' in 'on clause'

[marco.disco]

This may help: http://www.sugarcrm.com/forums/showthread.php?t=58617