user warning: Table 'xxx.contentanalysis_status' doesn't exist query: SELECT DISTINCT analyzer FROM contentanalysis_status in contentanalysis/includes/seo_friend.inc on line 31.

shows up on admin/reports/seo/contentalaysis

Comments

finex’s picture

finex commented

Probably the .install file should be updated in order to create that table.

TomDude48’s picture

TomDude48 commented

It is currently defined in hook_schema. Try uninstalling the module then reinstalling.

philsward’s picture

philsward commented

Just tried uninstalling and re-installing... no luck : (

I'm clueless to the programming side of things, but why is this commented in the .install file?

/*
CREATE TABLE IF NOT EXISTS `contentanalysis` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `last_analysis` int(11) NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `path` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `analyzers` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`aid`),
  KEY `nid` (`nid`),
  KEY `path` (`path`),
  KEY `url` (`url`)
)
*/

Also... shouldn't there be an ending php tag? (ie ?>)

kyletaylored’s picture

kyletaylored commented
Issue summary: View changes
Status: Active » Closed (outdated)