Error when importing using native XML import plugin in 3.2.0.3

Software Support
1

Dear all,

I have upgraded to 3.2.0-3 andt tried to imoprt articles! However I get similar 500 errors as in this thread:

i have the latest version and I tried to make the changes of issue 5920:

However I still have an error.
When I try to import a file exported from ojs 3.2.0.3 it works, but with the one I have I dont know what is wrong since I get no error message in the “Results” page.

First when I load the …/management/importexport/plugin/NativeImportExportPlugin page i get this frustrating error:

image
image755×378 13.1 KB

This is the error i have got when the error box appears:

[Tue Jun 02 08:46:07.102041 2020] [php7:notice] [pid 21072] [client 0.0.0.0:22486] PHP Notice:  Undefined offset: 0 in /var/www/html/journalfolder/lib/pkp/classes/submission/PKPSubmission.inc.php on line 160, referer: https://mydomain.com/journalfolder/index.php/SLM/management/importexport/plugin/NativeImportExportPlugin
[Tue Jun 02 08:46:07.103727 2020] [php7:notice] [pid 21072] [client 0.0.0.0:22486] Slim Application Error:\nType: Error\nMessage: Call to a member function getData() on null\nFile: /var/www/html/journalfolder/lib/pkp/classes/submission/PKPSubmission.inc.php\nLine: 54\nTrace: #0 /var/www/html/journalfolder/classes/services/SubmissionService.inc.php(134): PKPSubmission->getBestId()\n#1 /var/www/html/journalfolder/lib/pkp/classes/plugins/HookRegistry.inc.php(107): APP\\Services\\SubmissionService->modifyPropertyValues('Submission::get...', Array)\n#2 /var/www/html/journalfolder/lib/pkp/classes/services/PKPSubmissionService.inc.php(254): HookRegistry::call('Submission::get...', Array)\n#3 /var/www/html/journalfolder/lib/pkp/classes/services/PKPSubmissionService.inc.php(297): PKP\\Services\\PKPSubmissionService->getProperties(Object(Submission), Array, Array)\n#4 /var/www/html/journalfolder/lib/pkp/api/v1/_submissions/PKPBackendSubmissionsHandler.inc.php(158): PKP\\Services\\PKPSubmissionService->getBackendListProperties(Object(Submission), Array)\n#5 [internal function]: PKPBackendSubmissionsHandler->getMany(Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#6 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#7 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\\Handlers\\Strategies\\RequestResponse->__invoke(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#8 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\Route->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#9 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\\Route->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#10 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\\Route->run(Object(Slim\\Http\\Request), Object(APIResponse))\n#11 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(76): Slim\\App->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#12 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#13 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)\n#14 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#15 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#16 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#17 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#18 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)\n#19 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#20 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#21 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#22 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#23 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)\n#24 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#25 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#26 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#27 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#28 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#29 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#30 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#31 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#32 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#33 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#34 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#35 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#36 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#37 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#38 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#39 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#40 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#41 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#42 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\\App->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#43 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\\App->process(Object(Slim\\Http\\Request), Object(APIResponse))\n#44 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#45 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#46 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#47 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#48 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\
[Tue Jun 02 08:46:25.849733 2020] [php7:notice] [pid 20409] [client 0.0.0.0:22511] PHP Notice:  Undefined offset: 0 in /var/www/html/journalfolder/lib/pkp/classes/submission/PKPSubmission.inc.php on line 160, referer: https://mydomain.com/journalfolder/index.php/SLM/management/importexport/plugin/NativeImportExportPlugin
[Tue Jun 02 08:46:25.850787 2020] [php7:notice] [pid 20409] [client 0.0.0.0:22511] Slim Application Error:\nType: Error\nMessage: Call to a member function getData() on null\nFile: /var/www/html/journalfolder/lib/pkp/classes/submission/PKPSubmission.inc.php\nLine: 54\nTrace: #0 /var/www/html/journalfolder/classes/services/SubmissionService.inc.php(134): PKPSubmission->getBestId()\n#1 /var/www/html/journalfolder/lib/pkp/classes/plugins/HookRegistry.inc.php(107): APP\\Services\\SubmissionService->modifyPropertyValues('Submission::get...', Array)\n#2 /var/www/html/journalfolder/lib/pkp/classes/services/PKPSubmissionService.inc.php(254): HookRegistry::call('Submission::get...', Array)\n#3 /var/www/html/journalfolder/lib/pkp/classes/services/PKPSubmissionService.inc.php(297): PKP\\Services\\PKPSubmissionService->getProperties(Object(Submission), Array, Array)\n#4 /var/www/html/journalfolder/lib/pkp/api/v1/_submissions/PKPBackendSubmissionsHandler.inc.php(158): PKP\\Services\\PKPSubmissionService->getBackendListProperties(Object(Submission), Array)\n#5 [internal function]: PKPBackendSubmissionsHandler->getMany(Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#6 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#7 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\\Handlers\\Strategies\\RequestResponse->__invoke(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#8 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\Route->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#9 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\\Route->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#10 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\\Route->run(Object(Slim\\Http\\Request), Object(APIResponse))\n#11 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(76): Slim\\App->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#12 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#13 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)\n#14 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#15 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#16 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#17 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#18 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)\n#19 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#20 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#21 /var/www/html/journalfolder/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#22 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#23 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)\n#24 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#25 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#26 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#27 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#28 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#29 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#30 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#31 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#32 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#33 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#34 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#35 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#36 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#37 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#38 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#39 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#40 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#41 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#42 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\\App->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#43 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\\App->process(Object(Slim\\Http\\Request), Object(APIResponse))\n#44 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#45 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#46 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#47 /var/www/html/journalfolder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#48 /var/www/html/journalfolder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\

When importing I get this error:

