Hello there. Looks like I’m facing the same failure when upgrading as other users. There seems to be something wrong when upgrading from 2.X to 3.X PHP 5.6 Can someone help me? Here is the log from the upgrade. Code version: 3.1.1.2 Database version: 2.4.8.0 Latest version: 3.1.1.2 Da…

Anyone able to lend a hand here? I’m really stuck after trying almost everything that I saw in other posts.

I have. I’m running an update now after deleting all articles with null values in section_id. I’ve also applied the patch pkp/pkp#3783 consider supp files without file id in the migration by bozana · Pull Request #2009 · pkp/ojs · GitHub . But every upgrade on the DB takes 6-8 hours so it is a very t…

Yeah I know :smiley: It’s the changes to the metrics table that take time. So if you want to fast forward during a test, you could empty the metrics table before an upgrade test. (I have one installation I am preparing to upgrade to OJS3 that has over 100 journals and there is a single SQL in the …

What exactly the metrics table contains? the upgrade now finished with an different error (which is good!) [code: Installer Installer::migrateFiles] WARNING: Unable to find a match for “31350-35163-10-PB.html” in “dir/where/files/are/storedjournals/3//articles/31350/”. Skipping this file. WARNIN…

The metrics table has the journal statistics. Download count etc. Of course you want to have those in the final upgrade, but emptying that table during tests will make it a lot faster. The duplicate key errors are quite common. Check the tables that were processed during provideSupplementaryFilesFo…

That’s what I got, but thanks to the sql debug mode I can actually see what is duplicated :slight_smile: (mysql): INSERT INTO submission_supplementary_files (file_id, revision) VALUES (2147483647, 1) ----- 1062: Duplicate entry ‘2147483647-1’ for key ‘PRIMARY’ …

I’ve started upgrading without looking much into the actual OJS installation. I’ve decied to track down the duplicated entry and I found that we have maybe 1800 SPAM users with spammy submissions. Is there any practical way to delete the users and their submissions? I will most likely have to go …