Describe the issue or problem
When inserting name in the search bar for Enroll an Existing User as Reviewer, php fatal error occurred and no result is display. only spinning wheel.
Steps I took leading up to the issue
Add reviewer
Enroll an Existing User as Reviewer
Search Name
What application are you using?
OJS 3.4.0.5, PHP 8.2, MariaDB 10.5
Would it be possible for you to execute this SQL query in your MariaDB:
select u.* from users as u
where u.disabled = 0 and exists (
select * from user_user_groups as uug
inner join user_groups as ug on uug.user_group_id = ug.user_group_id
where uug.user_id = u.user_id and ug.context_id in (1) and u.user_id not in (
select uug.user_id from user_user_groups as uug
inner join user_groups as ug on uug.user_group_id = ug.user_group_id where uug.user_id = u.user_id and ug.context_id in (1) and ug.role_id in (4096)
)
)
order by u.user_id asc;
To double check if this would lead to an error in MariaDB…
Please note that journal ID in the SQL = 1 i.e. context_id in (1), so that this number maybe need to be adjusted…
Oh, please wait just a little bit more – we found a better SQL and I will change the PR today, Once it is reviewed and merged I will let you know to apply the fix… OK?