Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
oglok CreditAttribution: oglok commentedHello,
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
Comment #2
recruitinggeek CreditAttribution: recruitinggeek commentedI 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.
Comment #3
oglok CreditAttribution: oglok commentedHi @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!
Comment #4
MaxMendez CreditAttribution: MaxMendez commentedIt 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.