Hello everybody,
I am trying upgrade my OJS 2.3.7 to OJS 3.1.0. Firstly, I made an upgrade from OJS 2.3.7 to OJS 2.4.8, and all succeed without problem. Finally I tried to upgrade from OJS 2.4.8 to OJS 3.1.0 and I got the following error.
Both upgrading process were made using web upgrade function.
ojs2: DB Error: ERROR: relation “articles” does not exist\nLINE 1: …ELECT article_id, journal_id, review_file_id FROM articles W…\n ^, referer: http://localhost/ojspujcali/index.php/index/install/upgrade
I don’t know how i can resolve this problem, may you help me?
thanks!
Hi @Juan_Pablo_Giron_Rui
Is yout stack a LAMP or are you using a Postgress BD?
If it is your case, please read this thread:
Hello.
Thanks for the help.
I’ve managed to upgrade it successfully after chaging some coding in the upgrade script.
Here is the 2 patchs that corrects all the bugs i’ve found in the upgrade process from 2.4.4 to 3.1.
Corrects 3.0.0.0_upgrade.xml file:
--- /root/ojs-3.1.0/dbscripts/xml/upgrade/3.0.0_update.xml 2017-10-24 01:04:36.000000000 -0200
+++ dbscripts/xml/upgrade/3.0.0_update.xml 2017-10-30 10:38:30.228171132 -0200
@@ -87,19 +87,19 @@
<!-- issue #2506: the genre_id for 'article' …
Best,
Israel