SQL issue after update from 2.22.2 to 3.4.6

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQL issue after update from 2.22.2 to 3.4.6

cdm_bo
Hi,

Any help with this issue will be appreciated :-)

I have recently updated and when I browse to Bugzilla, this error appears:

Bugzilla has suffered an internal error. Please save this page and send it to xxxxxx with details of what you were doing at the time this message appeared.

URL: http://x.x.x.x/bugzilla/

Template->process() failed twice.
First error: undef error - DBD::mysql::st execute failed: Unknown column 'subclass' in 'field list' [for Statement "SELECT name, default_value, is_enabled, subclass FROM setting ORDER BY name"] at Bugzilla/User/Setting.pm line 211 Bugzilla::User::Setting::get_defaults() called at Bugzilla/User.pm line 353 Bugzilla::User::settings('Bugzilla::User=HASH(0x212886c)') called at data\template\template\en\default\global\header.html.tmpl line 50 eval {...} called at data\template\template\en\default\global\header.html.tmpl line 50 eval {...} called at data\template\template\en\default\global\header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Document.pm line 151 eval {...} called at c:/perl/site/lib/Template/Document.pm line 149 Template::Document::process('Template::Document=HASH(0x2b587a0)', 'Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Context.pm line 351 eval {...} called at c:/perl/site/lib/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x2ab7538)', 'global/header.html.tmpl') called at data\template\template\en\default\global\message.html.tmpl line 26 eval {...} called at data\template\template\en\default\global\message.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Document.pm line 151 eval {...} called at c:/perl/site/lib/Template/Document.pm line 149 Template::Document::process('Template::Document=HASH(0x2af0fe0)', 'Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Context.pm line 351 eval {...} called at c:/perl/site/lib/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x2ab7538)', 'Template::Document=HASH(0x2af0fe0)') called at c:/perl/site/lib/Template/Service.pm line 94 eval {...} called at c:/perl/site/lib/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x2a89360)', 'global/message.html.tmpl', 'HASH(0x28ecb5c)') called at c:/perl/site/lib/Template.pm line 66 Template::process('Bugzilla::Template=HASH(0x1bd055c)', 'global/message.html.tmpl', 'HASH(0x28ecb5c)', 'SCALAR(0x28691f8)') called at Bugzilla.pm line 161 Bugzilla::init_page() called at Bugzilla.pm line 168 require Bugzilla.pm called at c:\bugzilla\index.cgi line 34 main::BEGIN() called at Bugzilla.pm line 0 eval {...} called at Bugzilla.pm line 0
Second error: undef error - DBD::mysql::st execute failed: Unknown column 'subclass' in 'field list' [for Statement "SELECT name, default_value, is_enabled, subclass FROM setting ORDER BY name"] at Bugzilla/User/Setting.pm line 211 Bugzilla::User::Setting::get_defaults() called at Bugzilla/User.pm line 353 Bugzilla::User::settings('Bugzilla::User=HASH(0x212886c)') called at data\template\template\en\default\global\header.html.tmpl line 50 eval {...} called at data\template\template\en\default\global\header.html.tmpl line 50 eval {...} called at data\template\template\en\default\global\header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Document.pm line 151 eval {...} called at c:/perl/site/lib/Template/Document.pm line 149 Template::Document::process('Template::Document=HASH(0x2b587a0)', 'Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Context.pm line 351 eval {...} called at c:/perl/site/lib/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x2ab7538)', 'global/header.html.tmpl') called at data\template\template\en\default\global\code-error.html.tmpl line 1999 eval {...} called at data\template\template\en\default\global\code-error.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Document.pm line 151 eval {...} called at c:/perl/site/lib/Template/Document.pm line 149 Template::Document::process('Template::Document=HASH(0x2d4f93c)', 'Template::Context=HASH(0x2ab7538)') called at c:/perl/site/lib/Template/Context.pm line 351 eval {...} called at c:/perl/site/lib/Template/Context.pm line 321 Template::Context::process('Template::Context=HASH(0x2ab7538)', 'Template::Document=HASH(0x2d4f93c)') called at c:/perl/site/lib/Template/Service.pm line 94 eval {...} called at c:/perl/site/lib/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x2a89360)', 'global/code-error.html.tmpl', 'HASH(0x2c37514)') called at c:/perl/site/lib/Template.pm line 66 Template::process('Bugzilla::Template=HASH(0x1bd055c)', 'global/code-error.html.tmpl', 'HASH(0x2c37514)') called at Bugzilla/Error.pm line 148 Bugzilla::Error::ThrowTemplateError('Template::Exception=ARRAY(0x2cae270)') called at Bugzilla.pm line 161 Bugzilla::init_page() called at Bugzilla.pm line 168 require Bugzilla.pm called at c:\bugzilla\index.cgi line 34 main::BEGIN() called at Bugzilla.pm line 0 eval {...} called at Bugzilla.pm line 0


I can see that the MySQL DB is part of the problem, but maybe only part of it.

I ran checksetup.pl several times and all mandatory modules are installed. Checksetup.pl finishes with this text:

Bugzilla now uses the InnoDB storage engine in MySQL for most tables.
Converting tables to InnoDB:
Converting table attach_data... done.
Converting table attachments... done.
Converting table bug_group_map... DBD::mysql::db do failed: Error on rename of '
.\bugs\#sql-5ec_17' to '.\bugs\bug_group_map' (errno: 121) [for Statement "ALTER
 TABLE bug_group_map ENGINE = InnoDB"] at Bugzilla/DB/Mysql.pm line 384
        Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x55965
b8)') called at C:\bugzilla\checksetup.pl line 143
&Image::Magick::constant not defined. The required ImageMagick libraries are not
 installed or not installed properly.
END failed--call queue aborted at C:\bugzilla\checksetup.pl line 384, <DATA> chu
nk 228.


Any easy solutions? I have searched for an empty bugzilla DB, just to see if it would run, but without luck.