The search indexer returns a mysql error

After hitting the button "Re-Index Basic (Content Lists)" I get this error and the index table is empty:

21900 / 21900 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 ___flexicontent_items_ext SET search_index = CASE item_id END WHERE item_id IN () [180.26 secs] , INDEXING FINISHED. You may close this window

How would I correct this error?

Cheers

Hello,

backup , update to r1742a and send me a PM with super admin login

i see that you have 21,000 items ?

I updated and sent you the credentials.

Yes, I have 21900 items (which are only dummies right now but will be real data soon).

The Advanced Indexer is doing okay, but the Basic one gives that error.

cheers

PS: the indexer displays the time taken to index, that time is highly incorrect, it definitely does not count seconds

Hello

the indexer does count seconds,
seconds of execution time

if indexer run via a single run and not via multiple AJAX calls the it would take that amount of time to complete,

e.g. it would take 180 seconds, but with multiple AJAX calls you may end up spending 400 more seconds in network delay to send AJAX request + get AJAX response + some small time to indexer display inside the browser

About error, the very last AJAX run of indexer, runs with ZERO items because you have exactly 21900 items a check needs to be added for this

Thanks for the explanation. Where do I switch the indexer to not use AJAX and therefore be faster?

Hello,

no just maybe we will add a parameter to configure a larger step,

and also add a descriptions about seconds to denote what it is