[Tue Jun 02 09:44:18.093493 2020] [php7:notice] [pid 4334] [client 0.0.0.0:25094] PHP Notice:  Only variables should be passed by reference in /var/www/html/journalfolder/plugins/importexport/native/filter/NativeXmlIssueGalleyFilter.inc.php on line 103, referer: https://mydomain.com/journalfolder/index.php/SLM/management/importexport/plugin/NativeImportExportPlugin
[Tue Jun 02 09:44:18.164223 2020] [php7:error] [pid 4334] [client 0.0.0.0:25094] PHP Fatal error:  Uncaught Error: Call to a member function getData() on null in /var/www/html/journalfolder/classes/search/ArticleSearchIndex.inc.php:38\nStack trace:\n#0 /var/www/html/journalfolder/plugins/importexport/native/filter/NativeXmlArticleFilter.inc.php(61): ArticleSearchIndex->submissionMetadataChanged(Object(Submission))\n#1 /var/www/html/journalfolder/lib/pkp/classes/filter/Filter.inc.php(449): NativeXmlArticleFilter->process(Object(DOMDocument))\n#2 /var/www/html/journalfolder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(260): Filter->execute(Object(DOMDocument))\n#3 /var/www/html/journalfolder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(238): NativeXmlIssueFilter->parseArticle(Object(DOMElement), Object(Issue))\n#4 /var/www/html/journalfolder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(134): NativeXmlIssueFilter->parseArticles(Object(DOMElement), Object(Issue))\n#5 /var/www/html/journalfolder/plugins/importexpo in /var/www/html/journalfolder/classes/search/ArticleSearchIndex.inc.php on line 38, referer: https://mydomain.com/journalfolder/index.php/SLM/management/importexport/plugin/NativeImportExportPlugin

Thanks for your help!

2

Hi @eddoff,

Thanks for reporting that.

