When I updated search_api from 7.x-1.14 to 7.x-1.16, I couldn't completed the database update.

The warning is:

Table search_api_item_string_id already exists.

and this database update task doesn't go away.

CommentFileSizeAuthor
#5 search_api-check_table_exists-2569461-4.patch437 bytesmikhailkrainiuk
#4 search_api-2569461-4.patch437 bytesmikhailkrainiuk

Comments

skyredwang created an issue. See original summary.

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Category: Bug report » Support request

Try commenting out all code in that update function before running the update, or manually increasing the module's schema version in the system table by 1.

k2gsalem’s picture

k2gsalem commented

Rename the table name search_api_item_string_id to search_api_item_string_id1 or delete the search_api_item_string_id table
after update the database script.

mikhailkrainiuk’s picture

mikhailkrainiuk commented
Status: Active » Needs review
StatusFileSize
new search_api-2569461-4.patch437 bytes

Hello,

I fixed it with the patch: I check that the table exists.
Could you check this patch?

mikhailkrainiuk’s picture

mikhailkrainiuk commented
StatusFileSize
new search_api-check_table_exists-2569461-4.patch437 bytes

Sorry, I skipped description in patch name.
Fixed.

drunken monkey’s picture

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

I'm still unsure what could cause this problem, but I guess that workaround won't hurt in any case.
So, committed (after re-arranging the code a bit). Thanks!

Status: Fixed » Closed (fixed)

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