WampServer

I am having error menssage when I tried to install Joomla 1.5.22_Stable_FullPack on WAMPServer 2.1c:

1 - in step 4, if password is blank, the error message is:

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
`jos_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`

2 - in step 4, if I fill with a password, the error message is:

Unable to connect to the database:Could not connect to MySQL.

It installed perfect on WAMPServer2.0. Is there any incompatibility of Joomla 1.5.22 and WAMPServer 2.1c?

Thanks for some help,

To setup Joomla on Wamp, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hi,
i had the same problem.
After following the steps described at JLBN open your sql file in the joomla installation folder, because here is the problem. The latest version of MySQL no longer supports

TYPE=MyISAM
rather it uses
ENGINE=MyISAM

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



Edited 2 time(s). Last edit at 01/09/2011 03:09PM by alemao59.

it doesnt work. any idea how to solve it?

@alemao59: Thanks! that worked! I searched a long time to find an answer to this problem, this is it.

I have spent most of this afternoon trying to get either JAMP or WAMP to run a Joomla install. Wished I had looked on here to start with, it would have saved me a lot of time. Thankyou!