Thanks @ctgraham.
I did find out now location is “opt/lampp/logs/php_error_log”.
Using your suggested commands.
When i saw, I found that there are some database connection errors.
I will investigate and update here about my progress.
Thanks,
Jnana.
Thank you so much @ctgraham with your valuable suggestions i could finally able to port to OJS-3.1.2-4. In the process i did come across few errors but i was able to fix those my myself. However i am still facing some issues.
Note: It’s a multijournal OJS website.
What went successful
What went wrong
Logging in to any user(including admin) it’s getting toomuch slow and even after logged in the slowness remains while doing any operations like accessing a article, issue.
Logging in to any user giving a error message like below(PFA)
When i open the page with localhost/journal again it gives me below page(PFA)
It doesn’t look like a default theme home page.
Going in to Dashboard gives me below page(PFA).
Here all the options like Submissions, Issues, Payments, Settings, Users&Roles, Tools etc…
have disappeared.
Apart from above mentioned issues i am also facing a text clipping from left side when i open a article.
What is log file name which i can refer if something goes wrong on UI side like what i have mentioned above ?
There are few more but i want to fix these first.
@ctgraham please help me.
Regards,
Jnana.
Logging in to any user(including admin) it’s getting toomuch slow and even after logged in the slowness remains while doing any operations like accessing a article, issue.
One first guess: is the machine where it is installed able to access the internet without a proxy? If an outbound internet connection is not available you would get timeouts when checking for software updates, etc.
Logging in to any user giving a error message like below(PFA)
Were you able to capture the output of the upgrade process? Did that output have any errors or warnings? A lot of data is moved and migrated during the upgrade, so we’ll want to be sure all of that was successful.
When i open the page with localhost/journal again it gives me below page(PFA)
It doesn’t look like a default theme home page.
This is an access denied message, but it is also missing any public styling, so there are two problems here. For the access denied issue, let’s start with any messages from the upgrade process. For the styling issue, let’s look at the UI logs (coming below).
Going in to Dashboard gives me below page(PFA).
Here all the options like Submissions, Issues, Payments, Settings, Users&Roles, Tools etc…have disappeared.
In the upper left, is the link there a dropdown identifying your Site and each Journal? Do the available options change depending on which context you select?
Apart from above mentioned issues i am also facing a text clipping from left side when i open a article.
This sounds like a CSS issue. More information in the UI logging.
What is log file name which i can refer if something goes wrong on UI side like what i have mentioned above ?
The PHP error log (which you have already found) will have useful information for each server-side error. You will get additional context for these if you turn on show_stacktrace in config.inc.php. For browser errors (e.g. javascript or failed requests), you can have your browser log the requests made. To do this use the browser’s “Inspector” mode by pressing “F12”. The tool will have a “Console” tab which will record javascript errors and a “Network” tab which can be used to capture network traffic.
This will be most interesting in seeing if you get 404 or 500 errors when fetching resources like javascript files and CSS files.
Thank you @ctgraham.
One first guess: is the machine where it is installed able to access the internet without a proxy? If an outbound internet connection is not available you would get timeouts when checking for software updates, etc.
I have installed a Ubuntu 18.04 image in virtual box and it’s my home machine. I could browse other webapplications/websites without any delay.
When it gets slow is, When I logging in to any user whether it’s an admin or not doesn’t matter. After logging if i browse any article/issue the slowness persist. And it’s the same when i normally browse in the website.
But strangely when i don’t login everything works very very fast 
Were you able to capture the output of the upgrade process? Did that output have any errors or warnings? A lot of data is moved and migrated during the upgrade, so we’ll want to be sure all of that was successful.
Yes I got some errors, Since it migrated fully i didn’t look into it. But after you pointed out i will have to
see them carefully.
This is an access denied message, but it is also missing any public styling, so there are two problems here. For the access denied issue, let’s start with any messages from the upgrade process. For the styling issue, let’s look at the UI logs (coming below).
You mean access denied could be because of errors i got while upgrading the database?
Which i will find in opt/lampp/logs/php_error_log file.
In the upper left, is the link there a dropdown identifying your Site and each Journal? Do the available options change depending on which context you select?
Although it is a multi journals website. It only shows one here with no dropdown.
This sounds like a CSS issue. More information in the UI logging.
The PHP error log (which you have already found) will have useful information for each server-side error. You will get additional context for these if you turn on
show_stacktracein config.inc.php. For browser errors (e.g. javascript or failed requests), you can have your browser log the requests made. To do this use the browser’s “Inspector” mode by pressing “F12”. The tool will have a “Console” tab which will record javascript errors and a “Network” tab which can be used to capture network traffic.
Chrome DevTools - Chrome for Developers
This will be most interesting in seeing if you get 404 or 500 errors when fetching resources like javascript files and CSS files.
[/quote]
I haven’t tired this approach but yes i will debug the browser console as per your suggestion. And update here about the progress.
Regards,
Jnana.
The access denied message and the appearance of only a single journal for the site might indicate that the roles did not migrate correctly, particularly for the admin user. Let us know what the error messages from the upgrade indicate.
@ctgraham As the log file has almost 350 lines therefore i have temporarily hosted on sendeyo.
Here is the target link
https://sendeyo.com/en/8ff0122d22 .
You can download the .zip it only contain the php_error_log text file.
On UI Side:
While debugging in browser i found that few HTTP.GET requests to images are responding with 404.
But when i went and check these images are present in those location with 777 permission enabled.
I did went through similar issues posted by others in stackoverflow, other tech forum but no luck yet.
Here is the image attached for reference.
Thank you very much @ctgraham for your prompt replies, it’s helping me a lot.
In case the given url(https://sendeyo.com/en/8ff0122d22) doesn’t work. Here is the log file content.
[01-Feb-2020 10:15:57 Europe/Berlin] ojs2: DB Error: MySQL server has gone away
[01-Feb-2020 10:21:09 Europe/Berlin] PHP Notice: Only variables should be assigned by reference in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DBDataXMLParser.inc.php on line 122
[01-Feb-2020 13:25:33 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:26:13 Europe/Berlin] PHP Fatal error: Uncaught Exception: Cannot load record: invalid context id. in /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php:407
Stack trace:
#0 /opt/lampp/htdocs/journal/classes/statistics/MetricsDAO.inc.php(47): PKPMetricsDAO->foreignKeyLookup(256, 3)
#1 /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php(280): MetricsDAO->foreignKeyLookup(256, 3)
#2 /opt/lampp/htdocs/journal/classes/install/Upgrade.inc.php(568): PKPMetricsDAO->insertRecord(Array)
#3 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(421): Upgrade->migrateCounterPluginUsageStatistics(Object(Upgrade), Array)
#4 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(265): Installer->executeAction(Array)
#5 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#6 /opt/lampp/htdocs/journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#7 /opt/lampp/htdocs/journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php( in /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php on line 407
[01-Feb-2020 13:31:47 Europe/Berlin] PHP Warning: Declaration of InstallHandler::validate($request) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL) in /opt/lampp/htdocs/journal/lib/pkp/pages/install/InstallHandler.inc.php on line 48
[01-Feb-2020 13:31:47 Europe/Berlin] PHP Warning: Declaration of InstallForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/InstallForm.inc.php on line 191
[01-Feb-2020 13:31:47 Europe/Berlin] PHP Warning: Declaration of UpgradeForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/UpgradeForm.inc.php on line 31
[01-Feb-2020 13:31:49 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:00 Europe/Berlin] PHP Warning: Declaration of InstallHandler::validate($request) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL) in /opt/lampp/htdocs/journal/lib/pkp/pages/install/InstallHandler.inc.php on line 48
[01-Feb-2020 13:33:00 Europe/Berlin] PHP Warning: Declaration of InstallForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/InstallForm.inc.php on line 191
[01-Feb-2020 13:33:00 Europe/Berlin] PHP Warning: Declaration of UpgradeForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/UpgradeForm.inc.php on line 31
[01-Feb-2020 13:33:01 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:06 Europe/Berlin] PHP Warning: Declaration of InstallHandler::validate($request) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL) in /opt/lampp/htdocs/journal/lib/pkp/pages/install/InstallHandler.inc.php on line 48
[01-Feb-2020 13:33:06 Europe/Berlin] PHP Warning: Declaration of InstallForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/InstallForm.inc.php on line 191
[01-Feb-2020 13:33:06 Europe/Berlin] PHP Warning: Declaration of UpgradeForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/UpgradeForm.inc.php on line 31
[01-Feb-2020 13:33:06 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:33 Europe/Berlin] PHP Warning: Declaration of InstallHandler::validate($request) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL) in /opt/lampp/htdocs/journal/lib/pkp/pages/install/InstallHandler.inc.php on line 48
[01-Feb-2020 13:33:33 Europe/Berlin] PHP Warning: Declaration of InstallForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/InstallForm.inc.php on line 191
[01-Feb-2020 13:33:33 Europe/Berlin] PHP Warning: Declaration of UpgradeForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/UpgradeForm.inc.php on line 31
[01-Feb-2020 13:33:33 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:35:46 Europe/Berlin] PHP Warning: Declaration of InstallHandler::validate($request) should be compatible with PKPHandler::validate($requiredContexts = NULL, $request = NULL) in /opt/lampp/htdocs/journal/lib/pkp/pages/install/InstallHandler.inc.php on line 48
[01-Feb-2020 13:35:46 Europe/Berlin] PHP Warning: Declaration of InstallForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/InstallForm.inc.php on line 191
[01-Feb-2020 13:35:46 Europe/Berlin] PHP Warning: Declaration of UpgradeForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/install/form/UpgradeForm.inc.php on line 31
[01-Feb-2020 13:35:49 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Notice: Only variables should be assigned by reference in /opt/lampp/htdocs/journal/pages/index/IndexHandler.inc.php on line 68
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/27fc9a705b4a99644bc81d26b4e3875e89a73770^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/TagTransform/Font.php on line 78
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/TagTransform/Font.php on line 78
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Element ‘<a><em><strong><cite><code><ul><ol><li><dl><dt><dd><b><i><u><imgsrc|alt><sup><sub><br><p><marqueebehavior|direction>’ is not supported (for information on implementing this, see the support forums) in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/HTMLDefinition.php on line 311
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/5300004d4b9142132479eea7131632ea471d5576^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:19 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 13:37:33 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/e793d7624def142603b50f54f7e2a4b20dfbc051^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:33 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:33 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 13:37:37 Europe/Berlin] PHP Warning: Declaration of SubmissionKeywordEntryDAO::getByControlledVocabId($controlledVocabId, $rangeInfo = NULL) should be compatible with ControlledVocabEntryDAO::getByControlledVocabId($controlledVocabId, $rangeInfo = NULL, $filter = NULL) in /opt/lampp/htdocs/journal/lib/pkp/classes/submission/SubmissionKeywordEntryDAO.inc.php on line 36
[01-Feb-2020 13:37:42 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/e793d7624def142603b50f54f7e2a4b20dfbc051^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:42 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:42 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Warning: Declaration of SubmissionKeywordEntryDAO::getByControlledVocabId($controlledVocabId, $rangeInfo = NULL) should be compatible with ControlledVocabEntryDAO::getByControlledVocabId($controlledVocabId, $rangeInfo = NULL, $filter = NULL) in /opt/lampp/htdocs/journal/lib/pkp/classes/submission/SubmissionKeywordEntryDAO.inc.php on line 36
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/894d96a6367d2333e3dbd3c812964ac117ab031e^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 13:40:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:40:46 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 14:08:49 Europe/Berlin] PHP Notice: Only variables should be assigned by reference in /opt/lampp/htdocs/journal/pages/index/IndexHandler.inc.php on line 68
[01-Feb-2020 14:08:49 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/27fc9a705b4a99644bc81d26b4e3875e89a73770^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 14:08:50 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 14:08:50 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 14:08:58 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 14:08:58 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/5a71aee81a1957c0f83ad98734054540f514140e^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 14:08:58 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 14:08:58 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 14:28:00 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/5a71aee81a1957c0f83ad98734054540f514140e^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 14:28:00 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 14:28:00 Europe/Berlin] PHP Warning: Illegal string offset ‘en_US’ in /opt/lampp/htdocs/journal/plugins/generic/customBlockManager/CustomBlockPlugin.inc.php on line 112
[01-Feb-2020 14:28:43 Europe/Berlin] PHP Notice: Array to string conversion in /opt/lampp/htdocs/journal/lib/pkp/lib/adodb/adodb.inc.php on line 1021
[01-Feb-2020 14:28:43 Europe/Berlin] ojs2: DB Error: Unknown column ‘Array’ in ‘field list’
[01-Feb-2020 14:33:52 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:33:52 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 14:34:34 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:34:35 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 14:34:57 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:35:37 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:35:37 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:35:37 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:36:15 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:36:15 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:37:11 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:37:11 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:37:11 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:37:23 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:37:24 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:37:29 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 14:37:47 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Warning: Declaration of ChangePasswordForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/ChangePasswordForm.inc.php on line 90
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:39:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:40:19 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:40:19 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:40:19 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:40:19 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:40:20 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:40:20 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:40:20 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:40:20 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:41:33 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:41:33 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:42:27 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:27 Europe/Berlin] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /opt/lampp/htdocs/journal/lib/pkp/classes/xml/XMLParser.inc.php on line 45
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:43 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of PKPNotificationSettingsForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/notification/form/PKPNotificationSettingsForm.inc.php on line 134
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of ChangePasswordForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/ChangePasswordForm.inc.php on line 90
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:42:44 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:43:18 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:43:55 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:43:55 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:44:48 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:44:48 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:44:48 Europe/Berlin] PHP Warning: Declaration of BaseProfileForm::execute() should be compatible with Form::execute(…$functionArgs) in /opt/lampp/htdocs/journal/lib/pkp/classes/user/form/BaseProfileForm.inc.php on line 48
[01-Feb-2020 14:45:14 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 14:46:08 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
Regards,
Jnana.
The URLs are being formed as http://localhost/public/..., but your access in the browser looks like http://localhost/journal/public. Check your base_url in config.inc.php. This should be of the form base_url = http://localhost/journal.
I didn’t see any contents in the sendeyo.com link, but within the log, you can generally ignore any lines with:
Lines with:
will be of secondary interest to lines with:
From the log messages provided, the ones of most interest are:
[01-Feb-2020 10:15:57 Europe/Berlin] ojs2: DB Error: MySQL server has gone away
[01-Feb-2020 13:26:13 Europe/Berlin] PHP Fatal error: Uncaught Exception: Cannot load record: invalid context id. in /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php:407
Stack trace:
#0 /opt/lampp/htdocs/journal/classes/statistics/MetricsDAO.inc.php(47): PKPMetricsDAO->foreignKeyLookup(256, 3)
#1 /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php(280): MetricsDAO->foreignKeyLookup(256, 3)
#2 /opt/lampp/htdocs/journal/classes/install/Upgrade.inc.php(568): PKPMetricsDAO->insertRecord(Array)
#3 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(421): Upgrade->migrateCounterPluginUsageStatistics(Object(Upgrade), Array)
#4 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(265): Installer->executeAction(Array)
#5 /opt/lampp/htdocs/journal/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#6 /opt/lampp/htdocs/journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#7 /opt/lampp/htdocs/journal/lib/pkp/classes/cliTool/UpgradeTool.inc.php( in /opt/lampp/htdocs/journal/lib/pkp/classes/statistics/PKPMetricsDAO.inc.php on line 407
Was this a single run of the upgrade from 10:15:57 (or before) to 14:46:08 (or after)?
Can you find associated mysql error logs relating to the first message? You may need to re-configure or add resources for mysql and retry the upgrade.
The second fatal error (above) and subsequent warnings (below) may indicate data problems:
[01-Feb-2020 13:31:49 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:01 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:06 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:33:33 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:35:49 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/e8ea13aa559bf8604ca823015b397a28d8666486^28682bb3d6b6e750ebd3d458abc8f92b4da9ea9f_0.app.headerusernav.tpl.php on line 136
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:36:40 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/27fc9a705b4a99644bc81d26b4e3875e89a73770^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Element ‘<a><em><strong><cite><code><ul><ol><li><dl><dt><dd><b><i><u><imgsrc|alt><sup><sub><br><p><marqueebehavior|direction>’ is not supported (for information on implementing this, see the support forums) in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/HTMLDefinition.php on line 311
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/5300004d4b9142132479eea7131632ea471d5576^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:18 Europe/Berlin] PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/Encoder.php on line 162
[01-Feb-2020 13:37:33 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/e793d7624def142603b50f54f7e2a4b20dfbc051^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:42 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/e793d7624def142603b50f54f7e2a4b20dfbc051^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:37:44 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/894d96a6367d2333e3dbd3c812964ac117ab031e^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 13:40:46 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
[01-Feb-2020 13:40:46 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 14:08:49 Europe/Berlin] PHP Warning: Creating default object from empty value in /opt/lampp/htdocs/journal/cache/t_compile/27fc9a705b4a99644bc81d26b4e3875e89a73770^52019e87b90081f2c6bfa717994d81ab7712dd1f_0.app.frontendcomponentssearchF.php on line 30
[01-Feb-2020 14:28:43 Europe/Berlin] PHP Notice: Array to string conversion in /opt/lampp/htdocs/journal/lib/pkp/lib/adodb/adodb.inc.php on line 1021
[01-Feb-2020 14:28:43 Europe/Berlin] ojs2: DB Error: Unknown column ‘Array’ in ‘field list’
[01-Feb-2020 14:33:52 Europe/Berlin] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /opt/lampp/htdocs/journal/cache/t_compile/65bfc3e024c2e9104f46e23b73376a9455e3df0e^51cfb9321c891ada9323e7942962579e7e4324d1_0.app.frontendpagesindexSite.tp.php on line 43
[01-Feb-2020 14:34:34 Europe/Berlin] PHP Notice: unserialize(): Error at offset 1512 of 1797 bytes in /opt/lampp/htdocs/journal/lib/pkp/classes/db/DAO.inc.php on line 352
Some of these would require debugging to identify what data is throwing the warning or notice. Others we can fix more easily.
This reference:
[01-Feb-2020 13:37:08 Europe/Berlin] PHP Warning: Element ‘<a><em><strong><cite><code><ul><ol><li><dl><dt><dd><b><i><u><imgsrc|alt><sup><sub><br><p><marqueebehavior|direction>’ is not supported (for information on implementing this, see the support forums) in /opt/lampp/htdocs/journal/lib/pkp/lib/vendor/ezyang/htmlpurifier/library/HTMLPurifier/HTMLDefinition.php on line 311
Indicates that you haven’t fully reconciled changes in config.inc.php for 3.x with your original settings in 2.x. As a best practice, copy the new 3.x config.TEMPLATE.inc.php to config.inc.php, and then copy your old settings from your 2.x config.inc.php into the new file, reviewing new configuration notes as you go. The allowed_html configuration format has changed, for example, and this is the cause of this warning.
The URLs are being formed as
http://localhost/public/..., but your access in the browser looks likehttp://localhost/journal/public. Check yourbase_urlin config.inc.php. This should be of the formbase_url = http://localhost/journal.
@ctgraham, Initially it was default url(provided by pkp) now i changed it to “http://localhost/journal”. Then i restarted the lampp stack. But still the same behaviour.
Was this a single run of the upgrade from 10:15:57 (or before) to 14:46:08 (or after)?
Yes it is the log from single run of the upgrade, becuse it took almost 7-8 hrs to complete.
@ctgraham from your analysis i feel that i need to restart the upgrade process again. So i will go ahead with that. Again it may take a 1-2days. I will keep you updated.
@ctgraham after tried the upgrade for couple time with console logs to find out the exact origin of fatal error.
As per the callstack it begins here.
PKPMetricsDAO->foreignKeyLookup(256, 3) which is from PKPMetricesDAO.inc.php file function insertRecord($record) and line number 281.
Where it says the:
1st parameter 256 is $assocType
2nd parameter 3 is $assocId.
What exactly these two and how will i ensure that it returns a valid context.
It throws exception at 407 of PKPMetricsDAO.php because
$context = $contextDao->getById($assocId); return null;
protected function foreignKeyLookup($assocType, $assocId) {
…
case Application::getContextAssocType():
$contextDao = Application::getContextDAO(); /* @var $contextDao ContextDAO */
$context = $contextDao->getById($assocId);
if (!$context) {
throw new Exception('Cannot load record: invalid context id.');
}
$contextId = $assocId;
break;
}
}
Do we have a better suggestion for debugging ? Because debug with console log takes a lots of time.
Note: I am doing the upgrade on 18.04 Ubuntu with lamp stack.
Am i doing the process correctly?
Do we have a code architecture to understand the design and workflow?
Regards,
Jnana.
I am upgrading from OJS 2.4 to 3.x and encountering a number of problems including;
review_assignments_tmp already exists
notes_tmp already exists
submission_galley_settings already exists
I deleted these and then encountered the following error;
DB Error: Unknown column 'assoc_type' in 'where clause' Query: UPDATE email_templates SET assoc_type = 530 WHERE assoc_type = '526'
I have then cleared data for these and re run the upgrade process but now encountering the following error;
# DB Error: Unknown column 'a.setting_type' in 'where clause' Query: SELECT a.*, b.context_id FROM submission_settings a, submissions b WHERE a.setting_name = 'fileName' AND a.locale = ? AND a.setting_value LIKE ? AND a.setting_type = 'string' AND b.submission_id = a.submission_id
Is there any way to clean/ check the database as I have the same database in the backup. How can we check if our data is good to be upgraded to OJS 3.x
Hi @esciencepress,
If those tables already exist in the database, then your database has already had a partial upgrade attempted and is an inconsistent state between your old version and your new version. It’s absolutely necessary to restore your database from a backup taken before the upgrade attempt. When you do that, make sure you DROP the database before loading the database dump and CREATE a fresh one – otherwise old tables from the upgrade attempt can be left lying around to interfere with the upgrade.
Regards,
Alec Smecher
Public Knowledge Project Team
@asmecher thank you for your reply. I do not have access to the old database as this was upgraded to 2.4 year before and now I want to move to 3.x. Any solution please? We have 15 journals hosted to this domain.
I have cleaned for the above errors and stuck at the following code error;
DB Error: Unknown column 'a.setting_type' in 'where clause' Query: SELECT a.*, b.context_id FROM submission_settings a, submissions b WHERE a.setting_name = 'fileName' AND a.locale = ? AND a.setting_value LIKE ? AND a.setting_type = 'string' AND b.submission_id = a.submission_id
Hi @esciencepress,
The upgrade to OJS 2.4.x a year ago shouldn’t be a problem – it’s this next upgrade to OJS 3.x. Before trying the upgrade, did you make a backup?
Regards,
Alec Smecher
Public Knowledge Project Team
Hi @esciencepress,
Do you have the output from the first time the upgrade failed?
Regards,
Alec Smecher
Public Knowledge Project Team
Hi @esciencepress,
The first time you tried to run the upgrade from OJS 2.x to 3.x, what error message did you get?
Regards,
Alec Smecher
Public Knowledge Project Team
@asmecher I copied the error message above ;
review_assignments_tmp already exists
I have manually removed review_assignments_tmp from phpmyadmin and then restarted the upgrade. Gradually the errors were notes_tmp already exists and submission_galley_settings already exists which I removed using the same mysql.
Now I am stuck here;
DB Error: Unknown column 'a.setting_type' in 'where clause' Query: SELECT a.*, b.context_id FROM submission_settings a, submissions b WHERE a.setting_name = 'fileName' AND a.locale = ? AND a.setting_value LIKE ? AND a.setting_type = 'string' AND b.submission_id = a.submission_id