ADS Search DB: PDOException: Table doesn't exist.

[kenorb]

There are missing tables which are defined in ads_search_db.features.inc

      "search_api_language" : {
        "table" : "search_api_db_ads_adverts_search_api_language",
        "type" : "string",
        "boost" : "1.0"
      },
      "body:summary" : {
        "table" : "search_api_db_ads_adverts_body_summary",
        "type" : "text",
        "boost" : "0.1"
      },
      "body:value" : {
        "table" : "search_api_db_ads_adverts_body_value",
        "type" : "text",
        "boost" : "0.1"
      },

and these are not created when enabling ads_search_db module.

One way of reproducing is:

1. Enable search_api_db and search_api.
2. Search anything.
3. The error appears:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ads.search_api_db_ads_adverts_body_summary' doesn't exist

Or in some other places:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ads.search_api_db_ads_adverts_search_api_language' doesn't exist

Reverting feature seems to be temporary workaround.

So either we want to remove them from ads_search_db.features.inc or check why the module doesn't create them.

Could be related:

• Base table or view not found: 1146 Table 'ads.search_api_db_ads_adverts_title' doesn't exist drupal-modules/ads#25
• https://www.drupal.org/node/1347438 (Reverting Features Drops Search API DB tables)
• https://www.drupal.org/node/1349840
• https://www.drupal.org/node/2343371