An issue has been filed regarding this problem [Native Import/export: Unexpected error when importing · Issue #5960 · pkp/pkp-lib · GitHub]. Stay tuned for a solution. Is it possible to share with us (privately if you like) the import file that failed to import?

Regards,
@Dimitris_Efstathiou

3

This is the 500 error I got when I load management/importexport/plugin/NativeImportExportPlugin page:

image

This is the 500 error I got when I try to import:
image

4

Thanks! I can send it privately!

@eddoff

5

Greetings,

I also have a problem when trying to import articles in OJS 3.2.0-3.
I got the error “Element ‘{http://pkp.sfu.ca}author’: The attribute ‘id’ is required but missing.”

Is it mandatory to define an id to each author when importing?

Thanks for your help,

6

Hi,
I still have the same problem in version 3.2.1.0

@eddoff

7

@Dimitris_Efstathiou, Have you looked at this?
We can not upgrade to 3.2 until we have solved this issue, since we have a lot of data to import, and wish to do that with possibility to import reference lists!

The sample.xml provided with 3.2 does not work either to import. It has incorrect setup (no tag.

Best regards,
@eddoff

8

A maybe related error:
When i made the import, an empty issue was produced, and all sections given in the XML was imported!

I hardly can not delete any of the generated empty issues. I get the following error:

[Wed Jun 24 12:25:59.747982 2020] [php7:error] [pid 26281] [client xxx.xxx.xxx.xxx:4081] PHP Fatal error:  Uncaught Error: Call to a member function getLocalizedAbbrev() on null in /var/www/html/installfolder/classes/article/ArticleTombstoneManager.inc.php:31\nStack trace:\n#0 /var/www/html/installfolder/classes/controllers/grid/issues/IssueGridHandler.inc.php(314): ArticleTombstoneManager->insertArticleTombstone(Object(Submission), Object(Journal))\n#1 /var/www/html/installfolder/lib/pkp/classes/core/PKPRouter.inc.php(391): IssueGridHandler->deleteIssue(Array, Object(Request))\n#2 /var/www/html/installfolder/lib/pkp/classes/core/PKPComponentRouter.inc.php(257): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array)\n#3 /var/www/html/installfolder/lib/pkp/classes/core/Dispatcher.inc.php(143): PKPComponentRouter->route(Object(Request))\n#4 /var/www/html/installfolder/lib/pkp/classes/core/PKPApplication.inc.php(279): Dispatcher->dispatch(Object(Request))\n#5 /var/www/html/installfolder/index.php(68): PKPApplication->execute()\n#6 {main}\n  thrown in /var/www/html/installfolder/classes/article/ArticleTombstoneManager.inc.php on line 31, referer: https://domain.com/folder/index.php/PSE/manageIssues

After some update of the issue data and clicking back and forth on delete, unpublish a.s.o. I was able to delete them…

could that be related or say any of you something to help?

9

Hi @eddoff,

Could you probably try to replicate this error to see exactly when that error appears?

Thanks!

10

I have tried to replicate it

I started a new journal in a “clean” install of OJS 3.2.1.0 (another journal was created the day before yesterday, but there I got the errors, so I started a new journal). I made a dummy submission and published it in an issue. When I published the issue the OK-box did not disappear, however when I clicked outside the box and updated the page, the issue was in the “back issues”.

I exported the issue as native XML. I made some modifications of the metadata. I also removed the id-tags since I thought those were related to the exported issue/article.

I get an empty box as results:
image

No error message in browser, but this Fatal Error:

[Thu Jun 25 07:28:42.898039 2020] [php7:error] [pid 31554] [client xx.xx.xx.xx:3204] PHP Fatal error:  Uncaught Error: Call to a member function getData() on null in /var/www/html/folder/classes/search/ArticleSearchIndex.inc.php:38\nStack trace:\n#0 /var/www/html/folder/plugins/importexport/native/filter/NativeXmlArticleFilter.inc.php(61): ArticleSearchIndex->submissionMetadataChanged(Object(Submission))\n#1 /var/www/html/folder/lib/pkp/classes/filter/Filter.inc.php(449): NativeXmlArticleFilter->process(Object(DOMDocument))\n#2 /var/www/html/folder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(260): Filter->execute(Object(DOMDocument))\n#3 /var/www/html/folder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(238): NativeXmlIssueFilter->parseArticle(Object(DOMElement), Object(Issue))\n#4 /var/www/html/folder/plugins/importexport/native/filter/NativeXmlIssueFilter.inc.php(134): NativeXmlIssueFilter->parseArticles(Object(DOMElement), Object(Issue))\n#5 /var/www/html/folder/plugins/importexport/native/filter/Nati in /var/www/html/folder/classes/search/ArticleSearchIndex.inc.php on line 38, referer: https://domain.com/folder/index.php/bla/management/importexport/plugin/NativeImportExportPlugin

When changing from “Results” to another tab it is not possible to go back to “Results”.

I reload the page (…/management/importexport/plugin/NativeImportExportPlugin) and get:
image

I’ve got this error message in the log:

[Thu Jun 25 07:57:51.740277 2020] [php7:notice] [pid 11738] [client xx.xx.xx.xx:4574] Slim Application Error:\nType: Error\nMessage: Call to a member function getData() on null\nFile: /var/www/html/folder/lib/pkp/classes/submission/PKPSubmission.inc.php\nLine: 54\nTrace: #0 /var/www/html/folder/classes/services/PublicationService.inc.php(83): PKPSubmission->getBestId()\n#1 /var/www/html/folder/lib/pkp/classes/plugins/HookRegistry.inc.php(107): APP\\Services\\PublicationService->getPublicationProperties('Publication::ge...', Array)\n#2 /var/www/html/folder/lib/pkp/classes/services/PKPPublicationService.inc.php(222): HookRegistry::call('Publication::ge...', Array)\n#3 /var/www/html/folder/lib/pkp/classes/services/PKPPublicationService.inc.php(235): PKP\\Services\\PKPPublicationService->getProperties(Object(Publication), Array, Array)\n#4 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(204): PKP\\Services\\PKPPublicationService->getSummaryProperties(Object(Publication), Array)\n#5 [internal function]: PKP\\Services\\PKPSubmissionService->PKP\\Services\\{closure}(Object(Publication))\n#6 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(208): array_map(Object(Closure), Array)\n#7 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(297): PKP\\Services\\PKPSubmissionService->getProperties(Object(Submission), Array, Array)\n#8 /var/www/html/folder/lib/pkp/api/v1/_submissions/PKPBackendSubmissionsHandler.inc.php(158): PKP\\Services\\PKPSubmissionService->getBackendListProperties(Object(Submission), Array)\n#9 [internal function]: PKPBackendSubmissionsHandler->getMany(Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#10 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#11 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\\Handlers\\Strategies\\RequestResponse->__invoke(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#12 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\Route->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#13 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\\Route->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#14 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\\Route->run(Object(Slim\\Http\\Request), Object(APIResponse))\n#15 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(77): Slim\\App->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#16 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#17 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)\n#18 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#19 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#20 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#21 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#22 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)\n#23 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#24 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#25 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#26 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#27 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)\n#28 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#29 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#30 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#31 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#32 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#33 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#34 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#35 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#36 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#37 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#38 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#39 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#40 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#41 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#42 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#43 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#44 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#45 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#46 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\\App->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#47 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\\App->process(Object(Slim\\Http\\Request), Object(APIResponse))\n#48 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#49 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user

Browser 500 error:

Request URL: https://domain.com/folder/index.php/bla/api/v1/_submissions?searchPhrase=&count=100&offset=0&_=1593064670392
Request Method: GET
Status Code: 500 Internal Server Error
Remote Address: xx.xx.xx.xx:443
Referrer Policy: no-referrer-when-downgrade
Access-Control-Allow-Origin: *
Connection: close
Content-Length: 445
Content-Type: text/html;charset=UTF-8
Date: Thu, 25 Jun 2020 05:57:51 GMT
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.18
Set-Cookie: OJSSID=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; Max-Age=0; path=/testclean/
Set-Cookie: OJSSID=ev4sfodspic0mvu93pj57cpvvr; expires=Sat, 25-Jul-2020 05:57:51 GMT; Max-Age=2592000; path=/testclean/; domain=domain.com
Strict-Transport-Security: max-age=31536000
X-Powered-By: PHP/7.3.18
Accept: */*
Accept-Encoding: gzip, deflate, br
Accept-Language: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7
Cache-Control: no-cache
Connection: keep-alive
Cookie: OJSSID=ev4sfodspic0mvu93pj57cpvvr; _ga=GA1.2.1850397724.1576576648; _hjid=eb5ab55b-8967-423f-86cc-368b22db4655; __utmz=9675306.1578375694.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utmv=9675306.|1=Bes%C3%B6kare=Anst%C3%A4lld=1; cookieconsent_status=dismiss; _sp_id.f4e2=fd383d72-1669-495a-81bb-80a87353334b.1582094050.1.1582094359.1582094050.7c9b8b5d-e55b-49e4-ad33-342f84ed4a09; userIdP9=66af7ecb33ad29ea157e00ba6cd7aaef; langCookie=sv; _ga=GA1.3.1850397724.1576576648; __utma=9675306.1850397724.1576576648.1592309649.1592385310.9; _gid=GA1.2.487283531.1592800142; OJSSID=6aglu9ameb7s19duvt6ab9celq
Host: domain.com
Pragma: no-cache
Referer: https://domain.com/folder/index.php/bla/management/importexport/plugin/NativeImportExportPlugin
Sec-Fetch-Dest: empty
Sec-Fetch-Mode: cors
Sec-Fetch-Site: same-origin
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36
X-Requested-With: XMLHttpRequest
searchPhrase: 
count: 100
offset: 0
_: 1593064670392

Then I get the same error when going to “submissions”

[Thu Jun 25 07:59:06.143485 2020] [php7:notice] [pid 16275] [client xx.xx.xx.xx:4652] Slim Application Error:\nType: Error\nMessage: Call to a member function getData() on null\nFile: /var/www/html/folder/lib/pkp/classes/submission/PKPSubmission.inc.php\nLine: 54\nTrace: #0 /var/www/html/folder/classes/services/PublicationService.inc.php(83): PKPSubmission->getBestId()\n#1 /var/www/html/folder/lib/pkp/classes/plugins/HookRegistry.inc.php(107): APP\\Services\\PublicationService->getPublicationProperties('Publication::ge...', Array)\n#2 /var/www/html/folder/lib/pkp/classes/services/PKPPublicationService.inc.php(222): HookRegistry::call('Publication::ge...', Array)\n#3 /var/www/html/folder/lib/pkp/classes/services/PKPPublicationService.inc.php(235): PKP\\Services\\PKPPublicationService->getProperties(Object(Publication), Array, Array)\n#4 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(204): PKP\\Services\\PKPPublicationService->getSummaryProperties(Object(Publication), Array)\n#5 [internal function]: PKP\\Services\\PKPSubmissionService->PKP\\Services\\{closure}(Object(Publication))\n#6 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(208): array_map(Object(Closure), Array)\n#7 /var/www/html/folder/lib/pkp/classes/services/PKPSubmissionService.inc.php(297): PKP\\Services\\PKPSubmissionService->getProperties(Object(Submission), Array, Array)\n#8 /var/www/html/folder/lib/pkp/api/v1/_submissions/PKPBackendSubmissionsHandler.inc.php(158): PKP\\Services\\PKPSubmissionService->getBackendListProperties(Object(Submission), Array)\n#9 [internal function]: PKPBackendSubmissionsHandler->getMany(Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#10 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#11 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(281): Slim\\Handlers\\Strategies\\RequestResponse->__invoke(Array, Object(Slim\\Http\\Request), Object(APIResponse), Array)\n#12 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\Route->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#13 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/Route.php(268): Slim\\Route->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#14 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(503): Slim\\Route->run(Object(Slim\\Http\\Request), Object(APIResponse))\n#15 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiAuthorizationMiddleware.inc.php(77): Slim\\App->__invoke(Object(Slim\\Http\\Request), Object(APIResponse))\n#16 [internal function]: ApiAuthorizationMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#17 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiAuthorizationMiddleware), Array)\n#18 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#19 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Slim\\App))\n#20 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiCsrfMiddleware.inc.php(46): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#21 [internal function]: ApiCsrfMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#22 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiCsrfMiddleware), Array)\n#23 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#24 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#25 /var/www/html/folder/lib/pkp/classes/security/authorization/internal/ApiTokenDecodingMiddleware.inc.php(82): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#26 [internal function]: ApiTokenDecodingMiddleware->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#27 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(ApiTokenDecodingMiddleware), Array)\n#28 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#29 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#30 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(68): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#31 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#32 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#33 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#34 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#35 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(127): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#36 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#37 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#38 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#39 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#40 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(132): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#41 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#42 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array(Object(Closure), Array)\n#43 [internal function]: Slim\\DeferredCallable->__invoke(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#44 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\\DeferredCallable), Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#45 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\\App->Slim\\{closure}(Object(Slim\\Http\\Request), Object(APIResponse))\n#46 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/App.php(392): Slim\\App->callMiddlewareStack(Object(Slim\\Http\\Request), Object(APIResponse))\n#47 /var/www/html/folder/lib/pkp/classes/handler/APIHandler.inc.php(124): Slim\\App->process(Object(Slim\\Http\\Request), Object(APIResponse))\n#48 [internal function]: APIHandler->{closure}(Object(Slim\\Http\\Request), Object(APIResponse), Object(Closure))\n#49 /var/www/html/folder/lib/pkp/lib/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user

In “Archive” under “Submissions” i just see the spinner, and no articles listed.

Under Issues it looks like this:
image
and tryinig to edit there is only the spinner again:
image
No issue data is imported.

When I imported the first example (in the beginning of this thread), there was a issue galley imported and the sections were imported from the XML, but not the issue data.

I haven’t looked into the database yet. I am not so familiar to the setup there so then I need some guidance…

Hope this explanation helps you to understand my issue!

Best regards,

@eddoff

11

This was the file I imported in my last post.

<?xml version="1.0"?>
<issue xmlns="http://pkp.sfu.ca" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" published="1" current="1" access_status="1" url_path="" xsi:schemaLocation="http://pkp.sfu.ca native.xsd">
  <issue_identification>
    <volume>1</volume>
    <number>2</number>
  </issue_identification>
  <date_published>2020-06-25</date_published>
  <last_modified>2020-06-25</last_modified>
  <sections>
    <section ref="ART" seq="0" editor_restricted="0" meta_indexed="1" meta_reviewed="1" abstracts_not_required="0" hide_title="0" hide_author="0" abstract_word_count="0">
      <id type="internal" advice="ignore">45</id>
      <abbrev locale="en_US">ART</abbrev>
      <policy locale="en_US">Section default policy</policy>
      <title locale="en_US">Articles</title>
    </section>
  </sections>
  <issue_galleys xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://pkp.sfu.ca native.xsd"/>
  <articles xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://pkp.sfu.ca native.xsd">
    <article xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" date_submitted="2020-06-25" status="3" submission_progress="0" current_publication_id="6" stage="production">
      <publication xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" locale="en_US" version="1" status="3" primary_contact_id="16" url_path="" seq="0" date_published="2020-06-25" section_ref="ART" access_status="0" xsi:schemaLocation="http://pkp.sfu.ca native.xsd">
        <title locale="en_US">title2</title>
        <abstract locale="en_US">&lt;p&gt;abstract&lt;/p&gt;</abstract>
        <copyrightHolder locale="en_US">blaaa</copyrightHolder>
        <copyrightYear>2020</copyrightYear>
        <authors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://pkp.sfu.ca native.xsd">
          <author include_in_browse="true" user_group_ref="Author" seq="0" id="16">
            <givenname locale="en_US">name3</givenname>
            <familyname locale="en_US">name5</familyname>
            <country>SE</country>
            <email>bla@bla.com</email>
          </author>
        </authors>
        <pages>3</pages>
      </publication>
    </article>
  </articles>
</issue>
12

Hi @eddoff.

Thanks for testing those functionalities, it’s been really helpful.

A PR is added to the [Native Import/export: Unexpected error when importing · Issue #5960 · pkp/pkp-lib · GitHub]. You can try and check if that fixes your issue - The code needs a change in the DB too, which will occur on updating your OJS installation, but not if you just apply the code.

The DB change is update filter_groups set output_type='class::classes.publication.Publication[]' where symbolic = 'native-xml=>Publication'

Please check the exported file: it lacks something like <id type="internal" advice="ignore">6</id> for the publication object. That means that the current_publication_id="6" of the submission entry can’t find which publication to correlate with.

Regarding other comments on that post:

  1. The author needs the source id, because from 3.2.0 version and after, the addition of the Publication object adds some more considerations regarding author data. Why wouldn’t you want that data in the export, though?

  2. Please, if you find Submissions in your DB that don’t have a submission that corresponds to a Publication, and are created by previous native imports, please erase them: Query to find them. You can erase them, if you are sure that those submissions are imported from native import plugin. Check if this will fix the javascript errors that you have posted.

    select * from submissions a
    join publications b on a.current_publication_id = b.publication_id
    where b.submission_id <> a.submission_id

Please If you find any more issues, don’t hesitate to add to this post.

Regards,
@Dimitris_Efstathiou

13

Dear @Dimitris_Efstathiou

This seems to have solved at least part of my issue!

I made the query as in your example and found one matching record:

+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+----------------+---------------+----------------+---------------------+--------+--------------------+------------+-----+---------------+--------+----------+---------+
| submission_id | locale | context_id | section_id | current_publication_id | date_last_activity  | date_submitted      | last_modified       | stage_id | status | submission_progress | work_type | publication_id | access_status | date_published | last_modified       | locale | primary_contact_id | section_id | seq | submission_id | status | url_path | version |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+----------------+---------------+----------------+---------------------+--------+--------------------+------------+-----+---------------+--------+----------+---------+
|             8 | NULL   |          2 |       NULL |                      6 | 2020-06-25 05:28:42 | 2020-06-25 00:00:00 | 2020-06-25 05:28:42 |        5 |      3 |                   0 |         0 |              6 |             0 | 2020-06-25     | 2020-06-25 05:21:48 | en_US  |                 16 |         45 |   0 |             6 |      3 | NULL     |       1 |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+----------------+---------------+----------------+---------------------+--------+--------------------+------------+-----+---------------+--------+----------+---------+

I removed it with the deleteSubmissions.php tool. However I still got the error so I removed all except submission_id 6.

+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+
| submission_id | locale | context_id | section_id | current_publication_id | date_last_activity  | date_submitted      | last_modified       | stage_id | status | submission_progress | work_type |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+
|             1 | NULL   |          1 |       NULL |                      0 | 2020-06-23 07:35:45 | 2013-03-04 00:00:00 | 2020-06-23 07:35:45 |        5 |      1 |                   0 |         0 |
|             2 | NULL   |          1 |       NULL |                      0 | 2020-06-24 10:13:22 | 2013-03-04 00:00:00 | 2020-06-24 10:13:22 |        5 |      1 |                   0 |         0 |
|             3 | NULL   |          1 |       NULL |                      0 | 2020-06-24 10:17:20 | 2013-03-04 00:00:00 | 2020-06-24 10:17:20 |        5 |      1 |                   0 |         0 |
|             4 | NULL   |          1 |       NULL |                      0 | 2020-06-24 10:34:34 | 2013-03-04 00:00:00 | 2020-06-24 10:34:34 |        5 |      1 |                   0 |         0 |
|             5 | NULL   |          1 |       NULL |                      0 | 2020-06-24 13:16:34 | 2013-03-04 00:00:00 | 2020-06-24 10:36:08 |        5 |      1 |                   0 |         0 |
|             6 | NULL   |          2 |       NULL |                      6 | 2020-06-25 05:21:48 | 2020-06-25 05:18:48 | 2020-06-25 05:18:00 |        5 |      3 |                   0 |         0 |
|             7 | NULL   |          2 |       NULL |                      7 | 2020-06-25 05:18:54 | NULL                | 2020-06-25 05:18:54 |        1 |      1 |                   1 |         0 |
|             8 | NULL   |          2 |       NULL |                      6 | 2020-06-25 05:28:42 | 2020-06-25 00:00:00 | 2020-06-25 05:28:42 |        5 |      3 |                   0 |         0 |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+

Now I don’t get any error, but the submission 6 is not visible in the web view. I guess all of them were imported with native XML in the 3.2 version.

Now I can import the test-file that i exported from OJS, reinserting the id tag.

However, I tested now with my first file, but still I cannot import that one!
No information appears.

image

When I go to “submissions” only one of the imported article is shown, however in the database there are several (id 6 is the old submission left from before the patch and 10 is from import of the test-file):

image

> select * from submissions;
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+
| submission_id | locale | context_id | section_id | current_publication_id | date_last_activity  | date_submitted      | last_modified       | stage_id | status | submission_progress | work_type |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+
|             6 | NULL   |          2 |       NULL |                      6 | 2020-06-25 05:21:48 | 2020-06-25 05:18:48 | 2020-06-25 05:18:00 |        5 |      3 |                   0 |         0 |
|            10 | NULL   |          1 |       NULL |                     10 | 2020-06-29 13:10:15 | 2020-06-25 00:00:00 | 2020-06-29 13:10:15 |        5 |      3 |                   0 |         0 |
|            11 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:42 | 2013-03-04 00:00:00 | 2020-06-29 13:12:42 |        5 |      0 |                   0 |         0 |
|            12 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:43 | 2013-03-04 00:00:00 | 2020-06-29 13:12:43 |        5 |      0 |                   0 |         0 |
|            13 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:44 | 2013-03-04 00:00:00 | 2020-06-29 13:12:44 |        5 |      0 |                   0 |         0 |
|            14 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:45 | 2013-03-04 00:00:00 | 2020-06-29 13:12:45 |        5 |      0 |                   0 |         0 |
|            15 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:46 | 2013-03-04 00:00:00 | 2020-06-29 13:12:46 |        5 |      0 |                   0 |         0 |
|            16 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:46 | 2013-03-04 00:00:00 | 2020-06-29 13:12:46 |        5 |      0 |                   0 |         0 |
|            17 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:46 | 2013-03-04 00:00:00 | 2020-06-29 13:12:46 |        5 |      0 |                   0 |         0 |
|            18 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:47 | 2013-03-04 00:00:00 | 2020-06-29 13:12:47 |        5 |      0 |                   0 |         0 |
|            19 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:47 | 2013-03-04 00:00:00 | 2020-06-29 13:12:47 |        5 |      0 |                   0 |         0 |
|            20 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:47 | 2013-03-04 00:00:00 | 2020-06-29 13:12:47 |        5 |      0 |                   0 |         0 |
|            21 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:48 | 2013-03-04 00:00:00 | 2020-06-29 13:12:48 |        5 |      0 |                   0 |         0 |
|            22 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:48 | 2013-03-04 00:00:00 | 2020-06-29 13:12:48 |        5 |      0 |                   0 |         0 |
|            23 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:48 | 2013-03-04 00:00:00 | 2020-06-29 13:12:48 |        5 |      0 |                   0 |         0 |
|            24 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:49 | 2013-03-04 00:00:00 | 2020-06-29 13:12:49 |        5 |      0 |                   0 |         0 |
|            25 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:49 | 2013-03-04 00:00:00 | 2020-06-29 13:12:49 |        5 |      0 |                   0 |         0 |
|            26 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:49 | 2013-03-04 00:00:00 | 2020-06-29 13:12:49 |        5 |      0 |                   0 |         0 |
|            27 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:50 | 2013-03-04 00:00:00 | 2020-06-29 13:12:50 |        5 |      0 |                   0 |         0 |
|            28 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:50 | 2013-03-04 00:00:00 | 2020-06-29 13:12:50 |        5 |      0 |                   0 |         0 |
|            29 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:50 | 2013-03-04 00:00:00 | 2020-06-29 13:12:50 |        5 |      0 |                   0 |         0 |
|            30 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:51 | 2013-03-04 00:00:00 | 2020-06-29 13:12:51 |        5 |      0 |                   0 |         0 |
|            31 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:51 | 2013-03-04 00:00:00 | 2020-06-29 13:12:51 |        5 |      0 |                   0 |         0 |
|            32 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:51 | 2013-03-04 00:00:00 | 2020-06-29 13:12:51 |        5 |      0 |                   0 |         0 |
|            33 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:52 | 2013-03-04 00:00:00 | 2020-06-29 13:12:52 |        5 |      0 |                   0 |         0 |
|            34 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:52 | 2013-03-04 00:00:00 | 2020-06-29 13:12:52 |        5 |      0 |                   0 |         0 |
|            35 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:53 | 2013-03-04 00:00:00 | 2020-06-29 13:12:53 |        5 |      0 |                   0 |         0 |
|            36 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:53 | 2013-03-04 00:00:00 | 2020-06-29 13:12:53 |        5 |      0 |                   0 |         0 |
|            37 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:53 | 2013-03-04 00:00:00 | 2020-06-29 13:12:53 |        5 |      0 |                   0 |         0 |
|            38 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:54 | 2013-03-04 00:00:00 | 2020-06-29 13:12:54 |        5 |      0 |                   0 |         0 |
|            39 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:54 | 2013-03-04 00:00:00 | 2020-06-29 13:12:54 |        5 |      0 |                   0 |         0 |
|            40 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:54 | 2013-03-04 00:00:00 | 2020-06-29 13:12:54 |        5 |      0 |                   0 |         0 |
|            41 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:54 | 2013-03-04 00:00:00 | 2020-06-29 13:12:54 |        5 |      0 |                   0 |         0 |
|            42 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:55 | 2013-03-04 00:00:00 | 2020-06-29 13:12:55 |        5 |      0 |                   0 |         0 |
|            43 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:55 | 2013-03-04 00:00:00 | 2020-06-29 13:12:55 |        5 |      0 |                   0 |         0 |
|            44 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:55 | 2013-03-04 00:00:00 | 2020-06-29 13:12:55 |        5 |      0 |                   0 |         0 |
|            45 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:56 | 2013-03-04 00:00:00 | 2020-06-29 13:12:56 |        5 |      0 |                   0 |         0 |
|            46 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:56 | 2013-03-04 00:00:00 | 2020-06-29 13:12:56 |        5 |      0 |                   0 |         0 |
|            47 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:56 | 2013-03-04 00:00:00 | 2020-06-29 13:12:56 |        5 |      0 |                   0 |         0 |
|            48 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:56 | 2013-03-04 00:00:00 | 2020-06-29 13:12:56 |        5 |      0 |                   0 |         0 |
|            49 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:57 | 2013-03-04 00:00:00 | 2020-06-29 13:12:57 |        5 |      0 |                   0 |         0 |
|            50 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:57 | 2013-03-04 00:00:00 | 2020-06-29 13:12:57 |        5 |      0 |                   0 |         0 |
|            51 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:57 | 2013-03-04 00:00:00 | 2020-06-29 13:12:57 |        5 |      0 |                   0 |         0 |
|            52 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:58 | 2013-03-04 00:00:00 | 2020-06-29 13:12:58 |        5 |      0 |                   0 |         0 |
|            53 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:58 | 2013-03-04 00:00:00 | 2020-06-29 13:12:58 |        5 |      0 |                   0 |         0 |
|            54 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:58 | 2013-03-04 00:00:00 | 2020-06-29 13:12:58 |        5 |      0 |                   0 |         0 |
|            55 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:59 | 2013-03-04 00:00:00 | 2020-06-29 13:12:59 |        5 |      0 |                   0 |         0 |
|            56 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:59 | 2013-03-04 00:00:00 | 2020-06-29 13:12:59 |        5 |      0 |                   0 |         0 |
|            57 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:59 | 2013-03-04 00:00:00 | 2020-06-29 13:12:59 |        5 |      0 |                   0 |         0 |
|            58 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:12:59 | 2013-03-04 00:00:00 | 2020-06-29 13:12:59 |        5 |      0 |                   0 |         0 |
|            59 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:00 | 2013-03-04 00:00:00 | 2020-06-29 13:13:00 |        5 |      0 |                   0 |         0 |
|            60 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:00 | 2013-03-04 00:00:00 | 2020-06-29 13:13:00 |        5 |      0 |                   0 |         0 |
|            61 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:00 | 2013-03-04 00:00:00 | 2020-06-29 13:13:00 |        5 |      0 |                   0 |         0 |
|            62 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:01 | 2013-03-04 00:00:00 | 2020-06-29 13:13:01 |        5 |      0 |                   0 |         0 |
|            63 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:01 | 2013-03-04 00:00:00 | 2020-06-29 13:13:01 |        5 |      0 |                   0 |         0 |
|            64 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:01 | 2013-03-04 00:00:00 | 2020-06-29 13:13:01 |        5 |      0 |                   0 |         0 |
|            65 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:01 | 2013-03-04 00:00:00 | 2020-06-29 13:13:01 |        5 |      0 |                   0 |         0 |
|            66 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:02 | 2013-03-04 00:00:00 | 2020-06-29 13:13:02 |        5 |      0 |                   0 |         0 |
|            67 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:02 | 2013-03-04 00:00:00 | 2020-06-29 13:13:02 |        5 |      0 |                   0 |         0 |
|            68 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:02 | 2013-03-04 00:00:00 | 2020-06-29 13:13:02 |        5 |      0 |                   0 |         0 |
|            69 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:03 | 2013-03-04 00:00:00 | 2020-06-29 13:13:03 |        5 |      0 |                   0 |         0 |
|            70 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:03 | 2013-03-04 00:00:00 | 2020-06-29 13:13:03 |        5 |      0 |                   0 |         0 |
|            71 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:03 | 2013-03-04 00:00:00 | 2020-06-29 13:13:03 |        5 |      0 |                   0 |         0 |
|            72 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:04 | 2013-03-04 00:00:00 | 2020-06-29 13:13:04 |        5 |      0 |                   0 |         0 |
|            73 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:04 | 2013-03-04 00:00:00 | 2020-06-29 13:13:04 |        5 |      0 |                   0 |         0 |
|            74 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:04 | 2013-03-04 00:00:00 | 2020-06-29 13:13:04 |        5 |      0 |                   0 |         0 |
|            75 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:04 | 2013-03-04 00:00:00 | 2020-06-29 13:13:04 |        5 |      0 |                   0 |         0 |
|            76 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:05 | 2013-03-04 00:00:00 | 2020-06-29 13:13:05 |        5 |      0 |                   0 |         0 |
|            77 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:05 | 2013-03-04 00:00:00 | 2020-06-29 13:13:05 |        5 |      0 |                   0 |         0 |
|            78 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:05 | 2013-03-04 00:00:00 | 2020-06-29 13:13:05 |        5 |      0 |                   0 |         0 |
|            79 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:06 | 2013-03-04 00:00:00 | 2020-06-29 13:13:06 |        5 |      0 |                   0 |         0 |
|            80 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:06 | 2013-03-04 00:00:00 | 2020-06-29 13:13:06 |        5 |      0 |                   0 |         0 |
|            81 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:06 | 2013-03-04 00:00:00 | 2020-06-29 13:13:06 |        5 |      0 |                   0 |         0 |
|            82 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:06 | 2013-03-04 00:00:00 | 2020-06-29 13:13:06 |        5 |      0 |                   0 |         0 |
|            83 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:07 | 2013-03-04 00:00:00 | 2020-06-29 13:13:07 |        5 |      0 |                   0 |         0 |
|            84 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:07 | 2013-03-04 00:00:00 | 2020-06-29 13:13:07 |        5 |      0 |                   0 |         0 |
|            85 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:07 | 2013-03-04 00:00:00 | 2020-06-29 13:13:07 |        5 |      0 |                   0 |         0 |
|            86 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:08 | 2013-03-04 00:00:00 | 2020-06-29 13:13:08 |        5 |      0 |                   0 |         0 |
|            87 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:08 | 2013-03-04 00:00:00 | 2020-06-29 13:13:08 |        5 |      0 |                   0 |         0 |
|            88 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:08 | 2013-03-04 00:00:00 | 2020-06-29 13:13:08 |        5 |      0 |                   0 |         0 |
|            89 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:08 | 2013-03-04 00:00:00 | 2020-06-29 13:13:08 |        5 |      0 |                   0 |         0 |
|            90 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:09 | 2013-03-04 00:00:00 | 2020-06-29 13:13:09 |        5 |      0 |                   0 |         0 |
|            91 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:09 | 2013-03-04 00:00:00 | 2020-06-29 13:13:09 |        5 |      0 |                   0 |         0 |
|            92 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:09 | 2013-03-04 00:00:00 | 2020-06-29 13:13:09 |        5 |      0 |                   0 |         0 |
|            93 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:09 | 2013-03-04 00:00:00 | 2020-06-29 13:13:09 |        5 |      0 |                   0 |         0 |
|            94 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:10 | 2013-03-04 00:00:00 | 2020-06-29 13:13:10 |        5 |      0 |                   0 |         0 |
|            95 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:10 | 2013-03-04 00:00:00 | 2020-06-29 13:13:10 |        5 |      0 |                   0 |         0 |
|            96 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:10 | 2013-03-04 00:00:00 | 2020-06-29 13:13:10 |        5 |      0 |                   0 |         0 |
|            97 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:11 | 2013-03-04 00:00:00 | 2020-06-29 13:13:11 |        5 |      0 |                   0 |         0 |
|            98 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:11 | 2013-03-04 00:00:00 | 2020-06-29 13:13:11 |        5 |      0 |                   0 |         0 |
|            99 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:11 | 2013-03-04 00:00:00 | 2020-06-29 13:13:11 |        5 |      0 |                   0 |         0 |
|           100 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:12 | 2013-03-04 00:00:00 | 2020-06-29 13:13:12 |        5 |      0 |                   0 |         0 |
|           101 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:12 | 2013-03-04 00:00:00 | 2020-06-29 13:13:12 |        5 |      0 |                   0 |         0 |
|           102 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:12 | 2013-03-04 00:00:00 | 2020-06-29 13:13:12 |        5 |      0 |                   0 |         0 |
|           103 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:12 | 2013-03-04 00:00:00 | 2020-06-29 13:13:12 |        5 |      0 |                   0 |         0 |
|           104 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           105 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           106 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           107 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           108 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           109 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           110 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           111 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:13 | 2013-03-04 00:00:00 | 2020-06-29 13:13:13 |        5 |      0 |                   0 |         0 |
|           112 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:14 | 2013-03-04 00:00:00 | 2020-06-29 13:13:14 |        5 |      0 |                   0 |         0 |
|           113 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:14 | 2013-03-04 00:00:00 | 2020-06-29 13:13:14 |        5 |      0 |                   0 |         0 |
|           114 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:14 | 2013-03-04 00:00:00 | 2020-06-29 13:13:14 |        5 |      0 |                   0 |         0 |
|           115 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:14 | 2013-03-04 00:00:00 | 2020-06-29 13:13:14 |        5 |      0 |                   0 |         0 |
|           116 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:15 | 2013-03-04 00:00:00 | 2020-06-29 13:13:15 |        5 |      0 |                   0 |         0 |
|           117 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:15 | 2013-03-04 00:00:00 | 2020-06-29 13:13:15 |        5 |      0 |                   0 |         0 |
|           118 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:15 | 2013-03-04 00:00:00 | 2020-06-29 13:13:15 |        5 |      0 |                   0 |         0 |
|           119 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:15 | 2013-03-04 00:00:00 | 2020-06-29 13:13:15 |        5 |      0 |                   0 |         0 |
|           120 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:16 | 2013-03-04 00:00:00 | 2020-06-29 13:13:16 |        5 |      0 |                   0 |         0 |
|           121 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:16 | 2013-03-04 00:00:00 | 2020-06-29 13:13:16 |        5 |      0 |                   0 |         0 |
|           122 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:16 | 2013-03-04 00:00:00 | 2020-06-29 13:13:16 |        5 |      0 |                   0 |         0 |
|           123 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:17 | 2013-03-04 00:00:00 | 2020-06-29 13:13:17 |        5 |      0 |                   0 |         0 |
|           124 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:17 | 2013-03-04 00:00:00 | 2020-06-29 13:13:17 |        5 |      0 |                   0 |         0 |
|           125 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:17 | 2013-03-04 00:00:00 | 2020-06-29 13:13:17 |        5 |      0 |                   0 |         0 |
|           126 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:17 | 2013-03-04 00:00:00 | 2020-06-29 13:13:17 |        5 |      0 |                   0 |         0 |
|           127 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:18 | 2013-03-04 00:00:00 | 2020-06-29 13:13:18 |        5 |      0 |                   0 |         0 |
|           128 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:18 | 2013-03-04 00:00:00 | 2020-06-29 13:13:18 |        5 |      0 |                   0 |         0 |
|           129 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:18 | 2013-03-04 00:00:00 | 2020-06-29 13:13:18 |        5 |      0 |                   0 |         0 |
|           130 | NULL   |          1 |       NULL |                      0 | 2020-06-29 13:13:18 | 2013-03-04 00:00:00 | 2020-06-29 13:13:18 |        5 |      0 |                   0 |         0 |
|           131 | NULL   |          1 |       NULL |                    126 | 2020-06-29 13:13:19 | 2013-03-04 00:00:00 | 2020-06-29 13:13:19 |        5 |      3 |                   0 |         0 |
+---------------+--------+------------+------------+------------------------+---------------------+---------------------+---------------------+----------+--------+---------------------+-----------+

Thanks for all help!
@eddoff

14

Dear @Dimitris_Efstathiou

Do you think there are other bugs in the system, since I still don’t get any error message when trying to import my xml-file? Maybe there are some tags in the XSD schema (like the ID-tags) that should be mandatory…?

@eddoff

15

Dear @Dimitris_Efstathiou, @asmecher and others

I have still problems with the Native Import. I have made a fresh install of ojs 3.2.1-1 and made the corrections in Native Import/export: Unexpected error when importing · Issue #5960 · pkp/pkp-lib · GitHub. I can import a file that has been exported from the same version, but when I try to make my own import file I get similar problem as I described above.

I also tried to use the XML proposed in this thread: HttpError while importing native xml issue ojs 3.2.0-2 - #12 by hsh01 but that does not work either. I get a blank screen.

This is a Fatal Error I have got

[Fri Oct 02 06:14:59.849365 2020] [php7:error] [pid 19857] [client xx.xx.xx.xx:xxx] PHP Fatal error: Uncaught Exception: DB Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Query: SELECT\ts. *\n\t\t\tFROM\tsections s, section_settings l\n\t\t\tWHERE\tl.section_id = s.section_id AND\n\t\t\t\tl.setting_name = ? AND\n\t\t\t\tl.setting_value = ? AND\n\t\t\t\ts.journal_id = ? in //lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /path-to-ojs/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), 'SELECT\ts.* \n\t\t\tF...')\n#1 /path-to-ojs/classes/journal/SectionDAO.inc.php(101): DAO->retrieve('SELECT\ts.*\n\t\t\tF...', Array)\n#2 /path-to-ojs/plugins/importexport/native/filter/NativeXmlPublicationFilter.inc.php(40): SectionDAO->getByAbbrev('\xD1\x81\xD1\x82', 1)\n#3 /path-to-ojs/lib/pkp/plugins/importexport/native/filter/NativeImportFilter.inc.php(60): NativeXmlPublicationFilter->handleElement(Object(DOMElement))\n#4 /path-to-ojs/lib/pk in /path-to-ojs/lib/pkp/classes/db/DAO.inc.php on line 703, referer: https://domain.com/index.php/test/management/importexport/plugin/NativeImportExportPlugin`

The settings in my config.inc.php is client_charset = utf-8 and connection_charset = utf8 Could it relate to that the database_charset variable is removed in the later versions?

Can you please also update the xml samples in ojs/plugins/importexport/native at 3_2_1-1 · pkp/ojs · GitHub so that they work for the current version?

16

Hi @eddoff,

This issue [New sample file for Native Import/export · Issue #6265 · pkp/pkp-lib · GitHub] is posted and there is a PR, that it would help if you could check, regarding the sample XML file for import/export.

Regarding the fatal error above, it seems that your file has characters that can not be inserted or retrieved from the DB. (like ‘\xD1\x81\xD1\x82’). If you use other export methods, like Crossref export, and check the produced XML, do you get any wrong encodings?

Thanks

17

Hi

Yes, it seems to be problems in some special characters.
From the crossref export
The Coand? Effect
should be an “ă” here

This is also how it is shown in the system.

I had no such problem for imports to OJS 3.1

Edvin

18

Hi @Dimitris_Efstathiou @eddoff and thank you for your posts what made me get at this point. OJS 3.2.0.2 trying to import issues. I followed this steps:

  1. Exported issues using native XML plugin from a shared multijournal OJS 3.1.1.4
  2. Imported issues on a local OJS 3.1.1.4 succesfully
  3. Upgraded local OJS to 3.2.0.2 succesfully
  4. Exported issues using native plugin succesfully
  5. Tried to import the XML files into another shared multijournal OJS 3.2.0.2 but we’ve got that 500 errors.
  6. Erased the failed submissions from the submissions table in database as described by @Dimitris_Efstathiou
  7. Also tried fix described at the PR added to [Native Import/export: Unexpected error when importing · Issue #5960 · pkp/pkp-lib · GitHub]. It solved the 500 errors. However it’s no possible to import the files due to the error “The submission’s current publication is missing”
    Captura de pantalla 2021-02-25 a las 18.33.25
  8. I thing this error could be related to the fix described at the PR, because one of the file changes is adding that language string to the manager.po file:
    msgid “plugins.importexport.common.error.currentPublicationNullOrMissing”
    msgstr “The submission’s current publication is missing”
  9. Compared the 2 .xsd files with the schema of exported files. It seems to be good, but not an expert.
  10. Tried to import this test XML file with the same result ojs/export-issues.xml at stable-3_2_1 · pkp/ojs · GitHub

So I think XML schema is fine but maybe there is a bug in OJS 3.2 and/or the fix requested doesn’t fully fix it.

What do you think? Is it possible to work it around somehow?

Thank you and regards to the community,
@celuloide

19

Hi,
Please, anybody? Is it possible to work this issue around? @asmecher @bozana?
It is a quite large archive to be migrated…

Thank you,
@celuloide

20

Hi @celuloide,

Are you sure you don’t have any submissions in the XML for which there isn’t at least one publication? At least one publication is required for every submission but it sounds like some may be missing.

Regards,
Alec Smecher
Public Knowledge Project Team