searchcore is missing from dbase

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Phaedrus
    Senior Member
    • Jul 2006
    • 108
    • 4.2.5

    searchcore is missing from dbase

    What would I need to do to build the table?
    No, my site isn't about Motorcycle Maintenance...
  • Phaedrus
    Senior Member
    • Jul 2006
    • 108
    • 4.2.5

    #2
    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...

    Comment

    • Phaedrus
      Senior Member
      • Jul 2006
      • 108
      • 4.2.5

      #3
      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

      • Paul M
        Former Lead Developer
        vB.Com & vB.Org
        • Sep 2004
        • 9886

        #4
        Baby, I was born this way

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...