Install problem updating 2.20.2 to 3.0.2 (DBD::mysql::db )
Paolo FALZEA
I perform the update of the mysql from v. 4.0.15 to 5.0.45
I permorm the update of the modules required from checksetup log through bugzilla 3.0.2.
But when I try to enter in buzilla, I receive the following error.
When I downgrade to ver 2.20.2 all came back ok.
How I can solve the problem ?
Thank you
ERROR:
DBD::mysql::db selectrow_hashref failed: Unknown column 'profiles.disable_mail' in 'field list' [for Statement "
SELECT profiles.userid AS id,profiles.login_name,profiles.realname,profiles.mybugslink AS showmybugslink,profiles.disabledtext,profiles.disable_mail FROM profiles
WHERE userid = ?"] at Bugzilla/Object.pm line 69
Bugzilla::Object::_init('Bugzilla::User', 1) called at Bugzilla/Object.pm line 40
Bugzilla::Object::new('Bugzilla::User', 1) called at Bugzilla/User.pm line 131
Bugzilla::User::new('Bugzilla::User', 1) called at Bugzilla/Auth/Verify.pm line 111
Bugzilla::Auth::Verify::create_or_update_user('Bugzilla::Auth::Verify::DB=ARRAY(0xb9bdf4)', 'HASH(0xc803b0)') called at Bugzilla/Auth/Verify/Stack.pm line 65
Bugzilla::Auth::Verify::Stack::create_or_update_user('Bugzilla::Auth::Verify::Stack=ARRAY(0xb95850)', 'HASH(0xc803b0)') called at Bugzilla/Auth.pm line 77
Bugzilla::Auth::login('Bugzilla::Auth=ARRAY(0xb71aac)', 0) called at Bugzilla.pm line 232
Bugzilla::login('Bugzilla', 0) called at /home/cvsadmin//bugrep/bugzilla-2.18/index.cgi line 40
The LOG of checkconfig seems ok.
* This is Bugzilla 3.0.2 on perl 5.8.8
* Running on SunOS 5.8 Generic_117350-26
Checking perl modules...
Checking for CGI (v2.93) ok: found v3.25
Checking for TimeDate (v2.21) ok: found v2.22
Checking for DBI (v1.41) ok: found v1.58
Checking for PathTools (v0.84) ok: found v3.21
Checking for Template-Toolkit (v2.12) ok: found v2.15
Checking for Email-Send (v2.00) ok: found v2.185
Checking for Email-MIME-Modifier (any) ok: found v1.442
Checking available perl DBD modules...
Checking for DBD-Pg (v1.45) ok: found v1.49
Checking for DBD-mysql (v2.9003) ok: found v3.0008
The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.35
Checking for Template-GD (any) ok: found v1.56
Checking for Chart (v1.0) ok: found v2.1
Checking for GDGraph (any) ok: found v1.4308
Checking for GDTextUtil (any) ok: found v0.86
Checking for XML-Twig (any) ok: found v3.26
Checking for MIME-tools (v5.406) ok: found v5.420
Checking for libwww-perl (any) ok: found v2.036
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for PerlMagick (any) not found
Checking for perl-ldap (any) ok: found v0.34
Checking for SOAP-Lite (any) ok: found v0.55
Checking for HTML-Parser (v3.40) ok: found v3.55
Checking for HTML-Scrubber (any) ok: found v0.08
Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.313
Checking for Email-Reply (any) ok: found v1.202
Checking for mod_perl (v1.999022) not found
Checking for CGI (v3.11) ok: found v3.25
Checking for Apache-DBI (v0.96) ok: found v1.06
* NOTE: You must run any commands listed below as root.
**********************************************************************
* OPTIONAL MODULES *
**********************************************************************
* Certain Perl modules are not required by Bugzilla, but by *
* installing the latest version you gain access to additional *
* features. *
* *
* The optional modules you do not have installed are listed below, *
* with the name of the feature they enable. If you want to install *
* one of these modules, just run the appropriate command in the *
* "COMMANDS TO INSTALL" section. *
**********************************************************************
***********************************************************************
* MODULE NAME * ENABLES FEATURE(S) *
***********************************************************************
* PerlMagick * Optionally Convert BMP Attachments to PNGs *
* mod_perl * mod_perl *
***********************************************************************
COMMANDS TO INSTALL:
PerlMagick: /home/cvsadmin/bugrep/perl-5.8.8.p/bin/perl -MCPAN -e 'install Image::Magick'
mod_perl: /home/cvsadmin/bugrep/perl-5.8.8.p/bin/perl -MCPAN -e 'install mod_perl2'
Reading ./localconfig...
OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:
http://cyberelk.net/tim/patchutils/
Checking for DBD-mysql (v2.9003) ok: found v3.0008
Checking for MySQL (v4.1.2) ok: found v5.0.45
Creating ./data directory...
Creating ./data/attachments directory...
Creating ./data/duplicates directory...
Creating ./data/mimedump-tmp directory...
Creating ./data/mining directory...
Creating ./data/webdot directory...
Creating ./extensions directory...
Creating graphs directory...
Creating skins/contrib directory...
Creating skins/custom directory...
Creating ./data/mail...
Creating ./Bugzilla/.htaccess...
Creating ./data/.htaccess...
Creating ./data/attachments/.htaccess...
Creating ./data/webdot/.htaccess...
Creating ./template/.htaccess...
Creating .htaccess...
Precompiling templates...
setting in ./localconfig.
Max Kanat-Alexander
wrote:
> DBD::mysql::db selectrow_hashref failed: Unknown column
> 'profiles.disable_mail' in 'field list' [for Statement " SELECT
> profiles.userid AS
There was some error or mistake made somewhere in your upgrade
process. You need to start from your original 2.20.2 install and do the
upgrade to 3.0.2 again.
Note that if you do a "mysqldump" to copy around your database,
you must do it into a *completely empty database*. That is, you must
"DROP DATABASE" the target database, and then "CREATE DATABASE" it
again.
-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.