OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Wrong list of the submissions assigned to me

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

Wrong list of the submissions assigned to me

Postby primozs » Mon May 27, 2013 12:27 pm

Hello,

I have problems with getting listed all submissions in review assigned to me. If I go to User Home I see there are 4 submissions assigned to me:

4ToBeInReview.JPG
4ToBeInReview.JPG (38.48 KiB) Viewed 1504 times


When I click on the link to see the four submissions (in the line of Sections Editor) in the next page I see only one submission:

1inReview.JPG
1inReview.JPG (38.24 KiB) Viewed 1504 times


But If I go to all submissions and use search to find all submissions assigned to me I can see the four submissions properly:

SearchAssigendToMe.JPG
SearchAssigendToMe.JPG (61.88 KiB) Viewed 1504 times


Do you have any idea, why I don`t see the submissions assigned to me directly when I click on the link with four submissions in the User Home (in the line Section Editor)? As I understand there is something wrong.

I am using OJS 2.4.2.0

Thanks, Primoz
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Tue May 28, 2013 9:59 am

Hi Primoz,

Could you use the "debug" option in config.inc.php (warning: it's verbose, and will affect all users while it's enabled) to query the two situations:
  • Searching for all assigned submissions, in which you receive the correct list, and
  • Looking at your assigned queue, where you expect 4 submissions but only see 1
...and post the relevant SQL queries here?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Tue May 28, 2013 12:06 pm

Hi Alec,

It is very verbose, yes. I am posting complete WEB pages as there are too many statemens for me to find only requested SQLs. Hope you can find them.

Regards, Primoz
Attachments
OJS.zip
(395.77 KiB) Downloaded 29 times
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby primozs » Sat Jun 01, 2013 12:27 pm

Hi Alec,

Any news on this topic? Are you able to get appropriate SQL statements? If you need any more info, please let me know.

Regards, Primoz
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Mon Jun 03, 2013 2:35 pm

Hi Primoz,

Can you check in the Editor's "Submissions" page for the missing submissions to see whether the "Can Review" checkbox is flagged under the section editor's assignments?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Mon Jun 03, 2013 10:48 pm

Hi Alec,

I am sorry, but I don´t understand what to verify. Can you please give me some more details how to do it?

Regards, Primož
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Tue Jun 04, 2013 8:48 am

Hi Primoz,

Sorry, my request wasn't very clear. For one of the submissions that's only showing on one of the two lists:
  • As Editor, view the submission's "Summary" page
  • Under the "Editors" heading, find the assignment to the section editor who is having trouble viewing the submission
  • Check to see if the "Review" checkbox is checked
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Tue Jun 04, 2013 11:39 am

Hi Alec,

Thank you for the clarification. I will learn. Slowly :)

I have checked one problematic submission. The submission #35 (hm, fyi: On the problematic page, there is always only the submission #30, if this info helps). As you can see, it has the Review checkbox checked.

Regards, Primož
Attachments
SubmitSumm.JPG
SubmitSumm.JPG (45.41 KiB) Viewed 1410 times
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Wed Jun 05, 2013 10:14 am

Hi Primoz,

What do you get for the following SQL query?
Code: Select all
SELECT editor_id, can_edit, can_review FROM edit_assignments WHERE article_id=35 OR article_id=30;
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Sun Jun 09, 2013 10:51 am

Hi Alec,

Here is the output:

+-----------+----------+------------+
| editor_id | can_edit | can_review |
+-----------+----------+------------+
| 16 | 1 | 1 |
| 16 | 1 | 0 |
+-----------+----------+------------+


Hope it helps.

Regards, Primoz
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Mon Jun 10, 2013 9:33 am

Hi Primoz,

Try:
Code: Select all
UPDATE edit_assignments SET can_review=1 WHERE article_id=35;
It looks like that edit assignment was created when the editor was only a Section Editor, not a full Editor, and was assigned without review priveleges; subsequently the user became a full Editor but the assignment still didn't include Review. Another way to correct it would be to delete the editor assignment and re-create it.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Mon Jun 10, 2013 11:45 am

Hi Alec,

Thank you for help. Might be, that your diagnose is correct, partially. We indeed have played with the (section) editor assignments.

According to my limited understanding the suggested SQL statement would add review assignment to the article #35. Since I need that for all missing articles and not only one, I have looked the other suggested option.

I have tried and deleted the editor assignment and re-created it (via GUI). Unfortunately that has not changed anything. Still the same problem.

Even more: I am sure that we have submitted at least one article (the last one, # 37) when the editor has been both, the full Editor and the Section editor. If my conclusion is correct, then all the subsequent submissions from now on will have thus wrong assignments (the same as #37), right?

Regards, Primož
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Mon Jun 10, 2013 4:08 pm

Hi Primož,

After you deleted and re-created the assignment, did the in_review column (in the above query) change to 1?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Wed Jun 12, 2013 12:09 pm

Hi Alec,

Unfortunately it didn´t change. The output of the sql statement is the same.

Regards, Primož
primozs
 
Posts: 67
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Wed Jun 12, 2013 12:13 pm

Hi Primož,

Does manual correction of that row (i.e. by using an UPDATE statement to set can_review to 1) correct the submission list?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Next

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 4 guests