Server Information
Setting Name Setting Value
OS platform Linux
PHP version 7.2.26
Apache version Apache
Database driver mysqli
Database server version 5.6.41-84.1
I suspect this is due to a bug in earlier releases of the QuickSubmit plugin for OJS 3.2.0 that sometimes results in incorrect status flags being set on submissions. Try the following SQL query, replacing 123 with the ID of the submission you’re debugging:
SELECT s.submission_id, s.status, p.status
FROM submissions s
JOIN publications p ON p.publication_id = s.current_publication_id
WHERE s.submission_id = 123;
Regards,
Alec Smecher
Public Knowledge Project Team
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 seconds.)
SELECT s.submission_id, s.status, p.status FROM submissions s JOIN publications p ON p.publication_id = s.current_publication_id WHERE s.submission_id = 2353
This problem is occurring when an article is scheduled for publication and when it is time to “Preview” the issue and try to access the article, to check if everything is right before publication, you receive the error “404 Not Found”.
The problem disappears when you publish the issue, then you can view the article normally.
I believe that this is a strange behavior of the OJS, because the system should show the articles in the Preview, without giving the error.
I think @asmecher can help us with this strange behavior.
The problem happens when the STATUS column of the “submissions” and “publications” tables is equal to 5.