Error Table 'ppp_flexicontent_advsearch_index_field_nn' doesn't exist

After upgrade from v2.XX to 3.09rc6 I have to validate some new settings.

I always have 1 - field(s) have a 'dirty' property: (Search View 'Text Searchable OR Filterable') . Please recalculate the -ADVANCED- Search Index NOW!
But when I click nothing ... still waiting at 0%


When saving a new article I have an error
Table 'xxxx_flexicontent_advsearch_index_field_50' doesn't exist SQL=DELETE FROM xxxx_flexicontent_advsearch_index_field_50 WHERE item_id=1014

Hello

can you open database in phpmyadmin
and check if the table exist and click to repair it ?

I have a table named xxxx_flexicontent_advsearch_index
but the error message says xxxx_flexicontent_advsearch_index_field_50

I compare with another DB when I migrate from 2.X to 3.08 and then to 3.09rc6
I have 2 table
named xxxx_flexicontent_advsearch_index
and
named xxxx_flexicontent_advsearch_index_field_61

So there s probably a problème when upgrading directly to 3.09 from 2.X ?
I don't know how you organised your tables but it seems curious to have a table followed by a field name

I open and save the field_50 and remove all search filter values to No
then the errror is gone.

Probably the value was not really set.

Hello

1 more time this was reported, and the site worked properly on different server
- the TABLE is created if it does not exist

question if you make field 50 to be advanced searchable again, does the error reappear ?

in this other case, I cannot change field advanced filter settings to No