DROP TABLE IF EXISTS `wp_kstats_raw`;
CREATE TABLE `wp_kstats_raw` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`timestamp` datetime NOT NULL,
`ip` int(10) unsigned NOT NULL,
`url` varchar(1024) NOT NULL,
`referrer` varchar(1024) NOT NULL,
`user_agent` varchar(1024) DEFAULT NULL,
`os` varchar(255) DEFAULT NULL,
`browser` varchar(255) DEFAULT NULL,
`search_engine` varchar(255) DEFAULT NULL,
`search_terms` varchar(255) DEFAULT NULL,
`spider` varchar(255) DEFAULT NULL,
`feed` enum('','ATOM','COMMENT ATOM','COMMENT RSS','RDF','RSS','RSS2') DEFAULT NULL,
`user` varchar(255) DEFAULT NULL,
`preserved` enum('1') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `timestamp` (`timestamp`),
KEY `ip` (`ip`),
KEY `url` (`url`(255))
) ENGINE=InnoDB AUTO_INCREMENT=262808 DEFAULT CHARSET=utf8;
Thursday, March 13, 2014
Cannot find or open table wp_kstats_raw
This error usually occurs because the table has crashed or some other INNODB error. Usually its best to just recreate the table from scratch
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment