I installed Recruiter on a test site today. After testing the applicant registration (the first data I entered) I receive the following error:

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

I also get:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.dr_search_api_db_resume_search_changed' doesn't exist: DELETE FROM {search_api_db_resume_search_changed} WHERE (item_id IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 1 ) in SearchApiDbService->deleteItems() (line 552 of /mysite/modules/search_api_db/service.inc).

I am new to Drupal and have very little experience with coding. What should I do to correct this?

Thanks

Comments

jojordan’s picture

jojordan commented

Same issue on 10 April 2013. Simply downloaded and installed from the Recruiter module page on Drupal.

jojordan’s picture

jojordan commented

Update - I was tired when I looked at this so I am not quite sure what "worked" - but try clearing your caches.

You said you were new to Drupal? So go to the top right and drop down list there. Clear all caches. Wait a bit for a reply. See if the error message has gone.

jojordan’s picture

jojordan commented

Update - I was tired when I looked at this so I am not quite sure what "worked" - but try clearing your caches.

You said you were new to Drupal? So go to the top right and drop down list there. Clear all caches. Wait a bit for a reply. See if the error message has gone.

dasjo’s picture

dasjo
he/him
Primary language German
Location Zurich
commented

this is likely a problem with a feature being detected as overridden.

as stated, please try clearing caches, revert any overridden features and report back if this fixes your issue

karin71’s picture

karin71 commented

Thank you for the reply. I did all of the above, twice, but the error persists.

3 of the recruiter features are overridden, but I can't get it to revert. Should I re-install the features?

dasjo’s picture

dasjo
he/him
Primary language German
Location Zurich
commented

can you reproduce this problem with a clean installation?

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 to p_.

Now I have this table as leftover

mh86’s picture

mh86 commented
Status: Active » Fixed

This has been fixed in the Search API DB module, see #1214846: Table names might be too long for PostgreSQL.
The problem seems to be cause by PostgreSQL's 63 bytes table name limitation.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.