English Support Forum

icon
Avatar
jrariasf
Posts: 53
When doing an Advanced Search checking "Swimming Pool", does not return results.
In fact, if you activate traces (debug) in the backend ("Global Configuration" - System - debugging parameters - "purification system"), returns the following error:
"500 - JDatabaseMySQL::query: 1054 - Unknown column 'pool' in 'where clause' SQL=SELECT id FROM jos_misterestate WHERE pool='1' AND ((publish_up = "0000-00-00" OR publish_up <= "2010-01-06") AND (publish_down >= "2010-01-06" OR publish_down = "0000-00-00")) AND access<=0 AND verified=1 AND publish=1"

i.e., ME is trying to manage a field "pool" in jos_misterestate table which does not exist.
Looking at the database with phpMyAdmin I have seen that the column is actually called "swpool" (instead of "pool").

Solution:
I have changed in the file "components/com_misterestate/misterestate.php" the token "pool" to "swpool": (near line 823)
iconphp:
$ sp [11] = mosMEHTML:: checkbox ( "atb []", 'class = "inputbox"', 'swpool','', 0, 0);
07.01.2010 12:40
icon