379423 - fatal internal error while searching for test results

Status: RESOLVED FIXED

(Webtools Graveyard :: Litmus, defect)

Description

[juan becerra [:juanb]]

I tried to search for test results, so I edited the drop-downs to search for 1.5 tests results for Firefox on windows, en-us, and i got a page like this:

http://litmus.mozilla.org/search_results.cgi?order_by_created=&order_by_testcase_id=&order_by_email=&order_by_product=&order_by_platform=&order_by_branch=&order_by_locale=&timespan=&summary=&email=&product=Firefox&platform=Windows&branch=1.5+Branch&locale=en-US&limit=15

Which shows an error message that starts like this:

Error - Litmus has suffered a serious fatal internal error - Litmus::DB::Testresult can't SELECT DISTINCT

Comment 1

[Chris Cooper [:coop] (he/him)]

Working on this right now...hoping to land something before testday starts today.

Comment 2

[Chris Cooper [:coop] (he/him)]

I've changed the search results limiting form to use IDs instead of name-based regexps, which is much quicker especially when the queries start getting arbitrarily complex from the advanced search form.

Your name-based query (as well as any others that people may have bookmarked, e.g. Tracy's daily reports) should work again now. The one drawback is that the search form itself won't be prepopulated with your search criteria, since it is now using IDs.

Any new searches you perform by hand should just work, and you *shouldn't* notice any difference.