107385 - columns checked by sanitycheck.cgi have different widths

Status: RESOLVED WORKSFORME

(Bugzilla :: Bugzilla-General, defect)

Description

[Thomas R. Kimpton]

In the "Checking versions/products" section of sanitycheck.cgi the value column
(tinytext) from versions table has different width from the version column
(varchar(16)) from bugs table.  This can cause problems when data is changed 
from the params page.

Comment 1

[Dave Miller [:justdave]]

Are you sure you're using version 2.14 as stated in the bug report?  This was
fixed in bug 9352, which went in two months before 2.14 was released.

Comment 2

[Dave Miller [:justdave]]

Thomas Kimpton wrote:

> The sanitycheck.cgi says that it's 2.14. But, looking at 
> checksetup.pl, it lookls like it should have created it as 
> varchar(64)... perhaps I copied the database files for the upgrade.  
> Maybe you can add a check for this?

I wrote:

> There IS a check for it.  Have you run checksetup.pl?  Any time you
> change the database or upgrade you should always run that file.  If the
> widths aren't all 64 it should automatically fix it.

Thomas Kimpton wrote:

> Sorry about that, I just ran it, and it did update the table.

> A thousand pardons.

WORKSFORME per reporter