Locations search

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

What is the error you see in 1?

jasperespejo · Posted: Mon Dec 04, 2006 4:01 pm Post subject:

Error!: class.mysql.php :: query() :: Table 'wherewhen_conx.Events' doesn't exist

select distinct location_id, Locations.name
from Events
left join Locations on Locations.id = Events.location_id
where (location_id > 0 and calendar = 35
and Locations.name != '' and Locations.name is not null)
or location_id = 0
order by lower(Locations.name)

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

At the top of the code, where it says:

global $_cur_cal, etc...

change it to

global $_cur_cal, $_cal_sql, $_cal_dbpref;

jasperespejo · Posted: Mon Dec 04, 2006 4:11 pm Post subject:

That made the venue list appear as expected. Now it's just the following error when submitted:

Method Not Allowed
The requested method POST is not allowed for the URL /index.html.

I did a search on google and I saw some post saying it might be a SEF problem. However I cannot turn SEF off per client's requirement :-(.

Thanks!

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

In the code, change the $loc_form = new _cal_form("locations"); to

jasperespejo · Posted: Mon Dec 04, 2006 5:15 pm Post subject:

That did it! Thanks Ian.