Unable to update 2.16.x databases to 2.17.4

Tom Emerson tree at basistech.com
Thu Oct 16 15:40:17 UTC 2003

The short: checksetup.pl in 2.17.4 is not updating my 2.16.x tables
           correctly even though I was under the impression that it

The long:

Virginal 2.17.4 installation (from CVS) on a freshly installed RedHat
9 machine, using the MySQL RPMs for MySQL 3.23.58. MySQL tables exist
on another 3.28.x server on another machine: these were used by a
Bugzilla 2.16.1 installation, remotely from another machine.

Attempts to run checksetup (modified so that the print on line 1786
showing the tables found in the 'bugs' database) in the 2.17.4
installation result in the following:

[root at them bugzilla]# ./checksetup.pl 

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.55
Checking for             CGI (v2.88)   ok: found v3.00
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.32)   ok: found v1.38
Checking for      DBD::mysql (v2.1010) ok: found v2.9002
Checking for      File::Spec (v0.82)   ok: found v0.86
Checking for      File::Temp (any)     ok: found v0.14
Checking for        Template (v2.08)   ok: found v2.10
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v2.11
Checking for     Chart::Base (v0.99)   ok: found v2.2
Checking for     XML::Parser (any)     ok: found v2.34
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v3.23.53

Tables: `attachments` `attachstatusdefs` `attachstatuses` `bugs` `bugs_activity` `cc` `components` `dependencies` `duplicates` `fielddefs` `groups` `keyworddefs` `keywords` `logincookies` `longdescs` `milestones` `namedqueries` `products` `profiles` `profiles_activity` `shadowlog` `tokens` `versions` `votes` `watch` 
Creating table group_control_map ...
Creating table user_group_map ...
Creating table fielddefs ...
[Thu Oct 16 11:27:50 2003] checksetup.pl: DBD::mysql::db do failed: Table 'fielddefs' already exists at ./checksetup.pl line 1808.
<h1>Software error:</h1>
<pre>Could not create table 'fielddefs'. Please check your 'mysql' access.
For help, please send mail to this site's webmaster, giving this error message 
and the time and date of the error.

[Thu Oct 16 11:27:50 2003] checksetup.pl: Could not create table 'fielddefs'. Please check your 'mysql' access.

We can see that checksetup.pl is trying to create the table fielddefs
even though it exists, as shown by the "Tables" line before "Creating
table group_control_map".

If I now rerun checksetup.pl it barfs similarly, only with
group_control_map --- which it created the first time I ran the



Tom Emerson                                          Basis Technology Corp.
Software Architect                                 http://www.basistech.com
  "Beware the lollipop of mediocrity: lick it once and you suck forever"

More information about the developers mailing list