XF 2.2 Can someone help me recreate a table in the xf database?

[Bonsai Coder]

My server host blew up my database, and they were able to recover everything but the table:

xf_find_new

What is the best way to go about creating this table and getting it repopulated?

 

[TPerry]

Have you tried to rebuild your master data?
I don’t know if that will work or not, but it’s worth the try.
yourdomain.com/install should get you there.

 

[nocte]

You can truncate that table. Here's the SQL to create it (maybe needs some adjustments depending on your system):

CREATE TABLE `xf_find_new` (
  `find_new_id` int UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `filters` mediumblob NOT NULL,
  `filter_hash` varbinary(32) NOT NULL DEFAULT '',
  `user_id` int UNSIGNED NOT NULL,
  `results` mediumblob NOT NULL,
  `cache_date` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

 

[Bonsai Coder]

Thank you all! I was able to get it resolved with special help from @AndyB

 

[Bonsai Coder]

You can truncate that table. Here's the SQL to create it (maybe needs some adjustments depending on your system):

CREATE TABLE `xf_find_new` (
  `find_new_id` int UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `filters` mediumblob NOT NULL,
  `filter_hash` varbinary(32) NOT NULL DEFAULT '',
  `user_id` int UNSIGNED NOT NULL,
  `results` mediumblob NOT NULL,
  `cache_date` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Thank you for this. Even though the problem has been fixed, I appreciate this code.