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!


oglok’s picture


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 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??


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:

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:


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


I didn't have time to investigate!!

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