To stay ahead of the competitive world and grow business in both social and monetary terms the corporate recruitment process is getting extremely exhaustive. On the other hand the organizations are hiring the recruitment agencies so that their work load is reduced and their resources are saved.

A recruitment company is one which brings the employers and the employee together. There are two types of employment agencies: public and private. It is a fact that talent is of no use until it is accompanied with opportunity and also what’s the use of such opportunities that are not accessible. This is the point where recruitment consultants come into picture. Recruitment consultants maintain a database of the job seekers which they match with the job description provided by the company. The aim of these agencies is to identify the potential candidates, shortlist and then arrange interviews for a better understanding of the candidate’s profile. After that hiring takes place on permanent basis or contractual basis.

Recruitment agents find people to fill all kinds of jobs, from temporary to full-time in a number of career fields. Whether a company needs employee at the executive level or at the managerial level recruitment agencies provide full fledge services. There are recruitment agencies which provide employment services within the country and also to employers abroad.

Today recruitment industry have grown so much that there is a constant competition to acquire the leading position. There are many top level India Recruitment Agencies in India which offer distinguished services providing end to end solutions which bridges the gap between the employers and the employees. Now let’s talk about the benefits of the recruitment consultants:-

• Reduces the work load of the organization
• Saving management time by interviewing only the top candidates
• Advice and guidance on career prospects

These agencies are often reliable and also cost effective. They are able to provide the most qualified candidate as per the requirement of the organization. Moreover these agencies do not charge anything from the candidate; instead they get paid from the company itself.

Comments

withinthreshold’s picture

Issue summary: View changes

Updating with message received on the resume search page.

mh86’s picture

Status: Active » Fixed

This has just been fixed in the recruiter features. Please check out the latest dev version of the recruiter features and revert your search api database server.

clashar’s picture

Do I need to re-install from beginning or just to change the some files?

mh86’s picture

Go to Configuration > Search and Metadata > Search API.
Then revert the DB server (if it is default, then clear cache). Afterwards re-index the content of the job and resume index.
That's it :-)

clashar’s picture

so no need to change any files)? this fix is only for fresh install?

mh86’s picture

ah, you need to get the latest code from http://drupal.org/project/recruiter_features (replace the recruiter features module)

clashar’s picture

ok, I changed code, done clear cache, revert DB server

then about re-indexing, I suppose I needed to disable and re-enable "Job search" and "Resume search" indexes?
I did so.

But then when I go to "Job search" I got:

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

mh86’s picture

hm, are all your search api servers and indexes in the default state?

clashar’s picture

Do you mean that I should revert "Job search" and "Resume search" indexes?
or maybe I should "Clear index" for them?

mh86’s picture

best you do both (originally I was referring to reverting of "Job search" and "Resume search" indexes + the DB server)

clashar’s picture

it's ok now, thank you!

Status: Fixed » Closed (fixed)

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

Ole Martin’s picture

Last dev-version, and what ever I do, I still have this error:

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
Moved

itivet’s picture

I have a fresh installation of recruiter and I have also the same error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_search_api_db_job_search_search_api_language' doesn't exist

how do you do to

revert "Job search" and "Resume search" indexes

and

Clear indexes

?

I'm not an expert user.
Thx

vinod.honey’s picture

Title: /search/job/ issues «Unknown field in filter clause: field_job_workflow_state». » /search/job/ issues «SQLSTATE[42S02]: Base table or view not found: 1146 Table 'recruiter.recruit_search_api_db_job_search_sea».
Version: 7.x-1.x-dev » 7.x-1.0-rc3
Status: Closed (fixed) » Active

Hi,

I am also getting same error SQLSTATE[42S02]: Base table or view not found: 1146 Table 'recruiter.recruit_search_api_db_job_search_sea.

I have taken latest version.

Pls. suggest.

Thanks,
Vin

ohayo’s picture

I had same issue. If you are using database prefix, some table name exceed 64 chars which is mysql limit and trigger problem.

Ole Martin’s picture

Tanks ohayo.
So I have to try with out prefix.

dasjo’s picture

Status: Active » Fixed

as stated in #15, a database prefix may cause table names exceed the max 64 characters.

dasjo’s picture

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

Issue summary: View changes

Minor changes

jerryvargheseint’s picture

Issue summary: View changes

Jerry Varghese has grown to become one of the stalwarts in professional recruitment solutions industry, Global Recruitment Agencies for Gulf Countries like Dubai, Saudi Arabia, UAE, KSA, Kuwait, Qatar, Oman, Bahrain, Recruitment Company, Recruitment Consultants.

sarath.rajan’s picture

I am getting the same issue for job searching. Added the latest version / dev version. But still getting the same issue. Please somebody help me..

iRex’s picture

I got the error message with a fresh install and I fixed it by clearing all caches as per suggestions above.

cshekhar’s picture

I got this error with fresh installation of recruiter-7.x-1.7 on Aug 15th, 2015. I am getting following error:

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

Please help to resolve this error.

Thanks.

ibraaheem’s picture

You probably have to manually create the table yourself.

I used this and it worked.

DROP TABLE IF EXISTS `search_api_db_job_search_search_api_viewed`;
CREATE TABLE `search_api_db_job_search_search_api_viewed` (
`item_id` bigint(20) NOT NULL,
`word` varchar(255) DEFAULT NULL,
`field_name` varchar(255) DEFAULT NULL,
`score` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;