I'm having a problem where I can't index any items. I always get the following in dblog: An error occurred while trying to index items on index default_node_index: No field settings for index with id default_node_index.

On the workflow tab of the index when I enable (check) a processor on a field the setting isn't saved. I don't know if this is related? At a bit of a loss, done the usual cache clearing, deleting and recreating indexes and servers.

The only unusual thing about this install is that its using the Domain Access module. Any help greatly appreciated.

Comments

jaxxham’s picture

jaxxham commented

I'm having the same issue since updating, too.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Active » Fixed

The patch in #1308638-23: Reduce size of stored index settings should fix your problems.

jaxxham’s picture

jaxxham commented

Hi drunken monkey - I applied the patch but still no joy. Still getting "An error occurred while trying to index items on index node_index: No field settings for index with id node_index."

MrGeneric’s picture

MrGeneric commented

I also have this behavior when installing search api on fresh drupal install (even after the patch). It seems to work when I upgraded from an older version though*.

Edit: *Old indexes will reindex but I cannot index new ones

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Fixed » Active

Do you use the latest versions of the DB search module (which I assume you're using)?
I also assume that you do have some fields selected? With the latest dev version of the DB search module, see whether re-saving the „Fields“ form solves the issue.

Otherwise, please elaborate a bit further on your setup.

Ilbaboomba’s picture

Ilbaboomba commented

Same problem here, even after the patch in #2. Tried on 2 different servers, nothing changes.
Clean install of drupal + entity + search_api + search_api_db. created a new server (database server), new index, and when I try to index the nodes, it returns this error: "Couldn't index items. Check the logs for details."
In the log it says: "An error occurred while trying to index items on index default_node_index: No field settings for index with id default_node_index."

I got also this error (but I don't remember how to replicate this one): "SearchApiException: No field settings for index with id default_node_index. in SearchApiDbService->indexItems() (line 314 of /var/www/sites/all/modules/search_api_db/service.inc", so I'm thinking that the bug could be in search_api_db and not in search_api... hope this could help!

Thank you,
Alessandro.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented

Already figured that out half an hour before, but thanks for your detailled report!
Please see if the dev version of the DB search module solves the issue for you.

tanc’s picture

tanc
he/him
Primary language English
Location Italy
commented

I cloned the latest 7.x of db search module and downloaded latest dev of search_api and did a database upgrade but still have the same problem. I also deleted the index and the server and recreated but again the same message.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Active » Fixed

See #1313280-4: Adapt to new structure of index fields settings (and also use that issue for other such fields-settings problems with the DB search).

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

amaria’s picture

amaria commented

Still seeing this problem with the latest release of Search API and Search API Database. I tried with the default index as well just in case it was my custom index but that one gets this error too.

UPDATE: Fixed this by setting the changed field in {search_api_item} to 0 (from -1) for all items.

ralf.strobel’s picture

ralf.strobel commented

I also encountered this problem after upgrading to 7.x-1.0 (Database Search 7.x-1.0-beta2). It disappeared after I removed and re-added all fields from the index. Something obviously still doesn't get upgraded right.

EDIT: More precisely, it were taxonomy relation fields (fulltext on term name) that I had to remove and add again.

In the process I also got this message once: "Invalid argument supplied for foreach() in SearchApiDbService->fieldsUpdated() (line 227 of /var/www/dfuze/sites/all/modules/search_api_db/service.inc)."