Advanced Search and After Basic Index I get SQL error

I am trying to set up advanced search but get no advanced options.

When I try to do a Re-Index Basic, it apparently gets to the end but then reports:

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 q0lzy_flexicontent_items_ext SET search_index = CASE item_id END WHERE item_id IN ()

Re-index advanced complets with no errors.

Hello, this is in J1.5 ? right ? it has been reported and fixed:

you can test with with v2.0.3 beta
but remember this is beta.

code.google.com/p/flexicontent/downloads/list

Here is a list of changes:
#####
Fixes
#####
(1) Fixed issue in notification emails not showing new introtext/fulltext, and some improvements to texts of it (now include previous, next value for title & creator),
(2) Fixed issue in image field not being able to change already selected images via folder popup window, due to broken URL
(3) Fixed issue with sh404sef and itemid variable in fileselement/filemnanger (was renamed to u_item_id),
(5) Fixed issue with select/multiselect validation caused by jQuery Select2 library,
(6) Fixed issue with broken SQL in advanced search plugin for J1.5
(7) Fixed issue with "edit field value" (by ACL) not possible to enable in field configuration
( Fixed issue with subcategory images not showing for J2.5+
(9) Fixed issue with encoding of parameters in fields configuration saving JSON (now are saved as JSON), thus solving some problems like: multi-select parameter saving, and also allowing saving new lines in textarea
(10) Fixed issue with CORE field editing descriptions to properly load in item form (the view descriptions were loaded instead due to bug),
(11) Fixed issue with unwanted attempts to load non-existing language files for FC templates (now we check if language file exists),
(12) Fixed issue with Toolbar field to properly check if comments are enabled for a specific item,
(13) Fixed issue with image field in folder mode not opening image selector popup for existing images,
(14) Fixed issue with file field not displaying files in user selected order,
(15) Fixed issue with h2/h3 tags not being displayed inside TABs,
(16) Enhanced/Fixed validation process to be able to focus multiple nested TABs when invalid fields are detected, this included patching the groupmarker field,

########################
Enhancements / Additions
########################
(Minor)

---

(1) Added "Use Global" and "Empty Character" as separator for (category) filter list and subcategory list
(2) Added check during content item saving for duplicate alias (needed by SEF urls), appending the item id when this is detected
(3) Renamed Component parameters for loading JS Framework to be multiple radio variables to make easier to add future frameworks and also improved logic of loading of these,
(4) Removed display of 'draft' and 'pending-approval' states for normal publishers (since these states are normally reserved for non-publishers workflow), only super admin can now use them, added check if publishers can use 'trashed' and 'archived' states, also added optgroup to state field
(Medium)

---

(5) Added ordering "Most Commented" and "Best Rated" ordering to frontend listings (category, etc)
(6) Added in item form check if (content item) subscribers have already been notified once during current session and also if none subscriber exists
(Major)

---

(7) Enhanced frontend/backend item form to be (frontend item form customization parameters were updated)
- fully tabbed
- improved styling and giving it a more "professional look",
- more compacted and more responsive
( Enhanced Toolbar field to allow more powerful customization of AddThis Social Share Buttons via preconfigured code or via user-entered custom code

This is Joomla 2.5.11

Ok, tried this on the live site and did NOT get sql error after indexing. However, I still do not see any advanced options with the advanced search.

Are there parameters to turn on? I have advanced fields searchable and a couple filterable.

crr.ca/jupgrade/en/component/fle ... ask=search

Apparenlty I have installed a newer version thatn the latest officially stable release
Latest version: 2.0.1 r1659
Installed Version: 2.0.2 r1680
Release date: 2011-04-30

Hello,

the search parameters of FLEXIcontent search view are configured view the FLEXIcontent search Menu Item

Thank you so much! All coming together now.
I was searching in main options in vain.

We plan to add a default menu item in configuration for the cases that the current Joomla Menu item is not of type "Search" but is e.g. category or other

-- About filters, note that they are cached for a default of 15 minutes, so if e.g you added new values via changing filter configuration (e.g. you had a custom invalid query and you fixed it) then it is better to also clear cache ...