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