Sparklet73/ff-tcat

Fatal Error

Opened this issue · 2 comments

psegovias commented

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'socialtr_fftcat.tcat_search_saved_archive' doesn't exist' in /home/xxx/public_html/ff-tcat/capture/query_manager.php:730 Stack trace: #0 /home/xxx/public_html/ff-tcat/capture/query_manager.php(730): PDOStatement->execute() #1 /home/xxx/public_html/ff-tcat/capture/search/savedArchive.php(20): getSavedBins() #2 {main} thrown in /home/xxx/public_html/ff-tcat/capture/query_manager.php on line 730

Any idea how to fix it?

ninthday commented

Hi, @psegovias : This repository was forked from dmi-tcat for our research project. For some reason, we can't use chinese keywords in stream api. So, we add some tables in database to record our search bins, but we didn't put init sql statement in our code. Please execute the sql below, thx!

CREATE TABLE IF NOT EXISTS `tcat_search_saved_archive` (
`id` int(11) unsigned NOT NULL,
  `querybin_id` int(11) unsigned NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `origin_phrase` varchar(255) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime NOT NULL,
  `savedtime` datetime DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
psegovias commented

Nice! Thanks, now i get this:

"This capturing type is not defined in the config file"

When try to make a new bin capture.