columns checked by sanitycheck.cgi have different widths

RESOLVED WORKSFORME

Status

()

--
major
RESOLVED WORKSFORME
17 years ago
6 years ago

People

(Reporter: tkimpton, Assigned: justdave)

Tracking

Details

(Reporter)

Description

17 years ago
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.
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.
OS: Solaris → All
Hardware: Sun → All
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
Status: NEW → RESOLVED
Last Resolved: 17 years ago
Resolution: --- → WORKSFORME
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.