OJS 3.2.01 Article report can't generat

[zalamuia]

OJS 3.2.0-1

OS platform	Linux
PHP version	7.2.17
Apache version	Apache/2.4.6 (CentOS)
Database driver	mysqli
Database server version	5.5.60-MariaDB

Browser used : Chrome, Mozilla, Edge

OJS 3.2.0-1 Article report can't generate

ALL plugin are updated,

It produce CSV file with single line "

Unrecognized DAO ArticleDAO!

--

"
View Report results "Unrecognized DAO PublishedArticleDAO!"

Counter Article report results "Unrecognized DAO ArticleDAO!"

with ENABLE plugin paper can't be accepted (never ended loop) however OJS 3.1.2.4 it is O

Custom report generation never ending but fresh installation is ok.

Can't view Activity Log & Notes using Chrome 64 browser

Thanking you.

Zahirul

[asmecher]

@zalamuia, I suspect you have a plugin installed that's not updated for compatibility with OJS 3.2.x. You can find out which by turning on show_stacktrace in config.inc.php and getting the error message again.

[zalamuia]

Dear Mr Alec,

Thanks for your advise. I have checked and found following info

Unrecognized DAO ArticleDAO!

Stack Trace:

-- File: /home/ojs/ejournal/plugins/reports/articles/ArticleReportDAO.inc.php line 27
Function: DAORegistry::getDAO("ArticleDAO")

|   |   |   |   |   |   File: /home/ojs/ejournal/plugins/reports/articles/ArticleReportPlugin.inc.php line 67
Function: ArticleReportDAO->getArticleReport(1)

|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/pages/management/PKPToolsHandler.inc.php line 155
Function: ArticleReportPlugin->display(Array(0) | Object(Request))
|   |   |  
|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/pages/management/PKPToolsHandler.inc.php line 58
Function: PKPToolsHandler->report(Array(0) | Object(Request))
|   |   |  
|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/classes/core/PKPRouter.inc.php line 391
Function: PKPToolsHandler->tools(Array(0) | Object(Request))
|   |   |  
|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/classes/core/PKPPageRouter.inc.php line 231
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2) | Object(Request) | Array(1) | False)
|   |  
|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/classes/core/Dispatcher.inc.php line 143
Function: PKPPageRouter->route(Object(Request))

|   |   |   |   |   |   File: /home/ojs/ejournal/lib/pkp/classes/core/PKPApplication.inc.php line 278
Function: Dispatcher->dispatch(Object(Request))

|   |   |   |   |   |   File: /home/ojs/ejournal/index.php line 68
Function: PKPApplication->execute()
|  
|   |   |   |   |   |  

I have deleted the report plugin and copied from newly downloaded OJ3.2.0-1 but I got following error
This site can’t be reached The webpage at https://journals.iium.edu.my/ejournal/index.php/iiumej/management/tools/report?pluginName=ArticleReportPlugin might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

HOWEVER, other ojs site is replaced with new reports plugin without deletion works fine.

Thanks.

Zahirul

[asmecher]

@zalamuia, that was definitely code older than 3.2.0-1 running in your OJS installation; I'd double-check the method you used to update your code to ensure you're not mixing two versions together.

For the new problem, check your PHP error log for details.

[zalamuia]

I have updated through update process.
Some of the journal sites have no problem but few have problem.
However, I got followings

-- Fatal error:  Uncaught Error: Call to a member function getLocalizedGivenName() on null in /home/ojs/ejournal/plugins/reports/articles/ArticleReportPlugin.inc.php:114 Stack trace: #0 /home/ojs/ejournal/lib/pkp/pages/management/PKPToolsHandler.inc.php(155): ArticleReportPlugin->display(Array #1 /home/ojs/ejournal/lib/pkp/pages/management/PKPToolsHandler.inc.php(58): PKPToolsHandler->report(Array #2 /home/ojs/ejournal/lib/pkp/classes/core/PKPRouter.inc.php(391): PKPToolsHandler->tools(Array #3 /home/ojs/ejournal/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array #4 /home/ojs/ejournal/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPPageRouter->route(Object(Request)) #5 /home/ojs/ejournal/lib/pkp/classes/core/PKPApplication.inc.php(278): Dispatcher->dispatch(Object(Request)) #6 /home/ojs/ejournal/index.php(68): PKPApplication->execute() #7 {main} thrown in /home/ojs/ejournal/plugins/reports/articles/ArticleReportPlugin.inc.php on line 114

Thanking you.

[asmecher]

@zalamuia, this looks like a data error to me. What do you get for the following query?

SELECT e.editor_id FROM section_editors e LEFT JOIN users u ON (u.user_id = e.editor_id) WHERE u.user_id IS NULL;

If you get any results, you'll need to remove those entries from the section_editors table.

[zalamuia]

Dear Mr Alec,

generate error #1054 - Unknown column 'e.editor_id' in 'field list' after ruining the query.

Only one entry is there in section_editors.

section_editors (context_id, section_id, user_id) VALUES (1, 14, 616);

after deleting this entry also not helping to obtain the report.

Other journal without any data in section_editors and another journal with data can managed to obtain report.

few other journals I can't get the result. I have around 25 installation journal.

Thanks.

Zahirul

[asmecher]

@zalamuia, can you try this database query?

SELECT stage_assignments.* FROM stage_assignments LEFT JOIN users ON stage_assignments.user_id = users.user_id WHERE users.user_id IS NULL;

This will identify any stage assignments that correspond to nonexistent users. If any results are shown, try removing them. (Please make a backup of your database before doing this!)

[zalamuia]

Dear Mr Alec,

I have tried the query and found two entries. After removing those entries I can generate report. Thanks for your support for solving this issue.

Thanking you.
Zahirul

[asmecher]

Glad to hear it!