Oops...

[Gervase Markham]

I just tried installing a new Bugzilla on landfill, and left the DB name 
as the default ("bugs"). When I ran checksetup, the following happened, 
which suggests that this database was rather old:

Have a messed something big up?

Gerv

<snip>

Checking for    MySQL Server (v3.23.41) ok: found v3.23.56

One or more of the tables in your existing MySQL database are of type ISAM.
ISAM tables are deprecated in MySQL 3.23 and don't support more than 16 
indexes
per table, which Bugzilla needs.  Converting your ISAM tables to type 
MyISAM:

Converting table attachments... done.
Converting table attachstatusdefs... done.
Converting table attachstatuses... done.
Converting table bugs... done.
Converting table bugs_activity... done.
Converting table cc... done.
Converting table components... done.
Converting table dependencies... done.
Converting table duplicates... done.
Converting table fielddefs... done.
Converting table groups... done.
Converting table keyworddefs... done.
Converting table keywords... done.
Converting table logincookies... done.
Converting table longdescs... done.
Converting table milestones... done.
Converting table namedqueries... done.
Converting table products... done.
Converting table profiles... done.
Converting table profiles_activity... done.
Converting table shadowlog... done.
Converting table tokens... done.
Converting table versions... done.
Converting table votes... done.
Converting table watch... done.

ISAM->MyISAM table conversion done.

Creating table group_control_map ...
Creating table user_group_map ...
Creating table group_group_map ...
Creating table flagexclusions ...
Creating table flagtypes ...
Creating table bug_group_map ...
Creating table flags ...
Creating table flaginclusions ...
Creating table quips ...
Updating field op_sys in table bugs ...
Creating duplicates directory...
Adding new field work_time to table longdescs ...
Adding new field estimated_time to table bugs ...
Adding new field remaining_time to table bugs ...
Adding new field isprivate to table longdescs ...
Adding new field isprivate to table attachments ...
Adding new field alias to table bugs ...
Deleting unused field watchfordiffs from table namedqueries ...
Updating database to use product IDs.
Adding new field id to table products ...
Adding new field product_id to table components ...
Adding new field product_id to table versions ...
Adding new field product_id to table milestones ...
Adding new field product_id to table bugs ...
Adding new field product_id to table attachstatusdefs ...
Updating the database to use component IDs.
Adding new field id to table components ...
Adding new field component_id to table bugs ...
Fixing Indexes and Uniqueness.
Removing, renaming, and retyping old product and component fields.
Deleting unused field program from table components ...
Deleting unused field program from table versions ...
Deleting unused field product from table milestones ...
Deleting unused field product from table bugs ...
Deleting unused field component from table bugs ...
Deleting unused field product from table attachstatusdefs ...
Updating field product in table products ...
Updating field type name in table products ...
old: varchar(64)
new: varchar(64) not null
Updating field value in table components ...
Updating field type name in table components ...
old: tinytext
new: varchar(64) not null
Adding indexes for products and components tables.
Fixing creation time on attachments...
Done - converted 58 attachments
Updating field type creation_ts in table attachments ...
old: timestamp(14)
new: datetime NOT NULL
Adding new field last_changed to table groups ...
Adding new field id to table groups ...
Adding new field refreshed_when to table profiles ...

WARNING - GROUPSET ACTIVITY ON BUG 388 CONTAINS DELETED GROUPS
Deleting unused field groupset from table profiles ...
Deleting unused field blessgroupset from table profiles ...
Deleting unused field groupset from table bugs ...
Deleting unused field bit from table groups ...
Converting attachment statuses to flags...
done.
Adding group admin ...
Removing paths from filenames in attachments table...
Done.
Resizing attachments.filename from mediumtext to varchar(100).
Updating field type filename in table attachments ...
old: mediumtext not null
new: varchar(100) not null
Removing shadowlog table
Updating field count in table votes ...
Reminder: Bugzilla now requires version 8.7 or later of sendmail.
[gerv at landfill bz16009]$