|
Title: Installation Failure. Post by: Robert France on December 09, 2006, 06:57:07 PM Hi,
Trying to install this great looking component. I get the following SQL error. Code: SQL Error DB function failed with error number 1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 16 SQL=CREATE TABLE `jos_neoreferences` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `link` varchar(255) NOT NULL default '', `description` text NOT NULL, `catid` int(10) NOT NULL default '5', `image` varchar(255) NOT NULL default '', `thumb` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `online` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `front` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM SQL = CREATE TABLE `jos_neoreferences` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `link` varchar(255) NOT NULL default '', `description` text NOT NULL, `catid` int(10) NOT NULL default '5', `image` varchar(255) NOT NULL default '', `thumb` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `online` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `front` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM Any Ideas?? Package uploaded is com_neoreferences_1_2_1.zip Thanks Robert Title: Re : Installation Failure. Post by: Francois on December 10, 2006, 12:00:12 PM Hi Robert,
It's probably a problem with your mysql version. Try to replace "ENGINE=MyISAM" with "TYPE=MyISAM" on the install file. That's will be work :) Regards, François Title: Re : Installation Failure. Post by: Robert France on December 10, 2006, 07:09:13 PM Hi Francois,
Works a treat, many thanks ;D Robert
Powered by SMF 1.1 RC3 |
SMF © 2001-2006, Lewis Media
Joomla Bridge by JoomlaHacks.com |