Red Hat Bugzilla – Bug 437969
Search doesn't work with new bugzilla instance
Last modified: 2008-05-27 23:49:06 EDT
I just decided to give the new bugzilla a spin. I clicked "Search" and then in
the search field typed
rstrode gdm smart cards
or something like that and then I got a sql error:
DBD::mysql::st execute failed: Unknown column 'user_group_map.group_id' in
'where clause' [for Statement "SELECT bugs.bug_id, bugs.bug_severity,
bugs.priority, bugs.bug_status, bugs.resolution, map_products.name,
bugs.bug_severity, bugs.priority, bugs.op_sys, map_assigned_to.login_name,
bugs.bug_status, bugs.resolution, bugs.short_desc,
(SUM(MATCH(longdescs_.thetext) AGAINST('rstrode gdm smart cards' )) + CASE WHEN
bugs.short_desc LIKE '%rstrode%' THEN 7 ELSE 0 END + CASE WHEN bugs.short_desc
LIKE '%gdm%' THEN 7 ELSE 0 END + CASE WHEN bugs.short_desc LIKE '%smart%' THEN 7
ELSE 0 END + CASE WHEN bugs.short_desc LIKE '%cards%' THEN 7 ELSE 0 END) AS
relevance FROM bugs INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to
= map_assigned_to.userid) INNER JOIN products AS map_products ON
(bugs.product_id = map_products.id) LEFT JOIN longdescs AS longdescs_ ON
(bugs.bug_id = longdescs_.bug_id AND longdescs_.isprivate < 1) LEFT JOIN
bug_group_map ON bug_group_map.bug_id = bugs.bug_id WHERE (( bugs.bug_status
) AND (MATCH(longdescs_.thetext) AGAINST('rstrode gdm smart cards' ) > 0 OR
(bugs.short_desc LIKE '%rstrode%' OR bugs.short_desc LIKE '%gdm%' OR
bugs.short_desc LIKE '%smart%' OR bugs.short_desc LIKE '%cards%'))) AND
bugs.creation_ts IS NOT NULL AND (((user_group_map.group_id IS NOT NULL) OR
(bug_group_map.bug_id IS NULL))) GROUP BY bugs.bug_id ORDER BY relevance desc
LIMIT 200"] at /var/www/html/bugzilla/buglist.cgi line 940
For help, please send mail to the webmaster (firstname.lastname@example.org), giving
this error message and the time and date of the error.
I was able to recreate this when not being logged in but it does work if you are
logged in. Please log in if you want to continue to test the new instance. We
will try to get this error fixed when users are not logged in.
Tony, can you take a look at this? It is related to the OR group changes made in
Bugzilla/Search.pm where it is checking for (user_group_map.group_id IS NULL)
but user_group_map is not included in the table joins when a user is not logged
Thanks for the report
Created attachment 299103 [details]
Seach without user login
(In reply to comment #6)
> Created an attachment (id=299382) 
> Patch to Search.pm implementing OR style group checking
The patch looks good.
did you test the patch to make sure it works in all the situations?
non-logged-in user, logged-in-user, in/out of groups?
(In reply to comment #8)
> did you test the patch to make sure it works in all the situations?
> non-logged-in user, logged-in-user, in/out of groups?
I have tested this patch against a bugzilla installed on my system in all
situations, although the bugzilla system on my system only includes a few users,
products and groups data.
Going into Milestone 3.