kbjorn n00b
Joined: 15 Apr 2005 Posts: 10
|
Posted: Sun Nov 12, 2006 5:11 pm Post subject: Error running Bugzilla after install on old database |
|
|
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, 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:B::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. |
|