Error get article after upgrading OJS 3.1.1.0 to 3.3.0.5

Software Support
1

After upgrading to OJS 3.3.0.5 and completing installation succesfully. The articles that I had previously published are not fully visible, only the first one is displayed, the ones that I upload now do not pass me, what can I do.

2

Hello - Could you please check your PHP error log for any related errors and share them with us?

3

Hello,
I upgraded my OJS from 3.3.0-3 to 3.3.0-5 and after that OJS only shows the first article in the table of contents of each issue. I tried to sort the articles by moving the second to the first and continue to show the first article.
This problem occurs with some issue that I imported before the update but that were displayed correctly.
I have been looking in the database and I do not find differences between imported articles and those entered using the workflow.

With the debug enabled I see some errors like this

Got error ’ Database query\nSELECT\tc.\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1121]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1121]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[909]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1135]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1135]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1135]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1135]PHP message: Database query\nselect , s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1135]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1410]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1135]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5678]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6927]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6928]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6929]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6930]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6931]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6932]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6933]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6934]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionSubject”,1048588,1135]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5679]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionDiscipline”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5680]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6935]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionLanguage”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5681]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionAgency”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5682]PHP message: Database query\nSELECT\tc.\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1135]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1135]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[923]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1120]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1120]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1120]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1120]PHP message: Database query\nselect , s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1120]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1391]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1120]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5603]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionSubject”,1048588,1120]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5604]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6685]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionDiscipline”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5605]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6686]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionLanguage”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5606]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionAgency”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5607]PHP message: Database query\nSELECT\tc.*\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1120]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1120]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[908]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1134]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1134]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1134]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1134]PHP message: Database query\nselect *, s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1134]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1409]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1134]PHP message: Database q

4

I agree, I have the same problem

1 Like
5

Hello,
I upgraded my OJS from 3.3.0-3 to 3.3.0-5 and after that OJS only shows the first article in the table of contents of each issue. I tried to sort the articles by moving the second to the first and continue to show the first article.
This problem occurs with some issue that I imported before the update but that were displayed correctly.
I have been looking in the database and I do not find differences between imported articles and those entered using the workflow.

With the debug enabled I see some errors like this

Got error ’ Database query\nSELECT\tc.\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1121]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1121]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[909]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1135]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1135]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1135]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1135]PHP message: Database query\nselect , s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1135]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1410]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1135]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5678]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6927]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6928]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6929]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6930]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6931]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6932]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6933]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6934]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionSubject”,1048588,1135]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5679]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionDiscipline”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5680]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6935]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionLanguage”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5681]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionAgency”,1048588,1135]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5682]PHP message: Database query\nSELECT\tc.\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1135]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1135]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[923]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1120]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1120]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1120]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1120]PHP message: Database query\nselect , s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1120]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1391]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1120]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5603]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionSubject”,1048588,1120]PHP message: Database query\nSELECT cve. FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5604]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6685]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionDiscipline”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5605]PHP message: Database query\nSELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = ?\n[6686]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionLanguage”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5606]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionAgency”,1048588,1120]PHP message: Database query\nSELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq\n[5607]PHP message: Database query\nSELECT\tc.*\n\t\t\tFROM categories c\n\t\t\tINNER JOIN publication_categories pc ON (pc.category_id = c.category_id)\n\t\t\tWHERE pc.publication_id = ?\n[1120]PHP message: Database query\nselect * from publication_galleys as g where g.publication_id in (?) order by g.seq asc\n[1120]PHP message: Database query\nSELECT * FROM publication_galley_settings WHERE galley_id = ?\n[908]PHP message: Database query\nSELECT * FROM submission_settings WHERE submission_id = ?\n[1134]PHP message: Database query\nselect * from publications as p where p.submission_id in (?) order by p.version asc\n[1134]PHP message: Database query\nSELECT * FROM publication_settings WHERE publication_id = ?\n[1134]PHP message: Database query\nselect locale from submissions as s where s.submission_id = ? limit 1\n[1134]PHP message: Database query\nselect *, s.locale as submission_locale from authors as a left join publications as p on a.publication_id = p.publication_id left join submissions as s on p.submission_id = s.submission_id where a.publication_id in (?) order by a.seq asc\n[1134]PHP message: Database query\nSELECT * FROM author_settings WHERE author_id = ?\n[1409]PHP message: Database query\nSELECT * FROM controlled_vocabs WHERE symbolic = ? AND assoc_type = ? AND assoc_id = ?\n[“submissionKeyword”,1048588,1134]PHP message: Database q

6

Hi @Frank_Enrique_Sanche and @mmartin,

The logs that you provide do not show errors. They only log the database queries that were performed.

Can I confirm: in both cases, you see the articles listed in the issue in the editorial backend. But in the published issue, you only see the first article. Is that correct?

Are either of you running custom themes? If you switch to another theme do the other articles appear?