Error when downloading articles report

Software Support
1

After the Upgrade, i have problems with downloading articles report. It says:

This site can’t be reached

The webpage at https://techniumscience.com/index.php/socialsciences/management/tools/report?pluginName=ArticleReportPlugin might be temporarily down or it may have moved permanently to a new web address.

ERR_INVALID_RESPONSE

Also, error_log:

[28-Jan-2021 20:18:04 UTC] PHP Deprecated: Non-static method PKPApplication::getRequest() should not be called statically in /home/scurtucr/techniumscience/plugins/generic/customHeader/CustomHeaderPlugin.inc.php on line 112
[28-Jan-2021 20:18:04 UTC] PHP Deprecated: Non-static method PKPApplication::getRequest() should not be called statically in /home/scurtucr/techniumscience/plugins/generic/customHeader/CustomHeaderPlugin.inc.php on line 112
[28-Jan-2021 20:18:06 UTC] PHP Deprecated: Non-static method PKPApplication::getRequest() should not be called statically in /home/scurtucr/techniumscience/plugins/generic/customHeader/CustomHeaderPlugin.inc.php on line 112
[28-Jan-2021 20:18:19 UTC] PHP Fatal error: Uncaught Error: Call to a member function getData() on null in /home/scurtucr/techniumscience/plugins/reports/articles/ArticleReportPlugin.inc.php:92
Stack trace:
#0 /home/scurtucr/techniumscience/lib/pkp/pages/management/PKPToolsHandler.inc.php(155): ArticleReportPlugin->display(Array, Object(Request))
#1 /home/scurtucr/techniumscience/lib/pkp/pages/management/PKPToolsHandler.inc.php(58): PKPToolsHandler->report(Array, Object(Request))
#2 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPToolsHandler->tools(Array, Object(Request))
#3 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#4 /home/scurtucr/techniumscience/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))
#5 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPApplication.inc.php(281): Dispatcher->dispatch(Object(Request))
#6 /home/scurtucr/techniumscience/index.php(68): P in /home/scurtucr/techniumscience/plugins/reports/articles/ArticleReportPlugin.inc.php on line 92
[28-Jan-2021 20:18:44 UTC] PHP Fatal error: Uncaught Error: Call to a member function getData() on null in /home/scurtucr/techniumscience/plugins/reports/articles/ArticleReportPlugin.inc.php:92
Stack trace:
#0 /home/scurtucr/techniumscience/lib/pkp/pages/management/PKPToolsHandler.inc.php(155): ArticleReportPlugin->display(Array, Object(Request))
#1 /home/scurtucr/techniumscience/lib/pkp/pages/management/PKPToolsHandler.inc.php(58): PKPToolsHandler->report(Array, Object(Request))
#2 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPToolsHandler->tools(Array, Object(Request))
#3 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)
#4 /home/scurtucr/techniumscience/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))
#5 /home/scurtucr/techniumscience/lib/pkp/classes/core/PKPApplication.inc.php(281): Dispatcher->dispatch(Object(Request))
#6 /home/scurtucr/techniumscience/index.php(68): P in /home/scurtucr/techniumscience/plugins/reports/articles/ArticleReportPlugin.inc.php on line 92

Please advise me!

2

Hi @Technium_Science,

Hmmm… It seems one (or several) of your articles do not have publication in the DB. Maybe something went wrong during the upgrade. What version did you use earlier and to what version have you upgraded?

Best,
Bozana

3

Current version: 3.2.1.3 (January 25, 2021 - 08:43 PM)

from 3.1.2.4

4

Hi @Technium_Science,

I am unfortunately not familiar with that upgrade, but… could you maybe check if that is the problem, if there are submissions in your installation without a publication in the DB: Could you maybe execute this SQL in your DB:

SELECT s.submission_id FROM `submissions` s
WHERE s.submission_id NOT IN (SELECT p.submission_id FROM publications p)

EDIT: Did you see any errors or warnings during the upgrade?

Thanks!
Bozana

5

Hello,
I don’t think i have had any errors or warning during the upgrade.
After executing the code recommended by you, it says: (find in the attached screenshot)

6

Hi @Technium_Science,

I do not see the attachment…

EDIT: if there is any result, any submission ID, after executing that SQL, it means those submissions misses publications entries in the DB… If this is the case I would need to investigate how and if this can be repaired…

Thanks!
Bozana

7

I have a similar problem I downloaded an empty data file.
I migrate form ojs3124–>ojs3308

this error
image

I use this sql for check data.

SELECT s.submission_id,s.context_id,s.current_publication_id,sf.submission_file_id FROM `submissions` s 
left join submission_files sf on s.submission_id=sf.submission_id 
WHERE s.`current_publication_id` is NULL and sf.submission_file_id is NULL;

I delete submission_id IN same context_id for test
image

and test download report
image

good luck.

OhnO395
ThaiJO team