PKP PN plugin fail

Software Support
1

Hi

We use ojs3.3.10 and activate pkp pn for one journal but no deposits, on log apear this

[2022-10-04 06:21:53] https://revistas.ucm.es
[2022-10-04 06:21:53] [Notificación] Se ha iniciado la tarea.
[2022-10-04 06:21:53] [Notificación] PLN Depositor executeActions started
[2022-10-04 06:21:53] [Notificación] ##plugins.generic.pln.notifications.processing_for##
[2022-10-04 06:21:53] [Notificación] ##plugins.generic.pln.notifications.getting_servicedocument##

Thanks

3

Hi!

FYI the last message refers to Getting service document.

Assuming there’s nothing more on your log, then as far as I know, we’ve been experiencing an infrastructure instability this week, which would explain a failure in this step.

Hopefully everything will be normalized soon :slight_smile:

Best,
Jonas

4

Hi

The process now is pending from 04-10-2022 for all articles, there is a process to force to deposit ?

Thnks

5

Hi!

I can see 97 journals were registered from your domain, and I can see the terms were accepted. But looks like none of them have sent deposits so far, is there something new on the log?

Best,
Jonas

6

Hi
Is correct there is 97 but only one at moment is active, the today logs is

[2022-10-17 06:22:14] https://revistas.ucm.es
[2022-10-17 06:22:14] [Notificación] Se ha iniciado la tarea.
[2022-10-17 06:22:14] [Notificación] PLN Depositor executeActions started
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.notifications.processing_for##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.notifications.getting_servicedocument##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.depositor.statusupdates##
[2022-10-17 06:22:14] [Notificación] ##plugins.generic.pln.depositor.updatedcontent##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.newcontent##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits##
[2022-10-17 06:22:16] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits.processing##
[2022-10-17 06:22:17] [Notificación] ##plugins.generic.pln.depositor.packagingdeposits.processing.packageSucceeded##
Thnks

7

There should be more messages in the log, basically the last message should be [2022-10-17 06:22:17] [Notice] Task process stopped.).

I guess an error happened while it was processing. Isn’t there anything in the error log?

Best,
Jonas

8

Hi
There is not any more in the log file, what should be happening ?

thnks

9

Hi @Enrique_Manuel_Touce,

I meant the error log from your server, where you’ll be able to see unexpected PHP errors.

If you don’t know where it’s located, you can access this link https://revistas.ucm.es/index.php/admin/phpinfo and search for error_log.

Best,
Jonas

10

Hi

Yes, your are correct there is an error in error_log

[Mon Oct 17 08:22:17.028311 2022] [php7:error] [pid 118252] [client 66.249.76.234:64753] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘export_deposit_error’ in ‘field list’ in /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115\nStack trace:\n#0 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute()\n#1 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}()\n#3 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback()\n#4 /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\Connection->run()\n#5 /srv/www/htdocs/ojsucm/li in /srv/www/htdocs/ojsucm/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

Thnks

11

Hi!

I’ve already seen this error before (if you want more details, you can search for export_deposit_error in the forum) :slight_smile:

In order to fix it, please run this query against your database:
ALTER TABLE pln_deposits ADD COLUMN export_deposit_error VARCHAR(1000) NULL

Then let me know if it solved you problem.

Best,
Jonas

12

Hi

Tomorrow i will see log and tell you

Thnks

1 Like
13

This topic was automatically closed after 42 days. New replies are no longer allowed.