Is there any reason for a search page that searches through events for a
keyword and then displays those that contain the keyword to not give any
results in production when it does in development? I’ve made sure I’m
searching terms that should give me results in production, but it’s like
it’s not searching through the events at all or something.
Amanda … wrote:
Is there any reason for a search page that searches through events for a
keyword and then displays those that contain the keyword to not give any
results in production when it does in development? I’ve made sure I’m
searching terms that should give me results in production, but it’s like
it’s not searching through the events at all or something.
Check or turn on your logging in Production to see what’s going on.
Ar Chron wrote:
Check or turn on your logging in Production to see what’s going on.
In my dev log I get a whole bunch of stuff from checkin each event for
the keywords (i think thats what its doin):
Processing SearchController#keyword (for 127.0.0.1 at 2008-06-03
16:29:17) [POST]
Session ID: bc95e3751aa213c624c33af71a846c8c
Parameters: {“commit”=>“Search”, “text”=>“test”,
“order”=>“created_on”, “action”=>“keyword”, “method”=>“post”,
“controller”=>“search”, “search_auds”=>“1”, “search_streams”=>“1”}
e[4;36;1mCalendar Load (0.001025)e[0m e[0;1mSELECT * FROM calendars
WHERE (hidden=0) e[0m
e[4;35;1mCalendar Columns (0.002512)e[0m e[0mSHOW FIELDS FROM
calendarse[0m
e[4;36;1mCalendar Load (0.001113)e[0m e[0;1mSELECT * FROM calendars
WHERE (hidden=0) e[0m
e[4;35;1mStream Columns (0.002510)e[0m e[0mSHOW FIELDS FROM
calendarse[0m
e[4;36;1mEvent Columns (0.002639)e[0m e[0;1mSHOW FIELDS FROM
eventse[0m
e[4;35;1mStamp Columns (0.001862)e[0m e[0mSHOW FIELDS FROM
stampse[0m
…
In the production log I just get:
Processing SearchController#keyword
[POST]
Session ID: a0db357e9a9aaec2298535c55618f688
Parameters: {“commit”=>“Search”, “text”=>“test”,
“order”=>“created_on”, “action”=>“keyword”, “method”=>“post”,
“controller”=>“search”, “search_auds”=>“1”, “search_streams”=>“1”}
Rendering within layouts/application
Rendering search/keyword
Completed in 0.15170
So it doesn’t even check for the keywords in the events?
I believe you need to turn on debug for your production environment to
see more.
Something like this in your production.rb should give you most of
“production” behaviors, but you’ll still get debug.
Show full error reports and enable caching
config.log_level = :debug
config.action_controller.consider_all_requests_local = true
config.action_controller.perform_caching = true
config.action_view.cache_template_extensions = true
config.action_view.debug_rjs = true
I always add
config.active_record.colorize_logging = false
to get rid of the unreadable e[4;35;1mS stuff
Ar Chron wrote:
I believe you need to turn on debug for your production environment to
see more.
Where do I do this? In the terminal? sorry I’m new to the rails stuff
You do this in your environment configuration file, in this case
config/environments/production.conf
Serge
On Jun 3, 5:45 pm, “Amanda …” [email protected]
Does anyone have any suggestions? I’m completely stuck on this and my
logs aren’t showing me anything that would help.
Thanks a lot for that, now I can see that it is finding some
events…but only past events (dated before today), and not displaying
them (this is what it’s supposed to do)…but it should also be finding
events for today and the future and displaying them. I think there might
be something wrong in the base condition in the event search method:
def self.search(search_streams, search_auds, keywords, options = {},
*args)
default_options = {
“calendars” => Calendar.find_public,
:status => :approved
}
options = default_options.merge(options)
if keywords.nil? or keywords == “”
t = “%” + keywords.to_s.gsub(/\s/, ‘%’) + “%”
base_condition = ["(title like ? OR body like ? OR location like
?)", t, t, t]
else
t = (keywords.split(" “).collect { |x| “[[:<:]]” + x + “[[:>:]]”
}).join(”|")
base_condition = ["(title regexp ? OR body regexp ? OR location
regexp ?)", t, t, t]
end
events = []
streams = []
audiences = []
options[“calendars”].each do |c|
audiences << c if c.is_a?(Audience)
streams << c if c.is_a?(Stream)
end
if search_streams == “1”
for cal in streams
base_condition[0] += ’ AND stamps.calendar_id = ? AND stamps.status =
?’
base_condition += [cal.id, Stamp::STATUS[options[:status]]]
e = Event.find(:all, :conditions => base_condition, :include =>
:stamps)
events += e
end
end
if search_auds == “1”
for cal in audiences
base_condition[0] += " AND audiences_events.audience_id = ?"
base_condition << cal.id
# explicitly written joins instead of using the :include option
# the :include option creates an invalid SQL statement
e = Event.find(:all, :conditions => base_condition, :include =>
:stamps,
:joins => ‘LEFT OUTER JOIN audiences_events ON
audiences_events.event_id = events.id LEFT OUTER JOIN
calendars ON calendars.id = audiences_events.audience_id’)
events += e
end
end
events.uniq!
Do you see anything there that would work properly in development but
not in production? Thanks a lot for your help!
Okay so I figured out that if i comment out the 2 lines:
base_condition[0] +=’ AND stamps.calendar_id = ? AND stamps.status = ?’
base_condition += [cal.id, Stamp::STATUS[options[:status]]]
Then the search finds and displays the events like it should…anyone
know why this is? I don’t get it