OJS 3.4 migration :assoc_type column

Software Support
1

Describe the issue or problem
During the migration process from OJS 3.3.0-22 to OJS 3.4, in our original database, and particularly in the annoucement_type table, the assoc_type column exists. However, during the migration process, I receive the following error:

ERROR: Upgrade failed: DB: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'dois' already exists

In my case this table (dois) exists and empty.

I fixed the problem by deleting submission IDs that have DataCite information but are missing actual DOI records, by this two commands :

  • DELETE FROM submission_settings WHERE setting_name = ‘datacite::registeredDoi’ AND
    submission_id IN (/* list of problematic IDs */);
  • DELETE FROM submission_settings WHERE setting_name = ‘datacite::status’ AND submission_id IN
    (/* list of problematic IDs */);

After running the upgrade.php script again, the following error appears:

ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at.assoc_type'

Any suggestion ? Thank you.

What application are you using?
OJS 3.3.0-22

2

The issue is resolved.

I’ve just droped the dois table and continued the upgrade process.

Thank you.

3

This topic was automatically closed after 13 days. New replies are no longer allowed.