search

mycognitive / ads_features

Provides common features for ads distribution.
http://drupal.org/project/ads_features
1 stars 4 forks source link

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

Closed kenorb closed 9 years ago

kenorb commented 10 years ago

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: