By tomcatuk on

Hi - made the mistake of disabling the core comments module and it seems to have affected core search. Basically, after realising this and re-enabling the comments module, the comments table is missing. Any chance someone could post the SQL I would run to recreate the table? Not even sure this will fix the issue, but right now search results for a node that IS indexed by search spit out:

user warning: Table 'db.comments' doesn't exist query:

Verified in phpMyAdmin that the table is missing (Schema is quick to point this out as well of course).

Ta

⋅ Categories: Drupal 6.x

Comments

agarwal.sudhanshu’s picture

agarwal.sudhanshu commented

Find mysql query below for comments table. run this query in phpmy admin section.


-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `nid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `subject` varchar(64) NOT NULL DEFAULT '',
  `comment` longtext NOT NULL,
  `hostname` varchar(128) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `format` smallint(6) NOT NULL DEFAULT '0',
  `thread` varchar(255) NOT NULL,
  `name` varchar(60) DEFAULT NULL,
  `mail` varchar(64) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  KEY `pid` (`pid`),
  KEY `nid` (`nid`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Sudhanshu

tomcatuk’s picture

tomcatuk commented

Thanks Sudhanshu - you're a star ;)