Records Disappeared on Listview

[thamim]

Hi Everyone

I have a few custom modules on my instance of Sugar 5.5, some of the modules work without any problems but for some the records on listview disappeared. I checked the database, the records are there they are just not showing on listview. Initially I thought it was because of a saved search but its not as the records disappeared for all users.

What am I missing. Operating system is Ubuntu 10.04

[davidboris]

Hello,

I think the query seems to be failing for your module. Do echo in include/ListView/ListViewData.php $main_query on around line # 295 and execute the query directly in database.

[thamim]

Thank you,

You are right, my queries are failing because it cannot find a field called jt0.name. I have checked the database for such a table no luck. and I also search this ListViewData.php file thinking this might be a variable used in the code but nothing. I dont have a module called jt either. Is there a way to clear this error?

here is one of the queries that fail.

SELECT leavemanagement.id , jt0.name employeeinfo_leavemanagement_name, jtl0.employe5516yeeinfo_ida employe5516yeeinfo_ida, jt1.name leave_type , leavemanagement.no_of_days , leavemanagement.assigned_user_id FROM leavemanagement LEFT JOIN employeevemanagement_c jtl0 ON leavemanagement.id=jtl0.employe82d8agement_idb AND jtl0.deleted=0 LEFT JOIN employeeinfo jt0 ON jt0.id=jtl0.employe5516yeeinfo_ida AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN leave_types jt1 ON leavemanagement.leave_types_id_c = jt1.id AND jt1.deleted=0 where leavemanagement.deleted=0