Last dev-version. (with last dev of recruiter_features-7.x-1.x-dev)

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

Comments

Ole Martin’s picture

Ole Martin commented

Any solution on this?

dasjo’s picture

dasjo
he/him
Primary language German
Location Zurich
commented

have you tried reverting the recruiter_search & recruiter_job_search features?

Ole Martin’s picture

Ole Martin commented

yes, don't help.

tolulope’s picture

tolulope commented
Version: 7.x-1.x-dev » 7.x-1.0

I can' run index on job search and recruiter search indexes using Database Search API. I am getting the error below.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'acerolajobs.com_db.acj_search_api_db_job_search_type' doesn't exist

Any ideas of what could be the problem?

I also get

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'acerolajobs.com_db.acj_search_api_db_job_search_search_api_language' doesn't exist
on the front page.

d.sentosa’s picture

d.sentosa commented

i have the same problem, any idea how to solve it?

dasjo’s picture

dasjo
he/him
Primary language German
Location Zurich
commented
Status: Active » Closed (duplicate)

i'm marking this as a duplicate of #1965212: Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.dr_search_api_db_job_search_search_api_language' doesn't e and hope we can find a good answer there

Harald.Winzer’s picture

Harald.Winzer commented

The name of the table is to long. With me it is p_search_api_db_job_search_search_api_language where I run into the same problem.
I used to have the Problem on a lot of tables so I shortened the Prefix tp p_.

Now I have this table as leftover