Error running Bugzilla after install on old database

[kbjorn]

We ahave a bugzilla running and recently made an upgrade to bugzilla-2.18.6. and mysql-5. Before the upgrade I took a dump on the database that I put back into mysql after upgrade. Made an uninstallation of both bugzilla and mysql before the upgrade. When now running bugzilla I get errors like:

DBD::mysql::st execute failed: Unknown column 'bugs.bug_id' in 'on clause' [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs, profiles AS map_assigned_to LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (6,3,9,4,1,7,2,5,8) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 1 WHERE bugs.assigned_to = map_assigned_to.userid AND (bugs.bug_status IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 1) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 1) ) GROUP BY bugs.bug_id"] at Bugzilla/DB.pm line 65
Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bu...') called at /var/www/bugzilla/htdocs/buglist.cgi line 774

When looking in the table the 'bugs.bug_id' is there alright. Dunno what to do right now.

[wpetya]

I had the same problem. I upgraded bugzilla to 2.22.

http://bugs.gentoo.org/show_bug.cgi?id=155340

You can downgrade your mysql or upgrade bugzilla to 2.20 or 2.22 (unstable).

[mikegpitt]

I can't believe this problem as been known for this long and hasn't been fixed. I needed to upgrade to mysql-5 today, and of course bugzilla broke. Now it seems like I'm stuck with an unstable version of bugzila and dev-perl/DBD-mysql on a highly critical server.

At least things are working now