267383 - checksetup.pl fails with "table user_series_map doesn't exist"

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[Jason Bradley Nance]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7) Gecko/20040803 Firefox/0.9.3
Build Identifier: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7) Gecko/20040803 Firefox/0.9.3

Hi.  I just upgraded to the latest CVS (cvs update -dP) from 2.18rc1.  When I
run checksetup.pl (as root), it fails with:

DBD::mysql::db do failed: Table 'bugs.user_series_map' doesn't exist at
Bugzilla/Series.pm line 157
        Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x9d4a154)')
called at ./checksetup.pl line 3876

Reproducible: Always
Steps to Reproduce:
1. update source to latest cvs (cd bugzilla-src-dir ; cvs login ; cvs update -dP)
2. run "checksetup.pl" as root (sudo ./checksetup.pl)

Actual Results:  
Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.05
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.43
Checking for      DBD::mysql (v2.1010) ok: found v2.1021
Checking for      File::Spec (v0.82)   ok: found v0.83
Checking for      File::Temp (any)     ok: found v0.13
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)    not found
Checking for     Chart::Base (v1.0)     not found
Checking for     XML::Parser (any)     ok: found v2.31
Checking for       GD::Graph (any)      not found
Checking for GD::Text::Align (any)      not found
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

If you you want to see graphical bug charts (plotting historical data over 
time), you should install libgd and the following Perl modules:

GD:          /usr/bin/perl -MCPAN -e 'install "GD"'
Chart:       /usr/bin/perl -MCPAN -e 'install "Chart::Base"'

If you you want to see graphical bug reports (bar, pie and line charts of 
current data), you should install libgd and the following Perl modules:

GD:              /usr/bin/perl -MCPAN -e 'install "GD"'
GD::Graph:       /usr/bin/perl -MCPAN -e 'install "GD::Graph"'
GD::Text::Align: /usr/bin/perl -MCPAN -e 'install "GD::Text::Align"'

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v4.0.20-standard-log

Populating duplicates table...
Migrating old chart data into database ...
DBD::mysql::db do failed: Table 'bugs.user_series_map' doesn't exist at
Bugzilla/Series.pm line 157
        Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x9d4a154)')
called at ./checksetup.pl line 3876

Expected Results:  
All tables should have been automagically created or an error as to why it
couldn't create the table (bad mysql user permissions?).

Comment 1

[Jason Bradley Nance]

It appears that the table structure for user_series_map isn't included in
checksetup.pl.  Looks like it should be somewhere around line 1947 (that's where
the other series tables are).

Comment 2

[Jason Bradley Nance]

Ehh... I did my cvs update incorrectly.
Should have done "cvs update -AdP" instead.
It works fine for me now.

Comment 3

[Dave Miller [:justdave]]

clearing target on INVALID/WONTFIX/WORKSFORME/DUPLICATE so they show up as
untriaged if they ever get reopened.