|
I'm getting the following error message when I try to install the esearch component:
SQL Error 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 ')' at line 18 SQL=CREATE TABLE `mos_tnr_esearch_conf` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) default '', `url` varchar(255) NOT NULL, `urlpre` varchar(255) default '', `queryword` varchar(40) default '', `pageword` varchar(40) default '', `countword` varchar(40) default '', `qtpl` text NOT NULL, `rtpl` text NOT NULL, `qpath` varchar(255) default '', `apath` varchar(255) default '', `rpath` varchar(255) default '', `csspath` varchar(255) default '', `configid` TINYINT(4) NOT NULL, `itemid` int(11), PRIMARY KEY (`id`), ) SQL = CREATE TABLE `mos_tnr_esearch_conf` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) default '', `url` varchar(255) NOT NULL, `urlpre` varchar(255) default '', `queryword` varchar(40) default '', `pageword` varchar(40) default '', `countword` varchar(40) default '', `qtpl` text NOT NULL, `rtpl` text NOT NULL, `qpath` varchar(255) default '', `apath` varchar(255) default '', `rpath` varchar(255) default '', `csspath` varchar(255) default '', `configid` TINYINT(4) NOT NULL, `itemid` int(11), PRIMARY KEY (`id`), )
I'm using Joomla 1.0.15, MySQL v. 5.0.51b
Any help would be appreciated.
|