[Admin]

Hướng dẫn cách khắc phục lỗi: Xf_search table doesn't exist in engine

Mở phpMyadmin chạy đoạn mã sau.

DROP TABLE IF EXISTS `xf_search`;
CREATE TABLE IF NOT EXISTS 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