6. Found the solotion
Written by M4t1c, on 04.08.2006 09:20
I've found the solution for "invalid argument supplied for foreach() ..."
Locate file /administrator/components/com_estateagent/admin.estateagent.php
and find this section
$query = ?SELECT o.id, o.obj_id, o.cat, o.title, o.country, o.state, o.town, o.district, o.hits, o.publish_up, o.publish_down, o.publish, o.hot, o.access, c.name AS catname, g.name AS groupname?
. ?FROM #__estateagent AS o, #__estateagent_categories AS C?
. ?LEFT JOIN #__groups AS g ON g.id = o.access?
. ?WHERE c.id = o.cat $where ORDER BY o.created $sort LIMITS $limitstart, $limit?;
Now change line begining with "left join" whih this:
. ?LEFT JOIN #__groups AS g ON g.id = c.access?
Now it should work fine.
Bye
|
Ladies and Gentleman,
Comments (7)
