[OJS 3.3.0.8] spinner is spinning forever when when inviting auditors

Software Support
1

Hi everyone!
I would need assistance to solve this problem, when users select the reviewers of a job and want to assign it, the wheel spins endlessly without finishing the process and give the ok of assignment, as a result it happens that does not even start the email assignment to the reviewer.

This is the PHP log error:

[Fri Nov 12 03:23:05.247201 2021] [php7:error] [pid 3072:tid 140506650580736] [client 10.200.225.10:47696] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘v5oacotp625214tv9rfh6cua6v’ for key ‘sessions_pkey’ in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘INSERT INTO ses…’, Array)\n#3 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO ses…’, Array, Object(Closure))\n#4 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Ill in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: Effects of rutin on osteoblast MC3T3-E1 differentiation, ALP activity and Runx2 protein expression | European Journal of Histochemistry
[Fri Nov 12 03:23:05.247200 2021] [php7:error] [pid 3238:tid 140506650580736] [client 10.200.225.10:47698] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘v5oacotp625214tv9rfh6cua6v’ for key ‘sessions_pkey’ in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘INSERT INTO ses…’, Array)\n#3 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO ses…’, Array, Object(Closure))\n#4 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Ill in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: Effects of rutin on osteoblast MC3T3-E1 differentiation, ALP activity and Runx2 protein expression | European Journal of Histochemistry
[Fri Nov 12 03:23:05.248562 2021] [php7:error] [pid 3238:tid 140506684151552] [client 10.200.225.10:47692] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘v5oacotp625214tv9rfh6cua6v’ for key ‘sessions_pkey’ in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)\n#1 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘INSERT INTO ses…’, Array)\n#3 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO ses…’, Array, Object(Closure))\n#4 /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Ill in /var/www/vhosts/ejh.it/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671, referer: Effects of rutin on osteoblast MC3T3-E1 differentiation, ALP activity and Runx2 protein expression | European Journal of Histochemistry
[Fri Nov 12 06:11:39.789234 2021] [php7:notice] [pid 4664:tid 140506617009920] [client 10.200.225.10:33380] PHP Notice: Only variables should be assigned by reference in /var/www/vhosts/ejh.it/classes/oai/ojs/OAIDAO.inc.php on line 148
[Fri Nov 12 06:18:53.310279 2021] [php7:error] [pid 4846:tid 140506850858752] [client 10.200.225.10:40584] script ‘/var/www/vhosts/ejh.it/wp-login.php’ not found or unable to stat
[Fri Nov 12 07:32:50.439007 2021] [php7:notice] [pid 4730:tid 140506667366144] [client 10.200.225.10:34428] ojs2: 404 Not Found
[Fri Nov 12 07:46:53.858329 2021] [php7:notice] [pid 5385:tid 140506717722368] [client 10.200.225.10:49134] ojs2: 404 Not Found
[Fri Nov 12 07:58:46.277195 2021] [php7:notice] [pid 4730:tid 140506726115072] [client 10.200.225.10:33112] ojs2: 404 Not Found
[Fri Nov 12 08:01:16.414798 2021] [php7:notice] [pid 4730:tid 140506700936960] [client 10.200.225.10:36016] ojs2: 404 Not Found
[Fri Nov 12 08:01:17.170613 2021] [php7:notice] [pid 5560:tid 140506650580736] [client 10.200.225.10:36024] ojs2: 404 Not Found
[Fri Nov 12 08:01:19.536798 2021] [php7:notice] [pid 5002:tid 140506617009920] [client 10.200.225.10:36088] ojs2: 404 Not Found
[Fri Nov 12 08:01:20.235457 2021] [php7:notice] [pid 5002:tid 140506726115072] [client 10.200.225.10:36098] ojs2: 404 Not Found
[Fri Nov 12 08:01:22.047604 2021] [php7:notice] [pid 5560:tid 140506768078592] [client 10.200.225.10:36132] ojs2: 404 Not Found
[Fri Nov 12 08:01:22.800447 2021] [php7:notice] [pid 4730:tid 140506642188032] [client 10.200.225.10:36142] ojs2: 404 Not Found
[Fri Nov 12 08:07:29.967347 2021] [php7:notice] [pid 5492:tid 140506859251456] [client 10.200.225.10:42180] ojs2: 404 Not Found
[Fri Nov 12 08:30:28.081283 2021] [php7:notice] [pid 5792:tid 140506734507776] [client 10.200.225.10:43008] ojs2: 404 Not Found
[Fri Nov 12 08:37:52.502859 2021] [php7:notice] [pid 5912:tid 140506751293184] [client 10.200.225.10:51300] ojs2: 404 Not Found
[Fri Nov 12 09:05:35.608427 2021] [php7:error] [pid 6565:tid 140506859251456] [client 10.200.225.10:56548] PHP Fatal error: Uncaught Error: Call to a member function getFullName() on null in /var/www/vhosts/ejh.it/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php:453\nStack trace:\n#0 /var/www/vhosts/ejh.it/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php(139): ReviewAssignmentDAO->_fromRow(Array)\n#1 /var/www/vhosts/ejh.it/lib/pkp/classes/task/ReviewReminder.inc.php(134): ReviewAssignmentDAO->getIncompleteReviewAssignments()\n#2 /var/www/vhosts/ejh.it/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php(146): ReviewReminder->executeActions()\n#3 /var/www/vhosts/ejh.it/lib/pkp/plugins/generic/acron/PKPAcronPlugin.inc.php(257): ScheduledTask->execute()\n#4 [internal function]: PKPAcronPlugin->shutdownFunction()\n#5 {main}\n thrown in /var/www/vhosts/ejh.it/lib/pkp/classes/submission/reviewAssignment/ReviewAssignmentDAO.inc.php on line 453, referer: https://www.google.com/
[Fri Nov 12 09:17:09.080713 2021] [php7:notice] [pid 6565:tid 140506742900480] [client 10.200.225.10:44696] PHP Notice: Only variables should be assigned by reference in /var/www/vhosts/ejh.it/plugins/generic/formHoneypot/FormHoneypotPlugin.inc.php on line 204, referer: Reset Password | European Journal of Histochemistry
[Fri Nov 12 09:17:09.080767 2021] [php7:notice] [pid 6565:tid 140506742900480] [client 10.200.225.10:44696] PHP Notice: Only variables should be assigned by reference in /var/www/vhosts/ejh.it/plugins/generic/formHoneypot/FormHoneypotPlugin.inc.php on line 205, referer: Reset Password | European Journal of Histochemistry
[Fri Nov 12 09:59:08.064583 2021] [php7:notice] [pid 6428:tid 140506717722368] [client 10.200.225.10:40242] ojs2: 404 Not Found
[Fri Nov 12 10:01:34.548431 2021] [php7:notice] [pid 7182:tid 140506650580736] [client 10.200.225.10:44090] ojs2: 404 Not Found
[Fri Nov 12 10:02:21.687763 2021] [php7:notice] [pid 7182:tid 140506734507776] [client 10.200.225.10:45474] ojs2: 404 Not Found

do you have any suggestions to solve this problem?
Thanks!

Bye
Tiziano

2

Hi @Tiziano

That’s the problem. It appears that you have a review assignment record in your database that is no longer pointing at a valid user account. You’ll need to ask a developer to examine the database and look at the review_assignments table for reviewer_id records that are not valid user ids.

SELECT * from review_assignments WHERE reviewer_id NOT IN (SELECT user_id FROM users)

And then probably delete those records, or perhaps update them and point them at a user account belonging to a journal manager.

Best,
Jason

3

Hi @jnugent , thanks for the support, I did the SELECT on the DB and actually it displayed records with reviewer_id without associated user_id, I changed them with my user id, in the next days I will see if it still replicates the error to me.

Thanks
Bye
Tiziano

4

Solution: Repair Database

Cpanel - Mysql database - Repair Database.