Issue Upgrading from OJS 3.3 to OJS 3.4: Database Error with Duplicate Entry

Software Support
1

Hello,

I am currently upgrading my Open Journal Systems (OJS) installation from version 3.3 to version 3.4 following the instructions provided in this forum link. However, I am encountering an error during the database upgrade process.

The error message I am receiving is as follows:

A database error has occurred: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘PKP\task\ReviewReminder’ for key ‘scheduled_tasks_pkey’ (SQL: UPDATE scheduled_tasks SET class_name = PKP\task\ReviewReminder WHERE class_name = lib.pkp.classes.task.ReviewReminder)

It seems like there is a duplicate entry issue related to the scheduled_tasks table. I’m not sure how to resolve this problem or what steps to take next.

Has anyone else encountered this issue during their upgrade process? Any guidance or suggestions on how to fix this would be greatly appreciated.

Thank you!

2

Could you please check your database? Specifically, look at the scheduled_tasks table and see if there are any entries in the last_run column with the value “0000-00-00 00:00:00”. If so, I recommend updating these entries with valid dates. After making these changes, try running the update again.

Also, make sure to back up your database before making any changes or running the update.

3

Thank you for the suggestion. But the last_run_column has been recorded with the required date as you can see below the screenshot.

image
image753×387 50.9 KB

Could you suggest any other method or guidance to solve this problem?

Thank you!

4

Are there NULL values in the review_round_id column in the review_assignments table?

5

No all the records in the review_round_id column has value in the review_assignments table. Please see the attachment below.

image