error when processing search index

More
11 years 1 month ago - 11 years 1 month ago #41072 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 1 month ago by gauthier.

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

More
11 years 1 month ago #41078 by ggppdk
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.

More
11 years 1 month ago #41084 by gauthier
FLEXIcontent version 2.0.3 beta2 r1686

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

More
11 years 1 month ago #41085 by ggppdk
Hello

yes,
this is fixed in v2.1.0 r1781

Regards


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

More
11 years 1 month ago #41117 by gauthier
I installed the last version and the problem is fixed.
Thanks.

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.329 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline