Hello!
I have upgraded my OCS from 2.3.3.1 to 2.3.5 and a Conference Director just found this issue. When we click on the "select reviewer" link in a submission page OCS gets the following:
DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 20- Code: Select all
Input Array does not match ?: SELECT DISTINCT u.user_id, u.last_name, ar.review_id, AVG(a.quality) AS average_quality, COUNT(ac.review_id) AS completed, COUNT(ai.review_id) AS incomplete, MAX(ac.date_notified) AS latest, AVG(ac.date_completed-ac.date_notified) AS average FROM users u LEFT JOIN review_assignments a ON (a.reviewer_id = u.user_id) LEFT JOIN review_assignments ac ON (ac.reviewer_id = u.user_id AND ac.date_completed IS NOT NULL) LEFT JOIN review_assignments ai ON (ai.reviewer_id = u.user_id AND ai.date_completed IS NULL) LEFT JOIN review_assignments ar ON (ar.reviewer_id = u.user_id AND ar.cancelled = 0 AND ar.paper_id = 3956 AND ar.stage = 2) LEFT JOIN user_settings s ON (u.user_id = s.user_id AND s.setting_name = 21) LEFT JOIN roles r ON (r.user_id = u.user_id) LEFT JOIN papers p ON (a.paper_id = p.paper_id) WHERE u.user_id = r.user_id AND r.sched_conf_id = 256 AND r.role_id =
Input Array does not match ?: SELECT DISTINCT u.user_id, u.last_name, ar.review_id, AVG(a.quality) AS average_quality, COUNT(ac.review_id) AS completed, COUNT(ai.review_id) AS incomplete, MAX(ac.date_notified) AS latest, AVG(ac.date_completed-ac.date_notified) AS average FROM users u LEFT JOIN review_assignments a ON (a.reviewer_id = u.user_id) LEFT JOIN review_assignments ac ON (ac.reviewer_id = u.user_id AND ac.date_completed IS NOT NULL) LEFT JOIN review_assignments ai ON (ai.reviewer_id = u.user_id AND ai.date_completed IS NULL) LEFT JOIN review_assignments ar ON (ar.reviewer_id = u.user_id AND ar.cancelled = 0 AND ar.paper_id = 3956 AND ar.stage = 2) LEFT JOIN user_settings s ON (u.user_id = s.user_id AND s.setting_name = 21) LEFT JOIN roles r ON (r.user_id = u.user_id) LEFT JOIN papers p ON (a.paper_id = p.paper_id) WHERE u.user_id = r.user_id AND r.sched_conf_id = 256 AND r.role_id =
Input Array does not match ?: SELECT DISTINCT u.user_id, u.last_name, ar.review_id, AVG(a.quality) AS average_quality, COUNT(ac.review_id) AS completed, COUNT(ai.review_id) AS incomplete, MAX(ac.date_notified) AS latest, AVG(ac.date_completed-ac.date_notified) AS average FROM users u LEFT JOIN review_assignments a ON (a.reviewer_id = u.user_id) LEFT JOIN review_assignments ac ON (ac.reviewer_id = u.user_id AND ac.date_completed IS NOT NULL) LEFT JOIN review_assignments ai ON (ai.reviewer_id = u.user_id AND ai.date_completed IS NULL) LEFT JOIN review_assignments ar ON (ar.reviewer_id = u.user_id AND ar.cancelled = 0 AND ar.paper_id = 3956 AND ar.stage = 2) LEFT JOIN user_settings s ON (u.user_id = s.user_id AND s.setting_name = 21) LEFT JOIN roles r ON (r.user_id = u.user_id) LEFT JOIN papers p ON (a.paper_id = p.paper_id) WHERE u.user_id = r.user_id AND r.sched_conf_id = 256 AND r.role_id =
Stack Trace:
File: /home/storage/4/c4/e6/cbce/public_html/congressos/classes/submission/trackDirector/TrackDirectorSubmissionDAO.inc.php line 716
Function: DAO->retrieveRange("SELECT DISTINCT u.user_id, u.last_name, ar.review_id...", Array(4), Object(DBResultRange))
File: /home/storage/4/c4/e6/cbce/public_html/congressos/pages/trackDirector/SubmissionEditHandler.inc.php line 450
Function: TrackDirectorSubmissionDAO->getReviewersForPaper("21", 3956, "2", Null, Null, Null, Object(DBResultRange), "name", Null)
File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/PKPPageRouter.inc.php line 177
Function: SubmissionEditHandler->selectReviewer(Array(1), Object(Request))
File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/Dispatcher.inc.php line 130
Function: PKPPageRouter->route(Object(Request))
File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/PKPApplication.inc.php line 170
Function: Dispatcher->dispatch(Object(Request))
File: /home/storage/4/c4/e6/cbce/public_html/congressos/index.php line 65
Function: PKPApplication->execute()
Thanks in advance for any help,
