Elcan Software

Upload component - Failed
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'ENGINE = MYISAM COMMENT = 'Feed2post options'' at line 7 SQL=CREATE TABLE `jos_feedpost_config` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `useiconv` TINYINT NOT NULL DEFAULT '1', `getwith` TINYINT NOT NULL DEFAULT '0', `insertadvert` TINYINT NOT NULL DEFAULT '1', `includelink` TINYINT NOT NULL DEFAULT '0' ) ENGINE = MYISAM COMMENT = 'Feed2post options';
SQL =

CREATE TABLE `jos_feedpost_config` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`useiconv` TINYINT NOT NULL DEFAULT '1',
`getwith` TINYINT NOT NULL DEFAULT '0',
`insertadvert` TINYINT NOT NULL DEFAULT '1',
`includelink` TINYINT NOT NULL DEFAULT '0'
) ENGINE = MYISAM COMMENT = 'Feed2post options';

i cant install the component - plz help i paid 7$ for this....

Dear supa, seems like your sql server is not mysql 4 or higher...try editing the feedpost.xml file inside the zip package and replace that query with this one:

Code:

CREATE TABLE `#__feedpost_config` ( `id` int(11) NOT NULL auto_increment, `useiconv` tinyint(4) NOT NULL default '1', `getwith` tinyint(4) NOT NULL default '0', `insertadvert` tinyint(4) NOT NULL default '1', `includelink` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Feed2post options' AUTO_INCREMENT=1 ;

The old query will have #_ as the prefix too, you should look for:

Code:

<query> CREATE TABLE `#__feedpost_config` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `useiconv` TINYINT NOT NULL DEFAULT '1', `getwith` TINYINT NOT NULL DEFAULT '0', `insertadvert` TINYINT NOT NULL DEFAULT '1', `includelink` TINYINT NOT NULL DEFAULT '0' ) ENGINE = MYISAM COMMENT = 'Feed2post options'; </query>

and replace that lines with the ones I gave you before, let's see if that works, if not, I'm afraid that feed2post needs mysql...won't work if you have any other sql server... Best regards, Mario

Just in case the first query also creates problems for you, here is the mysql 3.23 compatible query to replace that one:

Code:

CREATE TABLE `#__feedpost` ( `id` int(10) unsigned NOT NULL auto_increment, `published` tinyint(1) unsigned NOT NULL default '0', `feed_url` text NOT NULL, `created` timestamp NOT NULL, `sectionid` int(11) NOT NULL, `keywords` varchar(200) NOT NULL, `checked_out` int(11) NOT NULL, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `catid` int(11) NOT NULL, `validfor` tinyint(4) unsigned NOT NULL default '1', `advert` text NOT NULL, `autounpublish` tinyint(1) unsigned NOT NULL default '1', `frontpage` tinyint(1) unsigned NOT NULL default '0', `delay` tinyint(4) NOT NULL default '10', `fulltext` tinyint(1) NOT NULL default '0', `posterid` int(11) NOT NULL, `title` varchar(100) NOT NULL default 'Not set', `origdate` tinyint(1) NOT NULL default '1', `iframelinks` tinyint(1) NOT NULL default '1', `negkey` varchar(255) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Feeds and data for feed2post' AUTO_INCREMENT=1 ;

Best regards, Mario PS: If you can't do the mods on your own, contact me by mail using the contact us form and I'll provide you the modified files.