@ronniebrito @Ronnie_Fagundes_de_B instalamos o plugin FulJournalTrasnfer para migrar o periódico do IFRS hospedado na UFRGS em http://seer.ufrgs.br/ScientiaTec/index para o Portal Periódicos do IFRS https://periodicos.ifrs.edu.br/
Obs: UFRGS utiliza o banco de dados MySQL e aqui no IFRS Reitoria utilizamos o banco de dados PostgreSQL
Executei o seguinte comando:
php importExport.php FullJournalImportExportPlugin import tmp/ScientiaTec.tar.gz
E ocorreu o seguinte erro:
DB Error: ERROR: invalid input syntax for integer: ""
ojs2: DB Error: ERROR: invalid input syntax for integer: ""
---
**Com o debug habilitado, executamos novamente e o erro mostrado foi:**
---
# php importExport.php FullJournalImportExportPlugin import tmp/ScientiaTec.tar.gz
DB Error: ERROR: invalid input syntax for integer: ""
Stack Trace:
File: /home/ifrs/site_periodicos/periodicos/lib/pkp/classes/submission/reviewAssignment/PKPReviewAssignmentDAO.inc.php line 496
Function: DAO->update("INSERT INTO review_assignments (
submission_id,
reviewer...", Array(17))
File: /home/ifrs/site_periodicos/periodicos/plugins/importexport/fullJournalTransfer/XMLDisassembler.inc.php line 786
Function: PKPReviewAssignmentDAO->insertObject(Object(ReviewAssignment))
File: /home/ifrs/site_periodicos/periodicos/plugins/importexport/fullJournalTransfer/XMLDisassembler.inc.php line 108
Function: XMLDisassembler->importArticles()
File: /home/ifrs/site_periodicos/periodicos/plugins/importexport/fullJournalTransfer/FullJournalImportExportPlugin.inc.php line 255
Function: XMLDisassembler->startImporting()
File: /home/ifrs/site_periodicos/periodicos/plugins/importexport/fullJournalTransfer/FullJournalImportExportPlugin.inc.php line 111
Function: FullJournalImportExportPlugin->handleImport("/home/ifrs/site_periodicos/periodicos/tools/tmp/ScientiaTec.tar....", True)
File: /home/ifrs/site_periodicos/periodicos/tools/importExport.php line 63
Function: FullJournalImportExportPlugin->executeCLI("importExport.php", Array(0))
File: /home/ifrs/site_periodicos/periodicos/tools/importExport.php line 69
Function: importExport->execute()
ojs2: DB Error: ERROR: invalid input syntax for integer: ""