Hi,
I’m getting this error when I try upgrade ojs from 3.2.1.1 to 3.4.0.1, postgresql database:
2023-07-17 12:24:34 [migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2023-07-17 12:24:38 [migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2023-07-17 12:24:38 [migration: APP\migration\upgrade\v3_4_0\I7014_DoiMigration]
2023-07-17 12:24:39 [revert migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2023-07-17 12:24:39 [revert migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2023-07-17 12:24:43 [revert migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2023-07-17 12:24:43 [revert migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2023-07-17 12:24:43 [revert migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2023-07-17 12:24:43 [revert migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2023-07-17 12:24:43 [revert migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2023-07-17 12:24:43 [downgrade for “APP\migration\upgrade\v3_4_0\MergeLocalesMigration” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: SQLSTATE[42703]: Undefined column: 7 ERROR: column “id” does not exist
LINE 1: … “dois” (“context_id”, “doi”) values ($1, $2) returning “id”
^ (SQL: insert into “dois” (“context_id”, “doi”) values (61, 10.11606/issn.2316-9028.v1i1p1-39) returning “id”)
This table dois have no ‘id’ collumn, have one ‘doi_id’.
I imagine I have to change the name somewhere, but looking at the scripts I couldn’t find the exact location.
Regards,
Tarcisio Pereira