It sounds like an issue with your MySQL version and adding the table comment.
Before installing, open the com_404_redirect.zip archive file and click and edit the 404_redirect.xml file. Change this part (delete the comment='404 log' part):
<queries>
<query>
CREATE TABLE IF NOT EXISTS `#__404_log` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(100) default NULL,
`time` varchar(100) default NULL,
`referer_url` varchar(255) default NULL,
`requested_url` varchar(255) default NULL,
`redirected_url` varchar(255) default NULL,
`searchterm` varchar(255) default NULL,
`type` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='404 log';
</query>
</queries>
to
<queries>
<query>
CREATE TABLE IF NOT EXISTS `#__404_log` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(100) default NULL,
`time` varchar(100) default NULL,
`referer_url` varchar(255) default NULL,
`requested_url` varchar(255) default NULL,
`redirected_url` varchar(255) default NULL,
`searchterm` varchar(255) default NULL,
`type` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
</query>
</queries>
Then save it and try uploading and installing again.
Edit: I actually updated the main install file to take out that table comment. You could just download it one more time and try that file.
Let me know if that works.<br><br>Post edited by: davidwhthomas, at: 2006/12/21 00:15