404 Not Found after upgrade from OJS 3.2.0-0 to OJS 3.2.0-2

Dear All,

We faced 404 error after upgrade from OJS 3.2.0-0 to OJS 3.2.0-2

We can view the main journal index and issue pages
Example URLs:
https://www.ajsrp.com/journal/index.php/jeps/index
https://www.ajsrp.com/journal/index.php/jeps/issue/view/253

But we can not view the articles or attachments
Example URLs:
https://www.ajsrp.com/journal/index.php/jeps/article/view/2291
https://www.ajsrp.com/journal/index.php/jeps/article/view/2343

We tested the quick submit plugin and we can view the newly added test article without 404 error
Example:
https://www.ajsrp.com/journal/index.php/jeps/article/view/2353

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

Thank you for your great and professional support

Dear asmecher
Plz help me

Hi @smart1900,

How were these previous submissions added to the system?

Regards,
Alec Smecher
Public Knowledge Project Team

Dear asmecher,

Thanks for the reply. They were added by quick submit plugin.

Hi @smart1900,

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

Here link after SQL query
https://www.ajsrp.com/journal/index.php/jeps/article/view/2353

Still - 404 Not Found ?!!

Hi @smart1900,

Hmm, there’s definitely a data problem there. What do you get for the following two queries?

SELECT current_publication_id FROM submissions WHERE submission_id=2353;

…and…

SELECT publication_id FROM publications WHERE submission_id=2353;

Regards,
Alec Smecher
Public Knowledge Project Team

SELECT current_publication_id FROM submissions WHERE submission_id=2353;

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0030 seconds.)


SELECT publication_id FROM publications WHERE submission_id=2353;

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0010 seconds.)

What are your recommendations to solve this problem, Plz?

Hi @smart1900,

I think you might be using the wrong submission ID. Where did you get the ID 2353?

Regards,
Alec Smecher
Public Knowledge Project Team

This is happening to me too.
I also used quick submit and I’m using version 3.2.1-1
http://periodicos.ufes.br/fernao/article/view/31388

no errors in the httpd log
What could be done to fix this situation?

att
Adriano Moreno

Hi,

The problem was related to PHP incompatibility and DB errors based on Quicksubmit after upgrade.

It was fixed by an OJS web developer and links are working well now

You may check URLs:
https://www.ajsrp.com/journal/index.php/jeps/index
https://www.ajsrp.com/journal/index.php/jeps/issue/view/253
https://www.ajsrp.com/journal/index.php/jeps/article/view/2291
https://www.ajsrp.com/journal/index.php/jeps/article/view/2343

You can find OJS web deveolers on Fiverr and Upwork.

Good Luck

Hi @Adriano_Jose ,

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.

Att,
Diego

1 Like

Hi all,

For the issue related to previewing unpublished content, see:

Regards,
Alec Smecher
Public Knowledge Project Team

3 Likes