[BUG of MySQL version] Error table *_flexicontent_advsearch_index_field_* does not exist

Yes, afirmative.

try to puge index and redo it

I clicked on empty the advanced indexing, but I get the same error:

1146 Table 'db.fcsjb_flexicontent_advsearch_index_field_13' doesn't exist SQL=TRUNCATE TABLE fcsjb_flexicontent_advsearch_index_field_13

Hello

this can because the table is corrupted / crashed

- please open phpmyadmin
and check if table exists, try to repair it or better delete it

- and then try to reindex

I've deleted all tables csjb_flexicontent_advsearch_* and I've copied an emty tfcsjb_flexicontent_advsearch_index table from another database.

I clicked on basic Re-Index and the progress bar is moving and ends correctly, but still empty fcsjb_flexicontent_advsearch_index table. When I click on Re-Index Avanced no flexicontent_advsearch_index_field_ table is created. The progress bar does not start.

Hello

test this:
go to fields manager and edit "categories" field,

- make sure that field is not marked as "advanced filterable" and then reindex

if the above does not work
the also make sure that the field is not marked as "advanced text searcharable" either and re-index