Ojs 3.4 db problem

Where the stage “incomplete” string comes from in the database please? Which table, which column? Don’t find it. Quit urgent, thanks.

Hi @trace,

In OJS/OMP/OPS 3.4.0 and later, incomplete submissions will have a non-empty value in the submission_progress column in the submissions table. (For 3.3.0-x and prior, this was numeric; a non-zero value would indicate an incomplete submission.)

Regards,
Alec Smecher
Public Knowledge Project Team

thanks @asmecher . But what I do, when I want to have “review” there and not “incomplete” for example regarding submission 11660?

I guess I found it out. I have to delete the 0 values there.

UPDATE submissions
SET submission_progress = ‘’
WHERE submission_progress = ‘0’
AND stage_id <> 1;

1 Like