XF 1.5 xf_search table doesn't exist

click here

Active member
Hi guys,

So it looks like my xf_search table went missing, I tried restoring from a backup but it didn't get created.

Is there a standard procedure or code I need to recreate the xf_search table? Any guidance would be awesome!

Thanks!
 
Version XF 1.5.18

OK, got it fixed, just had to create the table again using the following...

CREATE TABLE xf_search (
search_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
search_results MEDIUMBLOB NOT NULL,
result_count SMALLINT UNSIGNED NOT NULL,
search_type VARCHAR(25) NOT NULL,
search_query VARCHAR(200) NOT NULL,
search_constraints MEDIUMBLOB NOT NULL,
search_order VARCHAR(50) NOT NULL,
search_grouping TINYINT NOT NULL DEFAULT 0,
user_results MEDIUMBLOB NOT NULL,
warnings MEDIUMBLOB NOT NULL,
user_id INT UNSIGNED NOT NULL,
search_date INT UNSIGNED NOT NULL,
query_hash varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (search_id),
KEY search_date (search_date),
KEY query_hash (query_hash)
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
";
 
Back
Top Bottom