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 er…

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. A…

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] Could you suggest any other method or guidance to solve this problem? Thank you!

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

I am having this exact problem. Did you resolve it and if so how? Br/Fredrik

I also have the same problem. Has anyone solved it? Thanks Fulvio

I also have this same issue. I’ve searched the forum, yet to get a solution. Will be restoring to 3-3-0-14 and try again in another week.

If anyone has some insight and/or a solution to this please post.

Hi all, Can you confirm before running the upgrade script that there is no result for the following SQL query? SELECT * FROM scheduled_tasks WHERE class_name='PKP\\task\\ReviewReminder'; If you do get a result for that query, I wonder if this is due to an incorrect database restore after another …

PKP Community Forum

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

Software Support

Dinesh_P September 27, 2024, 4:24am 5

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