Colleagues,
We encountered the same bug in the modification of the order of sections inside an already published issue.
One of our journal editor created a new section and added it in an already published issue as a replacement of another section, it appeared that this new section came at the bottom of the Table of Content of the issue. Modifying the order was not possible.
We noticed in the “custom_section_orders” table that a new entry was not created as expected, preventing the reordering. We also noticed that the empty section was still present in that table.
We solved the problem with this little change on the database:
- go to the “sections” table to identify the “section_id” of the newly created section
- go to the “issues” table to identify the “issue_id” of the issue in which the new section appears
- go to the “custom_section_orders” table and add a new row with the “issue_id”, “section_id” found and give a greater number for the “seq” field than the others issue sections
If there is a section that is no longer used in the issue (this was our case) we don’t need to create the new row, we can simply update the row with the “issue_id” and “section_id” no more in use. After this creation or modification of the table “custom_section_orders”, it becomes possible to change the order in the admin interface again.
We also discovered that the addition of a new section in an already published issue, duely unpublished to make the change, didn’t create a new line in the table. So:
- the removal of a section doesn’t delete the entry in the database
- the addition of a new section doesn’t create a new entry in the database
Hope this helps to correct that bug.