I am trying to create a new install, I am running w2k, apache 2.x, MySQL 4.1, all goes fine until the schema is being generated, I get the following failure on one table
Table xoops_avatar created.
Table xoops_avatar_user_link created.
Table xoops_banner created.
Table xoops_bannerclient created.
Table xoops_bannerfinish created.
Table xoops_block_module_link created.
Table xoops_xoopscomments created.
Table xoops_xoopsnotifications created.
Table xoops_config created.
Table xoops_configcategory created.
Table xoops_configoption created.
Table xoops_groups created.
Table xoops_group_permission created.
Table xoops_groups_users_link created.
Table xoops_image created.
Table xoops_imagebody created.
Table xoops_imagecategory created.
Table xoops_imgset created.
Table xoops_imgset_tplset_link created.
Table xoops_imgsetimg created.
Table xoops_modules created.
Table xoops_online created.
Table xoops_priv_msgs created.
Table xoops_ranks created.
Table xoops_session created.
Table xoops_smiles created.
Table xoops_tplset created.
Table xoops_tplfile created.
Table xoops_tplsource created.
Table xoops_users created.

Failed creating table xoops_newblocks.

Seems there is a problem in the sql, I changed the key name for mid to k_mid as follows

CREATE TABLE newblocks (
bid mediumint(8) unsigned NOT NULL auto_increment,
mid smallint(5) unsigned NOT NULL default '0',
func_num tinyint(3) unsigned NOT NULL default '0',
options varchar(255) NOT NULL default '',
name varchar(150) NOT NULL default '',
title varchar(255) NOT NULL default '',
content text NOT NULL,
side tinyint(1) unsigned NOT NULL default '0',
weight smallint(5) unsigned NOT NULL default '0',
visible tinyint(1) unsigned NOT NULL default '0',
block_type char(1) NOT NULL default '',
c_type char(1) NOT NULL default '',
isactive tinyint(1) unsigned NOT NULL default '0',
dirname varchar(50) NOT NULL default '',
func_file varchar(50) NOT NULL default '',
show_func varchar(50) NOT NULL default '',
edit_func varchar(50) NOT NULL default '',
template varchar(50) NOT NULL default '',
bcachetime int(10) unsigned NOT NULL default '0',
last_modified int(10) unsigned NOT NULL default '0',
PRIMARY KEY (bid),
## old key causing sql failure KEY mid (mid),
KEY k_mid (mid),
KEY visible (visible),
KEY isactive_visible_mid (isactive,visible,mid),
KEY mid_funcnum (mid,func_num)
) TYPE=MyISAM;