Hello. Looking at the OJS version 3.3.0-8 database, I noticed that the same name (file_id) was used as the primary-key for 4 different tables (files,issue_files,library_files,temporary_files ). Also, still all these tables still use AUTO_INCREMENT. :scream: Although the literature usually suggests…

Hi @murilodbva , In OJS 3.3.0-8, submission_files.file_id should not be AUTO_INCREMENT, it’s a FOREIGN KEY referencing files.file_id. The other tables you mentioned earlier (e.g. temporary_files, library_files, issue_files) have their own file_id primary keys, and they are not related to submission…

molnart March 9, 2022, 9:24am 17

Yes, we’ve already done on 24 Feb: https://forum.pkp.sfu.ca/t/after-upgrading-to-3-3-0-8-error-500-on-trying-to-import-issues-articles-native-xml-plugin/72121

OJS 3308 - same name for primary-key in some tables