Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
drunken monkeyIt 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.
Comment #2
PI_Ron CreditAttribution: PI_Ron commentedI get this error also, yes we are using the features module.
Comment #3
drunken monkeyWell, 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.
Comment #4
PatchRanger CreditAttribution: PatchRanger as a volunteer commentedEDIT: 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.
Comment #5
kenorb CreditAttribution: kenorb commentedSame here, update is constantly failing:
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