ERROR: Upgrade failed: DB: Unknown column ‘ts.citations’ in ‘field list’


I’m trying to upgrade my OJS installation from 3.1.2 to 3.2 and I’m encountering a problem with the DB upgrade :

INSERT INTO publication_settings(publication_id, setting_name, setting_value)
SELECT s.current_publication_id, ‘citationsRaw’, ts.citations
FROM submissions as s
LEFT JOIN temp_submissions as ts
ON s.submission_id = ts.submission_id
WHERE ts.citations IS NOT NULL
failed. Unknown column ‘ts.citations’ in ‘field list’

Do you have any idea of what the problem is ?

Thank’s for you help

Hi @Rob_Colbourn,

Did you try to run an upgrade twice? It looks to me like this database has already had an upgrade attempted against it. If you try an upgrade and it fails, you’ll need to restore your database from backup before trying again.

Alec Smecher
Public Knowledge Project Team