Hi,
After upgrade from 2.4.8.0 to 3.1 some articles exists in database, but they are show displayed in administration area.
In this example, this author have 2 articles, OJS counts 2 but just display one:
And this is the json result of this page:
{“items”:[{“id”:148862,“fullTitle”:{“pt_BR”:“De colaboradores a agentes digitais de reputa\u00e7\u00e3o da marca:: o caso "Essa Coca \u00e9 Fanta, e da\u00ed?"”,“en_US”:“From employees to digital agents of brand reputation:: the case "Essa Coca \u00e9 Fanta, e da\u00ed??"”,“es_ES”:“De empleados a agentes digitales de reputaci\u00f3n de la marca:: el caso "Essa Coca \u00e9 Fanta, e da\u00ed?"”},“status”:{“id”:1,“label”:“Queued”},“submissionProgress”:0,“stages”:[{“id”:1,“label”:“Submission”,“isActiveStage”:true,“queries”:,“currentUserAssignedRoles”:[65536],“statusId”:1,“status”:“No editor has been assigned to this submission.”,“files”:{“count”:0}},{“id”:3,“label”:“Review”,“isActiveStage”:false,“queries”:,“currentUserAssignedRoles”:[65536]},{“id”:4,“label”:“Copyediting”,“isActiveStage”:false,“queries”:,“currentUserAssignedRoles”:[65536],“files”:{“count”:0}},{“id”:5,“label”:“Production”,“isActiveStage”:false,“queries”:,“currentUserAssignedRoles”:[65536],“files”:{“count”:0}}],“reviewRounds”:,“reviewAssignments”:,“locale”:“pt_BR”,“urlWorkflow”:“http://revistas3localhost/organicom/authorDashboard/submission/148862”,“urlAuthorWorkflow”:“http://revistas3localhost/organicom/authorDashboard/submission/148862”,“urlEditorialWorkflow”:“http://revistas3localhost/organicom/workflow/access/148862”,“_href”:“http://revistas3localhost/organicom/api/v1/submissions/148862”,“authorString”:“Jo\u00e3o Guilherme de Melo Peixoto, Sabrina Medeiros Wanderley de Queiroz”,“urlPublished”:“http://revistas3localhost/organicom/article/view/148862”},{“id”:145148,“fullTitle”:{“pt_BR”:“As m\u00eddias digitais como plataformas de transforma\u00e7\u00e3o de colaboradores em agentes de reputa\u00e7\u00e3o da marca”},“status”:{“id”:1,“label”:“Queued”},“submissionProgress”:0,“stages”:[{“id”:1,“label”:“Submission”,“isActiveStage”:false,“queries”:,“currentUserAssignedRoles”:[65536],“statusId”:1,“status”:“No editor has been assigned to this submission.”,“files”:{“count”:0}},{“id”:3,“label”:“Review”,“isActiveStage”:true,“queries”:,“currentUserAssignedRoles”:[65536]},{“id”:4,“label”:“Copyediting”,“isActiveStage”:false,“queries”:[{“id”:118467,“assocType”:1048585,“assocId”:145148,“stageId”:4,“sequence”:1,“closed”:false}],“currentUserAssignedRoles”:[65536],“files”:{“count”:0}},{“id”:5,“label”:“Production”,“isActiveStage”:false,“queries”:[{“id”:118468,“assocType”:1048585,“assocId”:145148,“stageId”:5,“sequence”:2,“closed”:false}],“currentUserAssignedRoles”:[65536],“files”:{“count”:0}}],“reviewRounds”:,“reviewAssignments”:[{“id”:33135,“isCurrentUserAssigned”:false,“statusId”:9,“status”:“This review is complete and the reviewer has been thanked for their contribution.”,“due”:“2018-05-18”,“responseDue”:“2018-05-18”,“round”:1,“roundId”:0},{“id”:33312,“isCurrentUserAssigned”:false,“statusId”:9,“status”:“This review is complete and the reviewer has been thanked for their contribution.”,“due”:“2018-05-24”,“responseDue”:“2018-05-24”,“round”:1,“roundId”:0},{“id”:34269,“isCurrentUserAssigned”:false,“statusId”:9,“status”:“This review is complete and the reviewer has been thanked for their contribution.”,“due”:“2018-06-21”,“responseDue”:“2018-06-21”,“round”:1,“roundId”:0}],“locale”:“pt_BR”,“urlWorkflow”:“http://revistas3localhost/organicom/authorDashboard/submission/145148”,“urlAuthorWorkflow”:“http://revistas3localhost/organicom/authorDashboard/submission/145148”,“urlEditorialWorkflow”:“http://revistas3localhost/organicom/workflow/access/145148”,“_href”:“http://revistas3localhost/organicom/api/v1/submissions/145148”,“authorString”:“Jo\u00e3o Guilherme de Melo Peixoto, Sabrina Medeiros Wanderley de Queiroz”,“urlPublished”:“http://revistas3localhost/organicom/article/view/145148”}],“itemsMax”:2}
There is 2 articles in Json, but just one are displayed. The article 145148 is missing in this case.
If i search for 145148:
1 of 1 and no one are displayed.
Json result for this search contains just the article 145148.
In others cases the article exists in database but I can’t find in json.
All missing articles that I notice have status = 1, submission_progress = 0 and stage_id =3
revistas3=> select submission_id, context_id,status, submission_progress, stage_id from submissions where submission_id in (142522,143351,143706,145114,144621,145131,145147,145148,145150,145152,145161,145168,145002,145011);
submission_id | context_id | status | submission_progress | stage_id
---------------±-----------±-------±--------------------±---------
143351 | 232 | 1 | 0 | 3
145002 | 232 | 1 | 0 | 3
142522 | 232 | 1 | 0 | 3
145011 | 232 | 1 | 0 | 3
143706 | 232 | 1 | 0 | 3
144621 | 232 | 1 | 0 | 3
145148 | 232 | 1 | 0 | 3
145168 | 232 | 1 | 0 | 3
145161 | 232 | 1 | 0 | 3
145147 | 232 | 1 | 0 | 3
145152 | 232 | 1 | 0 | 3
145150 | 232 | 1 | 0 | 3
145114 | 232 | 1 | 0 | 3
145131 | 232 | 1 | 0 | 3
(14 rows)
There are probably other missing articles that I have not noticed yet.
Can someone please help me?
Regards,
Tarcisio Pereira.