OJS 3.2 Upgrade Error -- publication_id cannot be null in 3.2.0_versioning.xml

Trying to upgrade OJS to 3_2_0-0 from version 3_1_2-4 (ubuntu 18.04, mysql 5.7, php 7.2) and seeing the following error:

PKP-Database-Logger 1583784827.8818: Query:
UPDATE authors as a
SET a.publication_id = (
SELECT s.current_publication_id
FROM submissions as s
LEFT JOIN temp_authors as ta
ON s.submission_id = ta.submission_id
WHERE a.author_id = ta.author_id
)
failed. Column ‘publication_id’ cannot be null
PKP-Database-Logger 1583784827.8818: 1048: Column ‘publication_id’ cannot be null
ADOConnection._Execute( UPDATE authors as a SET a.publication_id = ( SELECT s.current_publication_id FROM submissions as s LEFT JOIN …, false)% line 1246, file: /app/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.Execute( UPDATE authors as a SET a.publication_id = ( SELECT s.current_publication_id FROM submissions as s LEFT JOIN …)% line 442, file: /app/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL( UPDATE authors as a SET a.publication_id = ( SELECT s.current_publication_id FROM submissions as s LEFT JOIN …)% line 437, file: /app/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(Array[30])% line 395, file: /app/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 263, file: /app/lib/pkp/classes/install/Installer.inc.php
ERROR: Upgrade failed: DB: Column ‘publication_id’ cannot be null
PKP-Database-Logger 1583784827.8818: -----
(mysqli): UPDATE sessions
SET
user_id = NULL,
ip_address = ‘’,
user_agent = ‘’,
created = 1583784830,
last_used = 1583784830,
remember = 0,
data = ‘’,
domain = ‘’
WHERE session_id = ‘2rvj6ene916i7vgaq0ei27udrj’


Anyone experiencing this as well?

Thanks.
Saron

Hi @sarontt,

Have a look at [OMP] Error upgrading from version 3.1.2-4 to 3.2.0 · Issue #5583 · pkp/pkp-lib · GitHub.

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks!

Sorry-- it seems that I didn’t search appropriately for my question on github issues (while I did search this forum for it). I had tried that solution (prior to this thread) and got a different error after so I thought maybe that was not a good solution.

I now am getting citations_publication_seq duplicate entry which I see has a github issue: OJS 3.2 citations error on upgrade · Issue #5465 · pkp/pkp-lib · GitHub. So I will read through that and see if I have any more questions.

Thanks again as always.

2 Likes

Hi @sarontt,

Not a problem, it can be a bit of a maze –

See also this recent thread: OJS3.2 Upgrade Error - Please help - #8 by asmecher

I wasn’t able to track down a cause there, but if you are, please let me know! It might lead to an upgrade bug fix.

Thanks,
Alec Smecher
Public Knowledge Project Team