Bugzilla Search for Bugs

Bugzilla Search for Bugs

Posted by: tgraupmann
Posted on: 2006-04-07 08:12:00

I followed these steps:
http://wiki.dreamhost.com/index.php/Bugzilla

I am getting this error when I search for bugs:

Please stand by ...
Software error:

SELECT DISTINCT bugs.bug_id, bugs.groupset, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs, profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid WHERE ((bugs.groupset & 0) = bugs.groupset ) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED') ORDER BY bugs.bug_id : Unknown column 'bugs.qa_contact' in 'on clause' at globals.pl line 276.

For help, please send mail to the webmaster

I think the problem is because the map_qa_contact table does not exist.

Has anyone else seen a similar problem?

Re: Bugzilla Search for Bugs

Posted by: psross
Posted on: 2006-04-07 17:19:00

There are compatibility issues with Bugzilla versions earlier than 2.20 and MySQL versions from 5.0.12 (see https://bugzilla.mozilla.org/show_bug.cgi?id=307091). Dreamhost are now using MySQL 5 for new databases.

Try installing Bugzilla 2.20.1 (the latest stable release) and see if that helps.

Tags: bugsdreamhostcontactbugzillamapdeschttpwikiprofilesselect distinctsoftware errorlogin nameleft joinpriorityphpindex