Working on the recruiter distribution and while searching for Jobs, I am receiving the following error.

Everything else appears to be working fine with respect to user login creation, login authentication, resume creation, job creation etc.,.

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

Can any who saw this kind of a message before, review and let me know how to fix this error ?

Comments

billycheuk’s picture

billycheuk commented

Go to Configuration>Search and metadata>Search API and see if those three items in the column under 'CONFIGURATION' are all of 'Default'. If 'Overridden' shown, then click on respective arrows next to 'Edit' in the column under 'OPERATIONS' to 'Revert' them to 'Default'. Reindex.

billycheuk’s picture

billycheuk commented

Otherwise create such a table with phpMYAdmin, #1 item_id(Primary) Type-bigint(20) Null-No Default-None, #2 field_name(Primary) Type-varchar(255) Collation-utf8_bin Null-No Default_None, #3 word(Primary) Type-varchar(50) Collation-utf8-bin Null-No Default-None, #4 score(Primary) Type-int(10) Null-No Default-0, Storage Engine-InnoDB

billycheuk’s picture

billycheuk commented

Note: #2 field_name is actually unnecessary.