I tried searching for this and couldn't find anything related. Im trying to update from 7.x-1.0-rc2 to 7.x-1.4. When I run the update I receive this error.

Update #7103
•Failed: DatabaseSchemaObjectDoesNotExistException: Cannot change the definition of field search_api_db_database_node_index.created: field doesn't exist. in DatabaseSchema_mysql->changeField() (line 454 of /home/shatcher/public_html/champion/includes/database/mysql/schema.inc).

Any and all help would be great.

Comments

drunken monkey’s picture

Issue tags: -Update #7103

It seems your data was inconsistent before the update, leading to this error. Do you index the node's "Date created" field? The Search API server thinks so and thinks it's indexed in the search_api_db_database_node_index.created column, but that column doesn't exist. I'm not really sure what could have caused that, though. Are you maybe using Features? Those are known to cause problems with this module.
In any case, unless you want to index historic dates (i.e., before ca. 1910), you can just skip that update without any negative side effects.

PS: It seems you (like many others – it's really easy to misinterpret) are confused by the "Issue tags" field. As the guidelines state, they aren't meant for free text tags related to the issue, but only for specific categorization purposes, usually by module maintainers.
So, if you aren't sure your current usage is correct, please just leave the field empty.

PI_Ron’s picture

I get this error also, yes we are using the features module.

drunken monkey’s picture

Version: 7.x-1.4 » 7.x-1.x-dev

Well, Features is a bit (or, very) broken, so it's no surprise you have problems there.
To avoid the problems, never revert the server after an update hook has run, and never update the server to an after-update state before the update has run. That just breaks the whole system.
However, I've been told that it's still how a lot of people do it, so I guess that can't be helped (in D7). So if someone provides a patch with a workaround for Features users, I'd commit that.

PatchRanger’s picture

EDIT: I was wrong, my issue is #2436341: Problem with search_api_db_update_7104 + updated features, I am going to use the patch from it.

kenorb’s picture

Same here, update is constantly failing:

search_api_db module

Update #7103
Failed: DatabaseSchemaObjectDoesNotExistException: Cannot change the definition of field search_api_db_default_node_index_created.value: field doesn't exist. in DatabaseSchema_mysql->changeField() (line 454 of /home/stgsreelec/public_html/includes/database/mysql/schema.inc).

Features are used on that site. I'm not familiar with the site to give more details why this happened, so just sharing.

Search API Db: Version: 7.x-1.5
Features: Version: 7.x-2.7