What would I need to do to build the table?
searchcore is missing from dbase
Collapse
This topic is closed.
X
X
-
Anybody? I would just need to manually build the table then rebuild search index, correct? I just need to know how many parameters, etc. that I would need and how to fill it out. Can anybody help?No, my site isn't about Motorcycle Maintenance... -
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