Fatal error after upgrading ops3.2.0beta to OPS3.2.0-1 Beta

Software Support Open Preprint System
1

First of all, I would like to thank pkp team for releasing the improved version of OPS. I hope the upgrading from the previous beta version to the current beta-version is supported. If so, I upgraded with a successful screen message from 3.2.0 to 3.2.0-1 today, but when browsing it gives HTTP ERROR 500 with following php error log.

Error Log

[15-Apr-2020 03:19:40 UTC] PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘s.locale’ in ‘field list’ Query: SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC in C:\wamp64\www\ops\lib in C:\wamp64\www\ops\lib\pkp\classes\db\DAO.inc.php on line 703
[15-Apr-2020 03:19:41 UTC] PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘s.locale’ in ‘field list’ Query: SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC in C:\wamp64\www\ops\lib in C:\wamp64\www\ops\lib\pkp\classes\db\DAO.inc.php on line 703

If upgrade in beta version is not supported, can you plz suggest a way to migrate preprints article with its metadat to the new beta version (may be if import/export tool can be installed in the 3.2.0 beta version).

Thank you so much!

2

Hi @aabahishti,

You can correct this by running the following SQL statement:

ALTER TABLE submissions ADD COLUMN locale VARCHAR(14);

I’ve filed this for a fix in the next release here: [OPS] Upgrade to OPS 3.2.0-1 does not sync database schema descriptors · Issue #5742 · pkp/pkp-lib · GitHub

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like
3

Hi @asmecher
Thank you, after running above query, I can browse the ops webpage. I Will let you know if face any other difficulty.

Thank you so much.

1 Like