Upgraded and still error message

Can anyone please tell me why I keep getting this message?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `wa89g_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Thank you

Please try to change TYPE=MyISAM to ENGINE=MyISAM everywhere in file /installation/sql/mysql/sample_data.sql

Then re-run installer.

Milos.
Hello. I uploaded the template successfully to my Apache Server via Filezilla. No problem.
Attached is what I get which is nothing.

I also took a look at the "/installation/sql/mysql/sample_data.sql" and changing TYPE=MyISAM to ENGINE=MyISAM

TYPE=MyISAM: does not exist everything is ENGINE=MyISAM

Any more thoughts? It seems to be clearly the sql file and my local server. Attached is the server info. In additon the database with all the info in it looks good also.

Thank you very much for any help you can offer

Then do that replacement in
/installation/sql/mysql/joomla.sql

Worked like a charm. Thank you very very much