| Joomla! http://forum.joomla.org/ |
|
| Joomfish beta cant be installed due to an error in mysql? http://forum.joomla.org/viewtopic.php?f=39&t=47297 |
Page 1 of 1 |
| Author: | Dan Stanley [ Fri Mar 17, 2006 5:09 pm ] |
| Post subject: | Joomfish beta cant be installed due to an error in mysql? |
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 |
|
| Author: | maxman [ Fri Mar 17, 2006 5:23 pm ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
I'm having the same problem...?  Update: Okay. Change the 'ENGINE' to 'TYPE'. This is from MySQL Manual: Quote: The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x series, but likely will be removed in the future.
|
|
| Author: | Dan Stanley [ Fri Mar 17, 2006 5:44 pm ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
Great:-) Is this done by phpadmin or what? /Dan |
|
| Author: | maxman [ Fri Mar 17, 2006 6:13 pm ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
Dan Stanley wrote: 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. |
|
| Author: | Dan Stanley [ Fri Mar 17, 2006 6:21 pm ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
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 |
|
| Author: | ivo.apostolov [ Fri Mar 17, 2006 8:24 pm ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
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 |
|
| Author: | akede [ Sat Mar 18, 2006 11:22 am ] |
| Post subject: | Re: Joomfish beta cant be installed due to an error in mysql? |
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 |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|