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.