Update Search API modules

Patch is attached!

search_api_db 7.x-1.0-rc3 was just released! Here are the release notes:

https://drupal.org/node/2100145

It includes a performance fix and adapts search_api_db to the fixes in search_api 1.8 mentioned above.

New patch attached!

The following Search API modules were recently released:

• search_api 1.9 - release notes
• search_api_solr 1.3 - release notes
• search_api_db 1.0 - release notes

Attached is a patch to upgrade to them!

One quick note: this will still need extensive testing before it can actually be committed to Panopoly. The upgrade process is not entirely clean from where Panopoly 1.0-rc5 is and the current Search API stuff. There was even specific mention of Panels in the search_api 1.9 release notes.

I actually have a confession to make: while I keep tracking these release, Panopoly Search is the one Panopoly module I don't personally use! However, I do plan to eventually give it a try.

search_api 1.10 and search_api_db 1.1 recently were released - here are the release notes:

https://drupal.org/node/2152787

https://drupal.org/node/2152819

Its all bug fixes and UI improvements. There is a known bug in search_api 1.10 and they say that a 1.11 is coming shortly.

Anyway, my disclaimer to this patch still stands! Some of the updates between what Panopoly is on and current aren't fully automatic updates, so we'll need to do extensive testing before comitting this.

Someone with more experience with the search stuff will have to do that - unfortunately, this is the one Panopoly module that I don't personally use. :-) @populist is going to work on some search stuff over the next couple of days, so maybe he'll be able to work on this!

New updates are out and a new patch is attached!

Here are the release notes:

• search_api - 1.11: https://drupal.org/node/2162611
• search_api_db - 1.2: https://drupal.org/node/2162623
• search_api_solr - 1.4: https://drupal.org/node/2162639 (Says this is the last release to support Solr 1.4 - I don't know how many Panopoly users are on that version but the next release will affect them)

Here is another untested patch to upgrade to the latest search_api releases. Again, this needs manual testing (especially upgrade testing) from previous sites using both search_api_db and search_api_solr.

Here are the release nodes:

• search_api - 1.12: https://drupal.org/node/2273125
• search_api_db - 1.3: https://drupal.org/node/2273131
• search_api_solr - 1.5: https://drupal.org/node/2273139

There have been a few new releases...

facet_api 1.5:

https://www.drupal.org/node/2305619

search_api 1.13:

https://www.drupal.org/node/2308061

So, this patch needs to be updated!

Here's a new version of the patch which does the updates mentioned in #11. I still tested it, but I'm working on a project that may allow me to (at least for database search).

@mrfelton: Awesome, thanks! I'm actually most worried about updates of existing sites, since the release notes for some of the releases led me to believe that updating wasn't fully automatic. :-/ Anyway, if you have any older sites you could test upgrading, that would be amazing. :-)

Ah, great! I'm also going to be updating some older sites (using the database, not solr) for a client project over the next week or so. I think we may be close to finally being able to commit this, close to the 1 year anniversery of this issue. :-)

Tested on a fresh install and was getting the following error when searching (via database search):

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'obdev-18.search_api_db_database_node_index_body_summary' doesn't exist

I think our export of the server and index need to be updated. I'll post a patch soon if I figure out a fix.

I rebuilt the database server/index and re-exported them, and now this is working on a fresh install! New patch is attached.

I'm going to test a migration from a super old version of Panopoly in a moment. However, we should probably test some upgrades from more recent version. It's a shame we don't have any tests for search, there's the beginning of some here: #2150047: Empty search should yield message "Enter your keywords", but that only tests error conditions. Here's a new issue for testing #2329387: Write Behat tests to ensure search works after install and provides facets

Did the upgrade test from super old Panopoly with database search. I had to re-index the content, but otherwise it worked! I think if I would have been patient, the content would have been re-indexed on cron anyway.

Here is a new version of this patch, updated for:

search_api_solr 1.6:

https://www.drupal.org/node/2334841

search_api_db 1.4:

https://www.drupal.org/node/2334849

This patch has gotten a lot of use on a client project and I think is almost ready to committed! I'd really like to do one more manual upgrade test from Panopoly 1.0-rc5, just to make double extra sure that the upgrade path is fine. I'm super excited to finally get this in - it only took over a year. :-)

This patch needs to be updated for search_api 1.14:

https://www.drupal.org/node/2398657

Looks like mostly bug fixes - the release notes don't sound like there should be anything problematic.

Alright, here's an updated patch. Also, I just did one last manual test upgrading from Panopoly 1.0-rc5 and everything worked great! I think it's finally time to commit this...

Committed!

Under some pretty crazy circumstances, I saw this error when updating a test site during search_api_db_update_7104():

Database Server: SQLSTATE[42S02]: Base table or view not found:  [error]
1146 Table 'XXX.search_api_db_database_node_index_text' doesn't exist in SearchApiDbService->fieldsUpdated() (line 684 of
/home/XXX/prj/panopoly/panopoly/modules/contrib/search_api_db/service.inc)

The solution was to disable panopoly_search, delete all the indexes, run the updates and then re-enable panopoly_search.

Honestly, I'm not sure if this was because of the patch that I'm testing or the weirdness I have on this test site or what. It might not happen for anyone else, but I'm adding a note here in case I need this for the release notes of the next release. :-)

EDIT: Possibly related issue: #1347438: Reverting Features Drops Search API DB tables

Heh, actually, that solution didn't work. Here's one that appears to have now:

1. Edit the index and set the Server to "< No Server >" and Save
2. Edit it again and set the Server back to "Database Server" and Save
3. Edit it AGAIN and enable it
4. Now, everything appears to be working fine

#27 worked for me! Although, I did do #26 first. Please try one of them and let us know what worked for you!

I've added an improved version of #27 to the release notes for Panopoly 1.16 in case anyone else comes across this problem:

https://www.drupal.org/node/2425263#special_instructions