Hi,
Trying to install this great looking component. I get the following SQL error.
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
Author