Reordering sections was done in the database, so they are displayed in the sections list correctly.
However, the sections are misplaced in the table of contents, and the Ordering within section configuration and Table of Contents isn’t working within the editors interface (I have multiple roles within multiple journals!).
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
I followed your instruction and it was a bit hard to identify the “section_id”, “issue_id” but I figured it out as shown in attached screenshot. It works!
second go to the url as in my screenshot on another browser
then right click on page to inspect, look for the same html tag and id
using this id in step 4, open the database table issues and add new row accordingly (read [claivaz] comment to see what to add, observe the record pattern to figure out that missing record).