297188 - checksetup.pl: primary key for groups exists. ( bit ) conflict with id as primary key

Status: RESOLVED DUPLICATE of bug 297187

(Bugzilla :: Installation & Upgrading, defect)

Description

[Christian Volkmann]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.8) Gecko/20050511
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.8) Gecko/20050511

Hi,
I did a migration of data from 2.14 to 2.19.3

checksetup.pl failed for the creation of the primary key "id".
The if ( ...) {  drop ... } did not work for me. I do not know why.

    if ($dbh->primary_key(undef, undef, 'groups')) {
        $dbh->do("ALTER TABLE groups DROP PRIMARY KEY");
    }

    $dbh->bz_add_column('groups', 'id',
        {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1});

Best regards,

Christian

Reproducible: Always

Steps to Reproduce:
1.get database from 2.14
2../checksetup.pl


Actual Results:  
checksetup.pl stopped

Expected Results:  
continue...

:) Thanks for bugzilla.

Comment 1

[Colin Ogilvie [:cso]]

*** This bug has been marked as a duplicate of 297187 ***