Upgrade from OJS 2.4.7 to 3.0.1 fails

Software Support
18

Hi all,

Thanks for your patience. I’ve wrangled through @Oberdan’s database dump and it appears that there is a data error in the OJS 2.4.x data: some of the articles don’t have a valid section.

To check for articles in this situation, run the following in your database:

SELECT a.article_id FROM articles a LEFT JOIN sections s ON (a.section_id = s.section_id) WHERE s.section_id IS NULL;

This will generate a list of article IDs for which a section is needed. You can either go in via the OJS 2.4.x workflow and assign them, or you can edit the database directly. (If working with the database directly, make sure that the section_id you use belongs to the journal the submission is in.)

Once you’ve corrected the data error, take a fresh backup of the database and files area and try the upgrade again.

Regards,
Alec Smecher
Public Knowledge Project Team

2 Likes