|
Hi. I'm getting an error when trying to install v2.7.3 on a 1.5 Joomla site.
History: I installed it once, it didn't work - the categories got stuck. I unstalled it. Then when I tried to reinstall I got this msg:
JInstaller::install: SQL Error. DB function failed with error number 1050
Table 'jos_feedpost' already exists SQL=CREATE TABLE `jos_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` int(11) 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 NOT NULL DEFAULT '10', `fulltext` TINYINT( 1 ) NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL DEFAULT 'Not set', `posterid` INT NOT NULL, `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, `createddate` TINYINT(1) NOT NULL DEFAULT '0', `cutat` VARCHAR (40) NOT NULL, `showintro` tinyint(1) NOT NULL DEFAULT '1', `origauthor` tinyint(1) NOT NULL DEFAULT '0', `acgroup` INT NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Feeds and data for feed2post' AUTO_INCREMENT=1 ;
SQL =
CREATE TABLE `jos_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` int(11) 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 NOT NULL DEFAULT '10',
`fulltext` TINYINT( 1 ) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT 'Not set',
`posterid` INT NOT NULL,
`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,
`createddate` TINYINT(1) NOT NULL DEFAULT '0',
`cutat` VARCHAR (40) NOT NULL,
`showintro` tinyint(1) NOT NULL DEFAULT '1',
`origauthor` tinyint(1) NOT NULL DEFAULT '0',
`acgroup` INT NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Feeds and data for feed2post' AUTO_INCREMENT=1 ;
Component Install: SQL Error. DB function failed with error number 1050
Table 'jos_feedpost' already exists SQL=CREATE TABLE `jos_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` int(11) 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 NOT NULL DEFAULT '10', `fulltext` TINYINT( 1 ) NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL DEFAULT 'Not set', `posterid` INT NOT NULL, `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, `createddate` TINYINT(1) NOT NULL DEFAULT '0', `cutat` VARCHAR (40) NOT NULL, `showintro` tinyint(1) NOT NULL DEFAULT '1', `origauthor` tinyint(1) NOT NULL DEFAULT '0', `acgroup` INT NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Feeds and data for feed2post' AUTO_INCREMENT=1 ;
SQL =
CREATE TABLE `jos_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` int(11) 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 NOT NULL DEFAULT '10',
`fulltext` TINYINT( 1 ) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT 'Not set',
`posterid` INT NOT NULL,
`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,
`createddate` TINYINT(1) NOT NULL DEFAULT '0',
`cutat` VARCHAR (40) NOT NULL,
`showintro` tinyint(1) NOT NULL DEFAULT '1',
`origauthor` tinyint(1) NOT NULL DEFAULT '0',
`acgroup` INT NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Feeds and data for feed2post' AUTO_INCREMENT=1 ;
Can anyone tell me how to fix this?
-scott |
