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.

Re: Wrong list of the submissions assigned to me

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

Hi Alec,

A bit too much for me :)

Can you please write down the whole sql statement, so I can enter it in the command prompt?

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

Re: Wrong list of the submissions assigned to me

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

Hi Alec,

A bit too much for me :)

Can you please write down complete SQL statement I can copy to the mysql prompt?

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

Re: Wrong list of the submissions assigned to me

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

Hi Primož,

I mean the one suggested above, for one submission, at this post:
viewtopic.php?f=2&t=10043#p39265

If that corrects one submission, it'll help me debug further.

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

Re: Wrong list of the submissions assigned to me

Postby primozs » Wed Jun 12, 2013 1:03 pm

Hi Alec,

Yes, the above SQL statement corrected the submission.

Now the two submissions are listed: #30 and #35.

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

Re: Wrong list of the submissions assigned to me

Postby asmecher » Wed Jun 12, 2013 3:41 pm

Hi Primož,

Hmm, there are still a few things here I'm not sure about. With one of the other submissions that's still not working, could you...
  • Query the current assignments:
    Code: Select all
    SELECT * FROM edit_assignments WHERE article_id=123;
    (with the article ID in place of 123)
  • Delete the assignment from the user interface, then run the above query again
  • Re-create the assignment from the user interface, then run the above query again
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8869
Joined: Wed Aug 10, 2005 12:56 pm

Re: Wrong list of the submissions assigned to me

Postby primozs » Mon Jun 17, 2013 12:51 pm

Hi Alec,

Please find the results bellow.
According to my limited knowledge the results look now OK. That is with the UI resetting everything works well this time. Even the submission appears on the list after resetting the assignement.
I don´t get it. I hope it is better with you :)

Regards, Primož

mysql> SELECT * FROM edit_assignments WHERE article_id=34;
+---------+------------+-----------+----------+------------+---------------+----
-----------+---------------------+
| edit_id | article_id | editor_id | can_edit | can_review | date_assigned | dat
e_notified | date_underway |
+---------+------------+-----------+----------+------------+---------------+----
-----------+---------------------+
| 20 | 34 | 16 | 1 | 0 | NULL | NUL
L | 2013-05-27 21:17:59 |
+---------+------------+-----------+----------+------------+---------------+----
-----------+---------------------+
1 row in set (0.00 sec)

Deleted assignment:
mysql> SELECT * FROM edit_assignments WHERE article_id=34;
Empty set (0.00 sec)

Re-created assignment:
mysql> SELECT * FROM edit_assignments WHERE article_id=34;
+---------+------------+-----------+----------+------------+---------------+----
-----------------+---------------+
| edit_id | article_id | editor_id | can_edit | can_review | date_assigned | dat
e_notified | date_underway |
+---------+------------+-----------+----------+------------+---------------+----
-----------------+---------------+
| 26 | 34 | 16 | 1 | 1 | NULL | 201
3-06-17 21:45:21 | NULL |
+---------+------------+-----------+----------+------------+---------------+----
-----------------+---------------+
1 row in set (0.00 sec)
primozs
 
Posts: 73
Joined: Tue Feb 05, 2013 7:07 am

Re: Wrong list of the submissions assigned to me

Postby asmecher » Mon Jun 17, 2013 2:24 pm

Hi Primož,

By my reading this may well resolve the problem. However, if I've misunderstood the cause and you see additional submissions coming in with the same problems, then see if you can provide more detail here about the process by which new submissions end up in this condition.

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

Re: Wrong list of the submissions assigned to me

Postby primozs » Mon Jun 17, 2013 10:25 pm

Hi Alec,

If I understand it correctly, we have to reassign editor role to all submissions with the problem to fix the past , while all new submissions should appear correctly.

That really solves the problem, I agree.

Thank you, Primoz
primozs
 
Posts: 73
Joined: Tue Feb 05, 2013 7:07 am

Previous

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 1 guest

cron