I obtain different results from QuickSearch and from AdvancedSearch.

In QuickSearch, with "rental from 700", the SQL statement is:

cpp-qt:

 
      SELECT id
        FROM jos_misterestate
        WHERE rent >= 700
        AND  ((publish_up = "0000-00-00" OR publish_up <= "2009-11-16")
        AND (publish_down >= "2009-11-16" OR publish_down = "0000-00-00"))
        AND access<=25
        AND verified=1
        AND publish=1
 

And from Advanced search, the same operation produces this SQL statement:

cpp-qt:

 
SELECT id
        FROM jos_misterestate
        WHERE  ((publish_up = "0000-00-00" OR publish_up <= "2009-11-16")
        AND (publish_down >= "2009-11-16" OR publish_down = "0000-00-00"))
        AND access<=25
        AND verified=1
        AND publish=1
 

where is the "WHERE rent >= 700" ?

up !

up again !

Please, a solution. Or a message saying, for example, that admin is solving the problem or the bug...
Feedback, please.

This is like Lamentations Wall !!!

Hi,

which ME version are you using?

In ME 1.6.1 I can´t reproduce your statement above. Extended search works like it should.

best regards

Version is ME 1.6.1.
I have made another installation in other hosting. Please, go to:
http://www.fmedrano.es/Inmobiliaria

I have 2 categories (ALQUILERES and VENTAS) and each one with 4 subcategories.

I have registered one property in ALQUILERES - Pisos.
This property have a rental of 750 EUR.

On the QuickSearch module (on the left), please, in "Alquiler de" field introduce "700" and press "Empezar Busqueda" button.
You can see the SQL statements because I have "Debug mode" ON. Ant the SQL statement is:

Code:

SELECT id 
  FROM jos_misterestate 
  WHERE rent >= 700 
  AND  ((publish_up = "0000-00-00" OR publish_up <= "2009-11-30") 
  AND (publish_down >= "2009-11-30" OR publish_down = "0000-00-00")) 
  AND access<=25 
  AND verified=1 
  AND publish=1
SELECT * 
  FROM jos_misterestate 
  WHERE rent >= 700 
  AND  ((publish_up = '0000-00-00' OR publish_up <= '2009-11-30') 
  AND (publish_down >= '2009-11-30' OR publish_down = '0000-00-00')) 
  AND access<=25 
  AND verified=1 
  AND publish=1 
  LIMIT 0, 25

Then, press the "Busqueda avanzada" link or go to here: http://www.fmedrano.es/Inmobiliaria/index.php?option=com_misterestate&view=search&Itemid=2
In "Busqueda Avanzada" (Advanced Search), in "alquiler de" type "700" EUR. And then, press "Empezar Busqueda" at the bottom of the page. In this case, the SQL statement is:

Code:

SELECT id 
  FROM jos_misterestate 
  WHERE  ((publish_up = "0000-00-00" OR publish_up <= "2009-11-30") 
  AND (publish_down >= "2009-11-30" OR publish_down = "0000-00-00")) 
  AND access<=25 
  AND verified=1 
  AND publish=1
SELECT * 
  FROM jos_misterestate 
  WHERE  ((publish_up = '0000-00-00' OR publish_up <= '2009-11-30') 
  AND (publish_down >= '2009-11-30' OR publish_down = '0000-00-00')) 
  AND access<=25 
  AND verified=1 
  AND publish=1 
  LIMIT 0, 25

As you can see, the differences between SQL statements are the "rent >= 700". This expression does not appear in the WHERE section of the "Busqueda Avanzada" (Advanced Search).

what's happening?
Thanks. Please, reply me as soon as possible.

Hi,

as I wrote before:

Zitat:

In ME 1.6.1 extended search works like it should.

I can´t reproduce your problem. The sql-statement contains the rent part always, no matter if I try it with quicksearch or advanced search.

best regards

admin:

Hi,

as I wrote before:

Zitat:

In ME 1.6.1 extended search works like it should.

I can´t reproduce your problem. The sql-statement contains the rent part always, no matter if I try it with quicksearch or advanced search.

best regards

Did you try this in my web? http://www.fmedrano.es/Inmobiliaria

I am in debug mode... you can see the SQL statements....
In the "Advanced Search" the "WHERE" expression have not the "rent >= 700".
But if you execute from "Quick Search", appears the "rent >= 700" expression in WHERE section.

Don't you see that in my web? ---->>> http://www.fmedrano.es/Inmobiliaria

The "Advanced Search" is in the "Advanced Search" item menu. Now the Advanced Search is the home page.

I attach you a screenshot.
Try tu put 700 in "Alquiler de-a" field. One result.
Then, try tu put 1800 in the same field. One result again. But the rent of this property is 750 EUR !!!

P.S.: Quick Search is ok. But Advanced Search is wrong.

Thanks.

Please, something about this problem ?

I already know what is happening !!
The problem is with the "solar_sentinel" Template.
If I configure the rhuk_milkyway Template, the Advanced Search works right.

I think the problem is relation with the JavaScript. how can I resolve it? (using solarsentinel Template)
Thanks.

Hi,

thanks for this hint.

I don´t know the javascript sources of this template.
Could you try to locate the javascript which causes the problem?

best regards

admin:

Hi,

thanks for this hint.

I don´t know the javascript sources of this template.
Could you try to locate the javascript which causes the problem?

best regards

How could I locate the javascript which causes the problem?

I have made an attempt with other templates:
- Beez: works right.
- JA_Helio: works wrong
- JA_purity: works wrong
- rhuk_milkyway: works rigth
- rt_solarsentinelj15: works wrong


If you want to make some test on my web: http://www.aycachorro.com/jr/pruebas/Inmobiliaria

If you need the admin password to change the template.... please, tell me ( jrariasf@gmail.com )

Edit:
See also this thread where another user wrote a similar problem:
http://www.misterestate.com/meforum/message/2155.html

I have disabled the QuickSearch module and then Extended Seach works rigth.

With all this data, Darko, could you resolve the bug?
Thank you.