SQL problem in Wamp 1.6.0
Posted by: Omar (201.226.44.---)
Date: December 26, 2005 01:59AM

Hello, I am Yamir from Panama. I'm using the wamp 1.4.4 and all is working fine. But I updated to 1.6.0 and have the following trouble:

Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM mos_hp_properties AS p, mos_hp_companies AS c\n LEFT JOIN mos_hp_agents AS a ON p.agent = a.id\n LEFT JOIN mos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN mos_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nAND p.featured=\'1\'\nORDER BY f.ordering ASC\nLIMIT 0, 3

Warning: Invalid argument supplied for foreach() in c:\wamp\www\real\components\com_hotproperty\functions.hotproperty.php on line 80

I desinstaled this, and come back to wamp 1.4.4 and is working fine again.
Please help me.


Sorry, only registered users may post in this forum.