What would I need to do to build the table?
Announcement
Collapse
No announcement yet.
searchcore is missing from dbase
Collapse
This topic is closed.
X
X
-
Just an FYI, I used the following code, rebuilt it and was successful. I am now rebuilding the search index.
Code:CREATE TABLE searchcore ( searchcoreid INT UNSIGNED NOT NULL AUTO_INCREMENT, contenttypeid INT UNSIGNED NOT NULL, primaryid INT UNSIGNED NOT NULL, groupcontenttypeid INT UNSIGNED NOT NULL, groupid INT UNSIGNED NOT NULL DEFAULT 0, dateline INT UNSIGNED NOT NULL DEFAULT 0, userid INT UNSIGNED NOT NULL DEFAULT 0, username VARCHAR(100) NOT NULL, ipaddress INT UNSIGNED NOT NULL, searchgroupid INT UNSIGNED NOT NULL, PRIMARY KEY (searchcoreid), UNIQUE KEY contentunique (contenttypeid, primaryid), KEY groupid (groupcontenttypeid, groupid), KEY ipaddress (ipaddress), KEY dateline (dateline), KEY userid (userid), KEY searchgroupid (searchgroupid) ) ENGINE=MyISAM
No, my site isn't about Motorcycle Maintenance...
Comment
-
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment