Typos: Exchanged "auth_catagory" by "auth_category"

CommentFileSizeAuthor
biblio_install_colname.patch972 bytesschildi

Comments

rjerome’s picture

Actually, that's not a typo. What's happening in update 6013 is I'm correcting a previous typo where I originally had named the column "auth_catagory" and then I corrected it to "auth_category"

    $result[] = update_sql("ALTER TABLE {biblio_contributor_type} CHANGE COLUMN auth_catagory auth_category 
                          INTEGER UNSIGNED NOT NULL DEFAULT 0,
                          DROP PRIMARY KEY,
                          ADD PRIMARY KEY USING BTREE(auth_category, biblio_type, auth_type)");

is renaming the column from auth_catagory to auth_category.

Ron.

schildi’s picture

Oh, may be I was wrong.
I got error messages when upgrading D5->D6 and corrected the "misspelling".
Does this mean that the tables I changed by applying the patch above are now corrupted?

rjerome’s picture

No, you tables should be fine since your patch essentially does nothing. You your case (upgrade from 5) that (incorrect) column name would have never existed since the that's a new table which would have been created correctly.

What this does point out is a flaw in the upgrade, I'll have to skip this step if upgrading from 5.x.

Ron.

schildi’s picture

Status: Active » Closed (fixed)

thanks!