Package: bugzilla
Version: 2.16.7-7sarge1
Severity: important
Hi, I have a mostly sarge system. I have been using bugzilla with sarge
version of mysql for some time.
Because a new application needs mysql5 I have upgraded it from testing.
Now all the queries I have tried in bugzilla fail with messages like
this:
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 LEFT JOIN cc selectVisible_cc ON
bugs.bug_id = selectVisible_cc.bug_id AND
selectVisible_cc.who = 1 WHERE ((bugs.groupset &
9223372036854775807) = bugs.groupset OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 1) OR (bugs.cclist_accessible = 1 AND selectVisible_cc.who = 1
AND not isnull(selectVisible_cc.who)) OR (bugs.assigned_to = 1)) AND
bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid 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') AND
(map_assigned_to.login_name = '[EMAIL PROTECTED]' OR map_reporter.login_name =
'[EMAIL PROTECTED]') ORDER BY bugs.bug_id : Unknown column 'bugs.qa_contact' in
'on clause' at /usr/share/bugzilla/lib/globals.pl line 284.
For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving this
error message and the time and date of the error.
So what's up?
Bugzilla doesn't like mysql5, or the mysql4->5 upgrade went wrong? The
bugs themselves are there, so I thought that the upgrade was successful.
What can I do to have my queries back?
Cheers, Gabor
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (99, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-3-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages bugzilla depends on:
ii apache2-mpm-prefork [htt 2.0.54-5 traditional model for Apache2
ii boa [httpd] 0.94.14rc20-1.2 Lightweight and High Performance W
ii debconf 1.4.30.13 Debian configuration management sy
ii libappconfig-perl 1.56-2 Perl module for configuration file
ii libdbd-mysql-perl 2.9006-1 A Perl5 database interface to the
ii libtemplate-perl 2.14-1 template processing system written
ii libtimedate-perl 1.1600-4 Time and date functions for Perl
ii postfix [mail-transport- 2.1.5-9 A high-performance mail transport
-- debconf information:
* bugzilla/mysql_user: bugzilla
bugzilla/mysql_available: true
* bugzilla/bugzilla_installation_way: Automatic
* bugzilla/bugzilla_admin_real_name: Gee
bugzilla/mysql_host: localhost
* bugzilla/bugzilla_installation_way_single: Later
bugzilla/mysql_need_root: false
bugzilla/mysql_root_name: root
bugzilla/index_upgrade1:
bugzilla/mysql_name: bugzilla
* bugzilla/bugzilla_admin_name: [EMAIL PROTECTED]
bugzilla/mysql_port: 3306
bugzilla/index_upgrade2:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
