How to import data from version 2.20.4 to 3.0

[haomiao]

Hi
I want to install bugzilla 3.0. But I have installed bugzilla
2.20.4 in another machine and this version has bben used for many
days. So all the data of 2.20.4 need to be migrated.

I do the following
- install bugzilla3.0 ok
- mysqldump bugs >dump.sql -u bugs -p (at 2.20.4) ok
- mysql -u bugs -p <dump.sql (at 3.0) ok

When I visit bugzilla3.0 from browser. It reports error.

What is the proper steps to do this job.

Here is the error page
---------------------------------------------
Bugzilla has suffered an internal error. Please save this page and
send it to THE MAINTAINER HAS NOT YET BEEN SET with details of what
you were doing at the time this message appeared.

URL: http://172.17.237.73/bugzilla/

Template->process() failed twice.
First error: undef error - DBD::mysql::db selectrow_array failed:
Unknown column 'subclass' in 'field list' [for Statement "SELECT
subclass FROM setting WHERE name = ?"] at Bugzilla/User/Setting.pm
line 102 Bugzilla::User::Setting::new('Bugzilla::User::Setting',
'comment_sort_order', 0, 1, 'oldest_to_newest', 'oldest_to_newest', 1)
called at Bugzilla/User/Setting.pm line 214
Bugzilla::User::Setting::get_defaults() called at Bugzilla/User.pm
line 344 Bugzilla::User::settings('Bugzilla::User=HASH(0x8a67a30)')
called at data/template/template/en/default/global/header.html.tmpl
line 110 eval {...} called at data/template/template/en/default/global/
header.html.tmpl line 110 eval {...} called at data/template/template/
en/default/global/header.html.tmpl line 16
Template::Provider::__ANON__('Template::Context=HASH(0x92843c0)')
called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/
Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153
Template::Document::process('Template::Document=HASH(0x933fc00)',
'Template::Context=HASH(0x92843c0)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 349
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Context.pm line 319
Template::Context::process('Template::Context=HASH(0x92843c0)',
'global/header.html.tmpl', 'HASH(0x932a9e8)') called at data/template/
template/en/default/index.html.tmpl line 25 eval {...} called at data/
template/template/en/default/index.html.tmpl line 16
Template::Provider::__ANON__('Template::Context=HASH(0x92843c0)')
called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/
Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153
Template::Document::process('Template::Document=HASH(0x93029c4)',
'Template::Context=HASH(0x92843c0)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 349
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Context.pm line 319
Template::Context::process('Template::Context=HASH(0x92843c0)',
'Template::Document=HASH(0x93029c4)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 94
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Service.pm line 91
Template::Service::process('Template::Service=HASH(0x92821e0)',
'index.html.tmpl', 'HASH(0x916c854)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template.pm line 68
Template::process('Bugzilla::Template=HASH(0x9240640)',
'index.html.tmpl', 'HASH(0x916c854)') called at /usr/local/bugzilla/
index.cgi line 71
Second error: undef error - DBD::mysql::db selectrow_array failed:
Unknown column 'subclass' in 'field list' [for Statement "SELECT
subclass FROM setting WHERE name = ?"] at Bugzilla/User/Setting.pm
line 102 Bugzilla::User::Setting::new('Bugzilla::User::Setting',
'comment_sort_order', 0, 1, 'oldest_to_newest', 'oldest_to_newest', 1)
called at Bugzilla/User/Setting.pm line 214
Bugzilla::User::Setting::get_defaults() called at Bugzilla/User.pm
line 344 Bugzilla::User::settings('Bugzilla::User=HASH(0x8a67a30)')
called at data/template/template/en/default/global/header.html.tmpl
line 110 eval {...} called at data/template/template/en/default/global/
header.html.tmpl line 110 eval {...} called at data/template/template/
en/default/global/header.html.tmpl line 16
Template::Provider::__ANON__('Template::Context=HASH(0x92843c0)')
called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/
Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153
Template::Document::process('Template::Document=HASH(0x933fc00)',
'Template::Context=HASH(0x92843c0)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 349
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Context.pm line 319
Template::Context::process('Template::Context=HASH(0x92843c0)',
'global/header.html.tmpl') called at data/template/template/en/default/
global/code-error.html.tmpl line 1757 eval {...} called at data/
template/template/en/default/global/code-error.html.tmpl line 16
Template::Provider::__ANON__('Template::Context=HASH(0x92843c0)')
called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/
Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153
Template::Document::process('Template::Document=HASH(0x93f52c4)',
'Template::Context=HASH(0x92843c0)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 349
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Context.pm line 319
Template::Context::process('Template::Context=HASH(0x92843c0)',
'Template::Document=HASH(0x93f52c4)') called at /usr/lib/perl5/
site_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 94
eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
multi/Template/Service.pm line 91
Template::Service::process('Template::Service=HASH(0x92821e0)',
'global/code-error.html.tmpl', 'HASH(0x92dbe98)') called at /usr/lib/
perl5/site_perl/5.8.5/i386-linux-thread-multi/Template.pm line 68
Template::process('Bugzilla::Template=HASH(0x9240640)', 'global/code-
error.html.tmpl', 'HASH(0x92dbe98)') called at Bugzilla/Error.pm line
130
Bugzilla::Error::ThrowTemplateError('Template::Exception=ARRAY(0x937fadc)')
called at /usr/local/bugzilla/index.cgi line 71
-----------------------------------------------------------------------------------------------

[Thorsten Schöning]

Hallo haomiao haomiao,
Wednesday, August 8, 2007, 3:37:18 PM, haben Sie folgendes geschrieben:

> What is the proper steps to do this job.

The easiest way is just to migrate your existing Bugzilla installation
and afterwards upgrdae this one to 3.0. What you missed in your steps
is pretty much running chechksetup.pl after importing the old
database. The database scheme changed and must be upgraded by
checksetup.pl after importing by mysql.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning
AM-SoFT IT-Systeme - Hameln | Potsdam | Leipzig

Telefon: Potsdam: 0331-743881-0
E-Mail: tscho...@am-soft.de
Web: http://www.am-soft.de

AM-SoFT Potsdam GmbH, Konsumhof 1-5, 14482 Potsdam
Amtsgericht Potsdam HRB 12480, Geschäftsführer Andreas Muchow

[haomiao]

Yes, It works , thank you.

It seems that I must clear the bugs database first, then import
data and checksetup.pl.