[3.0.2 --> 3.1] Issues inaccessible

Hi! After upgrading to 3.1 we cannot access issues metadata (Issues → Back Issues). Here is what I have in browser console:

GET http://…58.220/styles/build.css net::ERR_ABORTED
manageIssues:11 GET http://…58.220/js/build.js net::ERR_ABORTED
manageIssues:11 GET http://…58.220/js/build.js net::ERR_ABORTED
pkp.min.js:128 Uncaught ReferenceError: pkp is not defined
at a.pkp.classes.Handler.bindGlobal (pkp.min.js:128)
at a.pkp.controllers.grid.issues.FutureIssueGridHandler [as constructor] (pkp.min.js:436)
at a.pkp.classes.ObjectProxy.parent (pkp.min.js:119)
at new a (pkp.min.js:117)
at Function.a.pkp.classes.Helper.objectFactory (pkp.min.js:116)
at HTMLDivElement. (pkp.min.js:443)
at Function.each (jquery.min.js:2)
at n.fn.init.each (jquery.min.js:2)
at n.fn.init.a.fn.pkpHandler (pkp.min.js:443)
at HTMLDocument.eval (eval at (jquery.min.js:2), :3:61)
a.pkp.classes.Handler.bindGlobal @ pkp.min.js:128
a.pkp.controllers.grid.issues.FutureIssueGridHandler @ pkp.min.js:436
a.pkp.classes.ObjectProxy.parent @ pkp.min.js:119
a @ pkp.min.js:117
a.pkp.classes.Helper.objectFactory @ pkp.min.js:116
(anonymous) @ pkp.min.js:443
each @ jquery.min.js:2
each @ jquery.min.js:2
a.fn.pkpHandler @ pkp.min.js:443
(anonymous) @ VM2037:3
j @ jquery.min.js:2
add @ jquery.min.js:2
n.fn.ready @ jquery.min.js:2
n.fn.init @ jquery.min.js:2
n @ jquery.min.js:2
(anonymous) @ VM2037:2
(anonymous) @ jquery.min.js:2
globalEval @ jquery.min.js:2
domManip @ jquery.min.js:3
append @ jquery.min.js:3
(anonymous) @ jquery.min.js:3
n.access @ jquery.min.js:3
html @ jquery.min.js:3
a.pkp.classes.Handler.html @ pkp.min.js:134
a.pkp.controllers.UrlInDivHandler.handleLoadedContent_ @ pkp.min.js:203
(anonymous) @ pkp.min.js:124
j @ jquery.min.js:2
fireWith @ jquery.min.js:2
x @ jquery.min.js:4
b @ jquery.min.js:4
XMLHttpRequest.send (async)
send @ jquery.min.js:4
ajax @ jquery.min.js:4
n.(anonymous function) @ jquery.min.js:4
a.pkp.controllers.UrlInDivHandler.reload @ pkp.min.js:202
a.pkp.controllers.UrlInDivHandler @ pkp.min.js:202
a.pkp.classes.ObjectProxy.parent @ pkp.min.js:119
a @ pkp.min.js:117
a.pkp.classes.Helper.objectFactory @ pkp.min.js:116
(anonymous) @ pkp.min.js:443
each @ jquery.min.js:2
each @ jquery.min.js:2
a.fn.pkpHandler @ pkp.min.js:443
(anonymous) @ manageIssues:155
j @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
K @ jquery.min.js:2

Hi @Ph_We

Could you please check your php error log of your server.
It may shows some more info about debugging this error.

Regards,
Israel Cefrin
Public Knowledge Project Team

Hi @israel.cefrin,

Here is the log:

[Fri Nov 10 10:18:01.559205 2017] [:error] [pid 11978] [client 10.0.3.1:51902] PHP Warning:  assert(): Assertion failed in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 154, referer: http://92.242.58.220/index.php/vo/manageIssues
[Fri Nov 10 10:18:01.559256 2017] [:error] [pid 11978] [client 10.0.3.1:51902] PHP Fatal error:  Call to a member function getLocalizedTitle() on null in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 156, referer: http://92.242.58.220/index.php/vo/manageIssues
[Fri Nov 10 10:18:17.667856 2017] [:error] [pid 12560] [client 10.0.3.1:51914] PHP Warning:  assert(): Assertion failed in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 154, referer: http://92.242.58.220/index.php/jsps/submissions
[Fri Nov 10 10:18:17.667937 2017] [:error] [pid 12560] [client 10.0.3.1:51914] PHP Fatal error:  Call to a member function getLocalizedTitle() on null in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 156, referer: http://92.242.58.220/index.php/jsps/submissions
[Fri Nov 10 10:18:42.151451 2017] [:error] [pid 11977] [client 10.0.3.1:51922] PHP Warning:  assert(): Assertion failed in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 154, referer: http://92.242.58.220/index.php/index/user/profile
[Fri Nov 10 10:18:42.151534 2017] [:error] [pid 11977] [client 10.0.3.1:51922] PHP Fatal error:  Call to a member function getLocalizedTitle() on null in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 156, referer: http://92.242.58.220/index.php/index/user/profile
[Fri Nov 10 10:18:53.562707 2017] [:error] [pid 11975] [client 10.0.3.1:51928] PHP Warning:  assert(): Assertion failed in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 154, referer: http://92.242.58.220/index.php/mirros/submissions
[Fri Nov 10 10:18:53.562788 2017] [:error] [pid 11975] [client 10.0.3.1:51928] PHP Fatal error:  Call to a member function getLocalizedTitle() on null in /var/www/html/lib/pkp/controllers/grid/notifications/NotificationsGridCellProvider.inc.php on line 156, referer: http://92.242.58.220/index.php/mirros/submissions

Hi @Ph_We

Your log error is showing a similar error to this thread:

In that case it was a database inconsistency or data error (a submission ID was assigned to a nonexistent section).
Could please follow that same instructions and verify if is your case too?

Regards,
Israel Cefrin
Public Knowledge Project Team

@israel.cefrin,

Yes, we really do have that issue too. But it is not as fatal for now.
Whereas the error with issues inaccessible is a critical one.

These two issues are not related. Since now we have the production OJS 3.0.2, which has only the ‘Tasks not loading’ issue. And the test OJS 3.1, which has both of these issues.

You have same issue in both installs and one more issue in recent one, I can tell.

Could you run this SQL statement
SELECT s.submission_id, s.section_id FROM submissions s LEFT JOIN sections se ON (s.section_id = se.section_id) WHERE se.section_id IS NULL;

And check if there is some section_id null ? Run in both OJS DB instances, please.

Regards,
Israel Cefrin
Public Knowledge Project Team