Unable to do a clean install

I purchased this very well designed template for a small project non-profit group. Using MAMP 2.01 I have tried to do a clean install of the HotStart Installation locally. After creating a new database with utf_general_ci collation, then starting the Joomla install process, I get the error below after entering the default info on the Database Configuration screen:

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`

I am also using MAMP on Mac and it works fine. Make sure that you have PHP 5 and MySQL 5 installed in MAMP (both are required). If not, please upgrade your MAMP.

A completely fresh install on my MacBook Pro, using MAMP Pro 2.0.1 (PHP 5.2.17 & MySQL 5.5.9) the same error above is what I receive when trying to use the HotStart Installation. Changing the collation does not change the error. Yes, Web Sharing is off.

I need this resolved as soon as possible.

On my iMac trying to install this template completely messed up 2 other SQL databases. Cannot work out how to resolve that problem either.

Please open file /installation/sql/mysql/sample_data.sql in plain text editor (like TextEdit in plain textmode, SHIFT+CMD+T).

Can you find this "ENGINE=MyISAM" or this "TYPE=MyISAM". Try to switch this part everywhere (Find and Replace). Save file and try installing again.

BTW, I have MySQL 5.1.44 and PHP 5.3.2. Also, try to switch to PHP 5.3 in MAMP preferences.

I followed your suggestion and got the same error with PHP 5.2.17, and then I changed MAMP PHP version to 5.3.6 and managed to get a bit further along in the process. Now I get 'Unable to connect to the database:Could not connect to MySQL'

What is going on? Should I go back to MAMP 1.9.4?

"Could not connect to MySQL" means that either DB host, DB name, DB user or DB pass are typed incorrectly during Joomla installation.