JInstaller::install: SQL Error

JInstaller::install: SQL Error. DB function failed with error number 1064

If you get this error when you try to install extensions in a Joomla 1.5.x site on a server using MySQL 5,
check this out.

I had this when trying to install eXtplorer 2.1 witch was installed since I moved from another server using older MySQL. However I had some problems with it and needed a re-install. I uninstalled the older version and then downloaded eXtplorer 2.1 v2.1RC5. When I tried to install it I got an error stating something like this....

JInstaller::install: SQL Error. DB function failed with error number 1064
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 35
SQL=CREATE TABLE IF NOT EXISTS '

"TYPE=MyISAM"

"ENGINE=MyISAM"