265205 - sql errors on talkback-public

Status: RESOLVED FIXED

(mozilla.org :: Talkback Server & Webtool, task)

Description

[GavinS]

User-Agent:       Mozilla/5.0 (Windows; U; Win95; en-US; rv:1.6) Gecko/20040206 Firefox/0.8
Build Identifier: Mozilla/5.0 (Windows; U; Win95; en-US; rv:1.6) Gecko/20040206 Firefox/0.8

A search on talkback-public gives an sql error, like this:


No Incidents Found.

DB Error processing query: SELECT d.bbid from blackboxes_by_deployment d,
fc__keytable_1090 u WHERE lower(u.keyvalue) LIKE '%hix%' AND d.bbid = s.bbid
ORDER BY d.bbid DESC

Reproducible: Always
Steps to Reproduce:
1. go to talkback-public.mozilla.org
2. type 'hix' as search string
3. set search for url, or comment
4) Click search

Actual Results:  
get error

Expected Results:  
see list oftalkbacks

Comment 1

[Jay Patel [:jay]]

This is really weird, because everything was working fine for about a week.  I
have not changed any of the code since last week (when I added the sort
functionality).

Adam, any idea how long you've been seeing this?  I as able to do all kinds of
searches last week.

Comment 2

[GavinS]

Do you need a clause in the WHERE to connect the 2 tables 'd' and 'u' somehow?

Comment 3

[Jay Patel [:jay]]

Yeah, I see the problem in the SQL, but the funny thing is that I added a sort
feature last week and everything was working fine for a while.  My code injects
the necessary tables into the SQL depending on the "searchfor" and "sortby"
values in the query string...which was working fine before, but is for some
reason broken now.  I'll look into it today.

Comment 4

[Jay Patel [:jay]]

Ok, I took a look and realized that I forgot to make a small change on Monday
when I added some optimization.  I think this should be fixed now, so please
give all kinds of search/sort combinations a try and let me know if you see any
more problems.