Article report failed

[Daniel_delagarza]

¡Hi everyone! Good Day!

I’m using version OJS 3.2.1.2
I tried to get the report articles in management and send me this page.

then in the log… i received this message
[Tue Jun 15 11:43:44.988232 2021] [php7:error] [pid 31595] [client 189.216.113.149:39136] PHP Fatal error: Uncaught Error: Call to a member function getLocalizedTitle() on null in /srv/httpd/novohispana/plugins/reports/articles/ArticleReportPlugin.inc.php:128\nStack trace:\n#0 /srv/httpd/novohispana/lib/pkp/pages/management/PKPToolsHandler.inc.php(155): ArticleReportPlugin->display(Array, Object(Request))\n#1 /srv/httpd/novohispana/lib/pkp/pages/management/PKPToolsHandler.inc.php(58): PKPToolsHandler->report(Array, Object(Request))\n#2 /srv/httpd/novohispana/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPToolsHandler->tools(Array, Object(Request))\n#3 /srv/httpd/novohispana/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#4 /srv/httpd/novohispana/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request))\n#5 /srv/httpd/novohispana/lib/pkp/classes/core/PKPApplication.inc.php(281): Dispatcher->dispatch(Object(Request))\n#6 /srv/httpd/novohispana/index.php(68): PKPApplication->execute()\n#7 {main}\n thrown in /srv/httpd/novohispana/plugins/reports/articles/ArticleReportPlugin.inc.php on line 128, referer: https://novohispana.historicas.unam.mx/index.php/ehn/management/tools

then i put this line on code
error_log($section->getLocalizedTitle());
in
/plugins/reports/ArticleReportPlugin.inc.php below of line 128 (error_log) to bring the assoc_type=1048585 and assoc_id=77717
assoc_type=1048585 assoc_id=77716
assoc_type=1048585 assoc_id=77715; bring 3 records.
Its seems that not see the title of what? i found the assoc_id only in notifications, but i’m not sure are the correct tables for delete or update.

Thanks Community, Regards!
SOS! @asmecher
the line error_log() ,i substract for other topic it works!

[Daniel_delagarza]

Any information can help me! Thanks PKP community!

[Walter_Nakamura]

I’m facing the same issue. Updated it to the latest stable version and the error remains.

[Daniel_delagarza]

The problem comes from de database, the error log see a title zero or null in article report, i think this have a solution, i have more journals with the same version and it works, i copy the files and i compare and i can’t resolved.

[Daniel_delagarza]

/lib/pkp/classes/submission# nano PKPSubmission.inc.php

in this file we are going to remove the negation of the validation function so that the csv is allowed to print, once it is printed we are going to identify the titles that have no relation or congruence together with their id, we identify their ids (submission_id), with this we realize that its section_id points to zero, so we need to delete those records that appeared in the csv.

select * from submissions where submission_id = ‘3638’; (example)

all that points to zero:

select * from submissions where section_id = ‘0’;

then delete:

delete * from submissions where section_id = ‘0’;