Can anyone provide any more details on the fix identified above for a MySQL5 setup ?
My german isn't too good - and the query near line 370 in my estateagent.php file reads like this:

// get entries for each subcategory
$sc_entries=array();$parent=array();$y=0;
foreach($scats as $s){
$query = "SELECT count(*) FROM #__estateagent"
"\n WHERE cat = $s->id" "\n AND ("
"\n ((publish_up >= '0000-00-00' AND publish_up <= '$today' AND publish_down >= '$today'"
"\n OR ((publish_up >= '0000-00-00' AND publish_up <= '$today' ) AND (publish_down = '0000-00-00' OR publish_down >= '$today')"
"\n OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00'"
"\n )"
"\n AND access <= $gid AND publish=1";

Many Thanks.

OK - managed to work through it.
As it no doubt says in the previous post....

- there are 2 similarly named files in different directories - make sure you find the right one.... "...\<yourwebsite>\administrator\components\com_estateagent\admin.estateagent.html.php"

- then change the SQL as in previous post
from : " LEFT JOIN #__groups AS g ON g.id = o.access"
to : " LEFT JOIN #__groups AS g ON g.id = access"

Hi,

here's a solution for all those, who are running EA 1.0.x with mySQL 5 and have problems.

HowTo:

Download the attached zip file to your local harddisk. Then unzip and upload admin.estateagent.php into $root/administrator/components/com_estateagent/ on your webspace and overwrite the old one with it.

That's all. Now you should be able to see your estate objects overview at the admin backend.

Hi,

I've been searching the forum and could not get help. The search page opens with an errormessage:

Fatal error: Call to undefined method EAObject:arseshortinfo() in /home/mbrunner/public_html/components/com_estateagent/estateagent.html.php on line 1662

Furthermore it's shown without the template.

Can anyone help?

site: www.limabrunner.pt

Tx,
Marco