Installation Failed 1.6r447

I tried to install the latest revision flexicontent for Joomla 1.6. During installation I get this error:

JInstaller: :Install: Error SQL 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 CHARACTER SET `utf8` COLLATE `utf8_general_ci`' at line 8 SQL=CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` ( `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`catid`,`itemid`), KEY `catid` (`catid`), KEY `itemid` (`itemid`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `#__flexicontent_cats_item_relations` (
`catid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`catid`,`itemid`),
KEY `catid` (`catid`),
KEY `itemid` (`itemid`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Where is the problem?

Database Version: 5.5.8-log
Database Collation: utf8_general_ci
PHP Version: 5.2.14
Joomla! Version: Joomla! 1.6.0 Stable [ Onward ]

Hi,

I think it is because you have mysql 5.5 and it no longer supports:

TYPE=MyISAM

so you need to change it to:

ENGINE=MyISAM

More Info:
forum.joomla.org/viewtopic.php?f=199&t=513155

I downloaded my database with akeebabackup that had flexicontent installed - and did these 4 steps:
1. Open the file JOOMLA\installation\sql\mysql\joomla.sql
2. Find all occuerences of TYPE=MyISAM
3. Replace with ENGINE=MyISAM
4. Save the file and try to install again

- so now I can view it.

I have yet to work out which files to change in Flexicontent...

Hope this helps,

Robert

hello
a new version is comming (see bug tracker)
regards

Dear iamrobert,

The steps provided in your given link is for Joomla installation.

For Flexi Content, you have to edit .sql files found in admin>installation directory.

Steps

1. Download installation zip file from this site.

2. Unzip to local disk

3. go to Admin>Installation

4. You can .Sql files over there..
install.mysql.nonutf8.sql
install.mysql.nonutf8.sql
update.sql


5. Replace TYPE=MyISAM with ENGINE=MyISAM
You can easily done it by using Replace option in editor..

6. Zip it again. (do not use rar format, as you cannot install from rar format in joomla)

7. Install it through joomla admin console.
Log in to Joomla admin Panel> Install/Uninstall>Choose new zip file> click on upload and install

8. Enjoy it! (i installed it successfully)


Best Regards

Nithin Prathapan

thanks !
becarfull it's a beta version for testing only