Job search does not working at all.

It does not find any of the jobs I published. So I went to Search APIs to index all the items again and It says It couldn't index anything.

That's why I went to the log and there are some lines like this:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-formacion' for key 'PRIMARY'

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-tecnico' for key 'PRIMARY'

What can I do? It is a recent instalation of the distribution. I just deleted the fields collection of General Skills. Nothing more!

Please help!

Thanks a lot!

Comments

oglok’s picture

Hello,

I search around forums, mainly in Search API issues... and one solution for bad indexing was to Save again the Fields of the Search index.

In eRecruiter case, for Resume Search index...it worked, but not for Job Search index.

I think there are something wrong, bad handling of Database or something like that. I realized that if this field "Entity HTML output" is unchecked, the indexation process goes well...eventhough it is still not working.

Anybody that could help with this??

Thanks

recruitinggeek’s picture

I got this same error on the applicant side when testing the APPLY link, on the recruiter side, an email goes out to notify of the new applicant, but the link errors to a page that doesn't exist. It is almost as if the applicant resume doesn't register to the system at all.

oglok’s picture

Hi @recruitinggeek,

There is an issue about duplication of profiles:

http://drupal.org/node/1549224?no_cache=1360753321#comment-7034278

I don't understand what you mean, but I think that when you go to Resume profiles and click on one user's profile it goes to something like this:

/erecruit/resume/205

This is a URL that doesn't exist, this should be changed somewhere to put this:

/erecruit/es/profile-resume/205

I didn't have time to investigate!!

Please, if you change the piece of code... post it! It would be very useful!

Thanks!

MaxMendez’s picture

Issue summary: View changes

It is so long since this issue was reported, today i faced with it in a recruiter installation in my case the site is in spanish and i found that the errors happen because the accents.

In my case i changed the COLLATION of the column "word" in the "table search_api_db_resume_search_text" from utf8_general_ci to utf8_bin and the problem dissapear.

This is not the most elegenat solution but it could help some one.