Hi, Once again, I would like to start with thanks to the developers for untiring efforts on OJS. There are similar titles related to task errors, and I examined them. Unfortunately, their comments did not help me. Origin of their error messages and their problem seems to be different. I have site…

Hi @rkhalikov , It looks like you have notifications that refer to nonexistent submissions. Could you try the following query? SELECT * FROM notifications n LEFT JOIN submissions s ON (n.assoc_id=s.submission_id) WHERE n.assoc_type=1048585 AND s.submission_id IS NULL; Simply deleting any resulting…

No results :frowning: MySQL returned an empty result set (i.e. zero rows). I tried to add one new paper (new submission). It works, I see 1 new task label, but list of tasks is not loading: [image] Requering SQL returned zero rows as well…

Hi @rkhalikov , Hmm, can you try: SELECT * FROM notifications n LEFT JOIN queries q ON (n.assoc_id=q.query_id) WHERE n.assoc_type=1048586 AND q.query_id IS NULL; Regards, Alec Smecher Public Knowledge Project Team

Hi @rkhalikov , Hmm, another hypothesis: SELECT s.submission_id, s.section_id FROM submissions s LEFT JOIN sections se ON (s.section_id = se.section_id) WHERE se.section_id IS NULL; Regards, Alec Smecher Public Knowledge Project Team

Hi @rkhalikov , OK, that’s definitely a data error, though I’m not 100% sure it’s the one that’s causing your tasks list to fail. Submission ID 13 is assigned to a nonexistent section. You’ll have to correct this in the database – update the section_id value of the submissions table for that row. R…

Can I just delete this entry (Submission ID 13)?

Hi @rkhalikov , Yes, if you don’t mind it disappearing from the record. Regards, Alec Smecher Public Knowledge Project Team

OK, I went another way. For a troubled journal, I recreated its sections. Then I mapped a problem article (Submission ID 13, what irony :wink: ) for a new section by editing submissions table. And the problem with tasks has disappeared! Now everything is working properly. Thank you very much for yo…

PKP Community Forum

Tasks not loading for certain users

Software Support

rkhalikov July 17, 2017, 9:15pm 15

Hmm, one result:

submission_id 13
section_id null