PKP Bugzilla – Bug 8439
Journal Manager's reviewing interests search does not return results
Last modified: 2014-02-03 15:45:02 PST
*** Bug 8271 has been marked as a duplicate of this bug. ***
Fix JM's reviewer interest search
Additional fix for reviewer interest search
(In reply to comment #3)
> Additional fix for reviewer interest search
I applied this patch against (2.4.2) and I don't get results;
I tried also with 2.4.3 fresh installation and still the "reviewing interests search" does not return any result.
I found also that if you are an editor and try a "enrollSearch" (ie. when you search for an existing user to enroll as a reviewer) you still don't get results (in 2.4.2 or 2.4.3).
In PKPUserDAO.inc.php particularly in this function "getUsersByField" you have this string_query when a "review interest search" is performed:
SELECT DISTINCT u.*
FROM users u,controlled_vocabs cv, controlled_vocab_entries cve, controlled_vocab_entry_settings cves
WHERE cv.assoc_type = '4096' cv.symbolic ='interest'
AND cve.controlled_vocab_id = cv.controlled_vocab_id
AND cves.controlled_vocab_entry_id = cve.controlled_vocab_entry_id
AND LOWER(cves.setting_value) LIKE LOWER('%test%')
I think that the user_intersts table is missing, is it correct?
Ricardo, you're right -- it looks like at least in that one case a join is missing. Reopening.
Ricardo, try applying the additional patch:
...from the lib/pkp subdirectory; it should correct the problem.
Fixed manager's enrollment search for reviewer interests
Fixed manager's enrollment search for reviewer interests (master branch)