I am getting this error when i try to index data.

I created a new "Denormalized index of content" added my fields (even tried with only 'Title' field but same error)

PDOException while trying to index item node-2701 on index Course Listing Grouping: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'node-2701' for column 'item_id' at row 1: INSERT INTO {search_api_db_course_listing_grouping} (search_api_language, item_id) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => und [:db_insert_placeholder_1] => node-2701 ) in SearchApiDbService->indexItem() (line 938 of /Users/St0iK/Development/-----/sites/all/modules/contrib/search_api_db/service.inc).

I have also tried using the latest dev version but still getting the same error.

Any ideas what might be wrong?

Thank you

Comments

St0iK created an issue. See original summary.

St0iK’s picture

St0iK commented
Issue summary: View changes
aperedos’s picture

aperedos commented

+1

wtcp83’s picture

wtcp83 commented

same issue, did you ever find a solution?

alex.87’s picture

alex.87 commented

+1

wesjones’s picture

wesjones commented

Obviously this is pretty old, but for anyone that lands here, this is because the module only supports a Solr backend. It does not support the default db backend provided out of the box with the search API module.