Random properties Module error

Hi,

I updated to 2.7.1 today. All was good until i update the Random properties Module. I now get this error on my home page where the module is loaded:

1054 - Unknown column 'a.pro_type' in 'where clause' SQL=SELECT p.*, s.state_name, c.country_name,ty.id as typeid, ty.type_name as type_name FROM rjm1_osrs_properties AS p INNER JOIN rjm1_osrs_types AS ty ON ty.id = p.pro_type LEFT JOIN rjm1_osrs_states AS s ON s.id = p.state INNER JOIN rjm1_osrs_countries AS c ON c.id = p.country INNER JOIN rjm1_osrs_agents as ag ON p.agent_id = ag.id WHERE p.published = '1' AND p.approved = '1' AND a.pro_type = 1 AND p.isFeatured = '1' AND p.pro_type = '1' ORDER BY p.created desc limit 6

Hi Richard,
I send you new version of Random Properties module. It will solve the issue you reported
Thanks
Dam