Joomla! Discussion Forums

Hi there,
Im trying to install the newly released Joomfish beta onto my working Joomla 1.08 installation.
I get this error concerning mysql.

SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=2' at line 10 SQL=CREATE TABLE IF NOT EXISTS `jos_languages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `iso` varchar(10) default NULL, `code` varchar(20) NOT NULL default '', `image` varchar(100) default NULL, `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2
SQL =

CREATE TABLE IF NOT EXISTS `jos_languages` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `iso` varchar(10) default NULL,
  `code` varchar(20) NOT NULL default '',
  `image` varchar(100) default NULL,
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2

Iv tried to install on a clean install and there it works fine.
That is joomfish works as expected, so its my online joomla thats causing the error.
what, why and where to change this in mysql???

/Dan

I'm having the same problem...?

Update: Okay. Change the 'ENGINE' to 'TYPE'. This is from MySQL Manual:

Great:-)
Is this done by phpadmin or what?

/Dan

Change that straight into the file "joomfish.xml" at the zip-package and install normally after that. Notice, that because the previous install failed, the files have been already copied to the server, so you have to delete them first (components/com_joomfish and administrator/components/com_joomfish). Otherwise you'll get an error.

Great Ill give it ago.
I know that I have to delete the already installed files, since iv done it a few hundred times already:-) It s anoying.

/Dan

I changed 3 instances of ENGINE to TYPE and its installed.

Thank you very much.

/Dan

Please remember this is a beta version and should not be used on production sites.

This problem will be fixed in the next release, which will be probably RC.

Greets

I've added this to our tracker. Not sure if Ivo fixed it already in the SVN but if not we will definitly remove this attribute.

Alex