I am upgrading an OJS 2.4.8 installation to OJS 3.1.1-2. The upgrade chokes on a supplement that has a remote URL
ojs2: DB Error: ERROR: null value in column "file_id" violates not-null constraint DETAIL: Failing row contains (2502, en_US, 2510, null, Data set, 1, http://..., 0).
We did a similar upgrade on the same database a few months ago without problems, and this article was added to the production 2.4.8 database between then and now. There is another file with id 2502 in the submission_files table (a pdf, so should not be related). Not sure if it’s the fact that it’s a remote that’s the problem, or if that’s just a coincidence.
The offending article was added through an import from another installation that we’re trying to merge before the upgrade to OJS3.
Update: Removing the offending supplement solves the issue. I guess something must have gone wrong in the import to 2.4.8?