A few days ago as a result of upgrading WAMP (to WAMP 2.1e) we were stuck for a few minutes with Joomla  1.5.22  installation. All went well until we hit the next button after filling  the database information. Where it gave a SQL error as below.

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’ at line 29 SQL=CREATE TABLE `xxx_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default ’0′, `type` varchar(90) NOT NULL default ‘banner’, `name` TEXT 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(150) 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`) )

Thanks to Joomla forums (http://forum.joomla.org/) and Google, we were able to find a solution.

The fix

Modify the joomla.sql file in the “installation” folder and replace TYPE with ENGINE.

TYPE

replace it with

ENGINE

Simple as that! Untill we meet with another blog, Cheers!