Summarize feeds

[Ben_360fusion]

Hi,

I have installed this module and it is having a problem with the database. once installed it promts me to update the database in the extension manager, when i do it doesn't move back the the list of all extensions installed it stays on the update database page and added a drop table.


CREATE TABLE `tl_summarizeFeeds` (
`id` int(10) unsigned NOT NULL auto_increment,
`tstamp` int(10) unsigned NOT NULL default '0',
`resource` varchar(8) NOT NULL default '',
`newsArchives` blob NULL,
`calendar` blob NULL,
`title` varchar(255) NOT NULL default '',
`alias` varbinary(128) NOT NULL default '',
`description` text NULL,
`source` varchar(6) NOT NULL default '',
`letters` int(10) unsigned NOT NULL default '0',
`maxItems` smallint(5) unsigned NOT NULL default '0',
`language` varchar(32) NOT NULL default '',
`format` varchar(4) NOT NULL default '',
`feedBase` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Drop existing tables


DROP TABLE `tl_summarizefeeds`;

If i drop the table it still promts me to update the database with the new table.

If i update with the new table it throws this error:

Fatal error: Uncaught exception Exception with message Query error: Table 'tl_summarizefeeds' already exists (CREATE TABLE `tl_summarizeFeeds` ( `id` int(10) unsigned NOT NULL auto_increment, `tstamp` int(10) unsigned NOT NULL default '0', `resource` varchar(8) NOT NULL default '', `newsArchives` blob NULL, `calendar` blob NULL, `title` varchar(255) NOT NULL default '', `alias` varbinary(128) NOT NULL default '', `description` text NULL, `source` varchar(6) NOT NULL default '', `letters` int(10) unsigned NOT NULL default '0', `maxItems` smallint(5) unsigned NOT NULL default '0', `language` varchar(32) NOT NULL default '', `format` varchar(4) NOT NULL default '', `feedBase` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 thrown in D:\webservers\xampp\htdocs\360fusion\system\librar ies\Database.php on line 519

#0 D:\webservers\xampp\htdocs\360fusion\system\librar ies\Database.php(162): Database_Statement->execute()
#1 D:\webservers\xampp\htdocs\360fusion\system\module s\rep_client\RepositoryManager.php(407): Database->execute('CREATE TABLE `t...')
#2 D:\webservers\xampp\htdocs\360fusion\system\module s\rep_client\RepositoryBackendModule.php(125): RepositoryManager->update('database')
#3 D:\webservers\xampp\htdocs\360fusion\system\module s\backend\BackendModule.php(114): RepositoryBackendModule->compile()
#4 D:\webservers\xampp\htdocs\360fusion\system\module s\rep_client\RepositoryBackendModule.php(62): BackendModule->generate()
#5 D:\webservers\xampp\htdocs\360fusion\system\module s\rep_client\RepositoryManager.php(31): RepositoryBackendModule->generate()
#6 D:\webservers\xampp\htdocs\360fusion\system\module s\backend\Backend.php(162): RepositoryManager->generate()
#7 D:\webservers\xampp\htdocs\360fusion\typolight\mai n.php(99): Backend->getBackendModule('repository_mana...')
#8 D:\webservers\xampp\htdocs\360fusion\typolight\mai n.php(294): Main->run()
#9 {main}


Hope someone can help

Thanks
Ben

[thyon]

just check... there is a spelling mistake... the sql contains a uppercase character for the tablename, whereas the drop statement doesnt

[Ben_360fusion]

Wow, eyes of a hawk. I'll have a play.

Thanks
Ben