Your message dated Thu, 12 Oct 2006 07:45:25 +0200 with message-id <[EMAIL PROTECTED]> and subject line Bug unreproducible has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---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:
--- End Message ---
--- Begin Message ---I don't manage to reproduce the bug with last versions of the package, I asked for feedback a month ago and got no answer. I therefor close the bug, feel free to reopen it if you manage to reproduce it (and explain me how). Regards, -- Alexis Sukrieh [EMAIL PROTECTED] 0x1EE5DD34 [EMAIL PROTECTED] The real glory of maintainership isn't making the big and important decisions. The real glory lies in all the small stuff that doesn't really matter, and that people will just argue forever. -- Linus Torvalds
--- End Message ---
