vb.org Archive - My searchcore table is missing...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - My searchcore table is missing... (https://vborg.vbsupport.ru/showthread.php?t=323863)

Phaedrus

11-13-2016 06:44 PM

My searchcore table is missing...

It just disappeared. Can anybody tell me a command string or something I can use to rebuild it then I can run a search index? Please tell me this is repairable!

Dave	11-13-2016 07:38 PM

If the table is literally gone then it might be a better option to restore it from a backup.
If you don't have any backups then I'm afraid you can't restore the contents of the table and you have to create the table without any contents.

Phaedrus

11-13-2016 07:42 PM

I don't mind creating that particular table with no contents. My backups are what I used to get this far...

--------------- Added [DATE]1479073433[/DATE] at [TIME]1479073433[/TIME] ---------------

I just need to know what I need to do to create that table. Once I am done reindexing the search should repopulate that particular table. It's one of the tables that is truncated when you do a rebuild of the search index.

Dave	11-13-2016 07:47 PM

So you only need the "searchcore" table and not "searchcore_text"?
This should work:

HTML 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

Phaedrus

11-13-2016 09:31 PM

That worked, site is not throwing a dbase error with each post and I am rebuilding the search index.

THANK YOU!

Lynne

11-13-2016 10:18 PM

I would suggest talking to your host about how this could have happened. Imagine if it happened to your user or post table. That would be very, very serious!

Phaedrus

11-13-2016 10:46 PM

Indeed. The innodb got corrupted then by backups were messed up... It took a while to figure out how to get as far as I did. It was quite annoying.

Paul M

11-14-2016 01:28 AM

I dont rely on host backups, I take my own.

Phaedrus

01-30-2017 03:27 AM

Quote:

Originally Posted by Paul M (Post 2578164)

I dont rely on host backups, I take my own.

my own were also compromised due to missing tables.

Paul M

01-30-2017 01:00 PM

Then you need to take a look at how you are taking them, you should not be missing any tables in a backup.

All times are GMT. The time now is 11:50 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01871 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_html_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: