Hi…
I was trying to make an update several times from version 2.4.5 to 3.0.2 but it was impossible. I was never able to update the database using the web script (I always got a blank page with error 500).
My query is … Can I install clean version 3.0.2 and import magazines loaded in version 2.4.5 in some way?
Thanks
Hi @dmeligeni,
A blank page and/or a 500 error almost always accompanies a log entry in your PHP error log. Check there for details.
Regards,
Alec Smecher
Public Knowledge Project Team
I tried again to make an update and these are the errors:
[18-Jun-2017 06:43:58 America/Chicago] PHP Warning: require_once(/home/revuntr/public_html/plugins/generic/usageStats/GeoLocationTool.inc.php): failed to open stream: No existe el fichero o el directorio in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
[18-Jun-2017 06:43:58 America/Chicago] PHP Fatal error: require_once(): Failed opening required ‘/home/revuntr/public_html/plugins/generic/usageStats/GeoLocationTool.inc.php’ (include_path=’.:/home/revuntr/public_html/classes:/home/revuntr/public_html/pages:/home/revuntr/public_html/lib/pkp:/home/revuntr/public_html/lib/pkp/classes:/home/revuntr/public_html/lib/pkp/pages:/home/revuntr/public_html/lib/pkp/lib/adodb:/home/revuntr/public_html/lib/pkp/lib/phputf8:/home/revuntr/public_html/lib/pkp/lib/pqp/classes:/home/revuntr/public_html/lib/pkp/lib/smarty:.:/opt/php54/lib/php’) in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
Alec, I do not understand what I have to do.
It is only to replace this code:
THIS: import(‘plugins.generic.usageStats.GeoLocationTool’);
FOR THIS: import(‘lib.pkp.plugins.generic.usageStats.GeoLocationTool’);
Because I replace the code in “classes/install/Upgrade.inc.php” but it still does not work.
Hi @dmeligeni,
After making that change, does the behavior change at all? Do you still get exactly the same error message?
Regards,
Alec Smecher
Public Knowledge Project Team
Now I see the following errors:
[19-Jun-2017 06:49:28 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 06:49:31 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 06:51:37 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.user_groups’ doesn’t exist
[19-Jun-2017 07:14:35 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 07:14:38 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 07:35:39 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 07:35:42 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 09:34:12 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.user_groups’ doesn’t exist
[19-Jun-2017 10:10:31 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.user_groups’ doesn’t exist
[19-Jun-2017 10:12:57 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.user_groups’ doesn’t exist
[19-Jun-2017 10:40:07 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.user_groups’ doesn’t exist
[19-Jun-2017 11:54:07 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 13:06:58 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 13:55:34 America/Chicago] PHP Warning: require_once(/home/revuntr/public_html/plugins/generic/pln/classes/tasks/Depositor.inc.php): failed to open stream: No existe el fichero o el directorio in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
[19-Jun-2017 13:55:34 America/Chicago] PHP Fatal error: require_once(): Failed opening required ‘/home/revuntr/public_html/plugins/generic/pln/classes/tasks/Depositor.inc.php’ (include_path=’.:/home/revuntr/public_html/classes:/home/revuntr/public_html/pages:/home/revuntr/public_html/lib/pkp:/home/revuntr/public_html/lib/pkp/classes:/home/revuntr/public_html/lib/pkp/pages:/home/revuntr/public_html/lib/pkp/lib/adodb:/home/revuntr/public_html/lib/pkp/lib/phputf8:/home/revuntr/public_html/lib/pkp/lib/pqp/classes:/home/revuntr/public_html/lib/pkp/lib/smarty:.:/opt/php54/lib/php’) in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
[19-Jun-2017 13:58:06 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 14:13:46 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 14:19:16 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 14:19:19 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
[19-Jun-2017 14:23:10 America/Chicago] PHP Warning: require_once(/home/revuntr/public_html/classes/tasks/ReviewReminder.inc.php): failed to open stream: No existe el fichero o el directorio in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
[19-Jun-2017 14:23:10 America/Chicago] PHP Fatal error: require_once(): Failed opening required ‘/home/revuntr/public_html/classes/tasks/ReviewReminder.inc.php’ (include_path=’.:/home/revuntr/public_html/classes:/home/revuntr/public_html/pages:/home/revuntr/public_html/lib/pkp:/home/revuntr/public_html/lib/pkp/classes:/home/revuntr/public_html/lib/pkp/pages:/home/revuntr/public_html/lib/pkp/lib/adodb:/home/revuntr/public_html/lib/pkp/lib/phputf8:/home/revuntr/public_html/lib/pkp/lib/pqp/classes:/home/revuntr/public_html/lib/pkp/lib/smarty:.:/opt/php54/lib/php’) in /home/revuntr/public_html/lib/pkp/includes/functions.inc.php on line 25
[19-Jun-2017 14:27:11 America/Chicago] ojs2: DB Error: Table ‘revuntr_ojs.submission_galley_settings’ doesn’t exist
Hi @dmeligeni,
All those “table doesn’t exist” messages are suspicious. When you try to upgrade, do you restore your database to its OJS 2.4.5 version before trying the upgrade again? You’ll also have to restore your files directory.
Regards,
Alec Smecher
Public Knowledge Project Team
I did the update to 3.0.2 and then I made the change in the code that indicated to me.
Would I have to do the code change in the file before updating?
Hi @dmeligeni,
Does the submission_galley_settings
table exist in your database? If not, I suspect the upgrade didn’t complete fully.
Regards,
Alec Smecher
Public Knowledge Project Team