Bugzilla Search for Bugs


#1

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?


#2

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.