DBScript error upgrading from ojs 2.4.8-2 to 3.0.2

Software Support
1

Hi,

I am trying to upgrade from ojs 2.4.8-2 but I am getting the following error:

[code: Installer Installer::migrateCounterPluginUsageStatistics]
DB Error: ERROR: column “pkp_section_id” of relation “metrics” does not exist
LINE 1: …d, assoc_type, assoc_id, metric_type, context_id, pkp_sectio…
ojs2: DB Error: ERROR: column “pkp_section_id” of relation “metrics” does not exist
LINE 1: …d, assoc_type, assoc_id, metric_type, context_id, pkp_sectio…

Any suggestion?

Many thanks

2

Hi @atarix

Could you try to apply this patch and do the clean upgrade again: pkp/pkp-lib#2295 upgrade of old statistics to 3.x · pkp/ojs@fc73c76 · GitHub

Maybe another upgrade fix you would need: pkp/pkp-lib#2440 fix old default usage statistics migration · pkp/ojs@46f23b0 · GitHub

There are a few bug fixes since OJS 3.0.2 is released, thus it would be great if you could work with Git and used the current ojs-stable-3_0_2 branch, but…

Best,
Bozana

3

Hi @bozana

many thanks, I used the current branch you suggested and this problem is resolved but now i get another error that I’ve posted here

Regards
Giuseppe