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

davidote
Topic Author
Offline
Premium Member

10 years 3 months ago - 10 years 3 months ago #57617 by davidote

[BUG of MySQL version] Error table *_flexicontent_advsearch_index_field_* does not exist was created by davidote

Hi there,

When I edit an article and save it,, this error appears:

fcsjb_flexicontent_advsearch_index_field_13' doesn't exist SQL=DELETE FROM fcsjb_flexicontent_advsearch_index_field_13 WHERE item_id=9024

I've re-indexing all indexes.

Warm regards.

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 3 months ago - 10 years 3 months ago #57619 by micker

Replied by micker on topic Error table *_flexicontent_advsearch_index_field_* does not exist

hello
1 check your table and repair
2 check your flexicontent version ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

davidote
Topic Author
Offline
Premium Member

10 years 3 months ago - 10 years 3 months ago #57620 by davidote

Replied by davidote on topic Error table *_flexicontent_advsearch_index_field_* does not exist

Hi there

This table doesn't exist.

Flexiconent version is 3.0.8. Joomla: 3.4.4 The previous version installed was 2.2.1.

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 3 months ago - 10 years 3 months ago #57621 by micker

Replied by micker on topic Error table *_flexicontent_advsearch_index_field_* does not exist

try to reinstall it (like a simple update)

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

davidote
Topic Author
Offline
Premium Member

10 years 3 months ago - 10 years 3 months ago #57622 by davidote

Replied by davidote on topic Error table *_flexicontent_advsearch_index_field_* does not exist

I've tried installing the same package, but the error persists

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 3 months ago - 10 years 3 months ago #57623 by micker

Replied by micker on topic Error table *_flexicontent_advsearch_index_field_* does not exist

field13 exist ?

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

davidote
Topic Author
Offline
Premium Member

10 years 3 months ago - 10 years 3 months ago #57624 by davidote

Replied by davidote on topic Error table *_flexicontent_advsearch_index_field_* does not exist

Yes, afirmative.

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 3 months ago - 10 years 3 months ago #57625 by micker

Replied by micker on topic Error table *_flexicontent_advsearch_index_field_* does not exist

try to puge index and redo it

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

davidote
Topic Author
Offline
Premium Member

10 years 3 months ago - 10 years 3 months ago #57629 by davidote

Replied by davidote on topic Error table *_flexicontent_advsearch_index_field_* does not exist

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

Last edit: 10 years 3 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 3 months ago #57643 by ggppdk

Replied by ggppdk on topic Error table *_flexicontent_advsearch_index_field_* does not exist

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

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.