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