error when processing search index

gauthier
Topic Author
Offline
Elite Member

11 years 2 weeks ago - 11 years 2 weeks ago #41072 by gauthier

error when processing search index was created by gauthier

error:

2200 / 2200 items You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END WHERE item_id IN ()' at line 1 SQL=UPDATE j25_flexicontent_items_ext SET search_index = CASE item_id END WHERE item_id IN () [7.54 secs] , INDEXING FINISHED. You may close this window

Do you know what is going wrong?

Last edit: 11 years 2 weeks ago by gauthier.

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

ggppdk
Offline
Administrator

11 years 2 weeks ago #41078 by ggppdk

Replied by ggppdk on topic error when processing search index

Hello

which FC version do you have?

if you don't have v2.1.0 r1781 then please upgrade

-- 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...

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