ERROR: Upgrade failed: DB: Unknown column 'email_id' in 'field list'

Software Support
,
1

Hi,

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 :

ERROR: Upgrade failed: DB: Unknown column ‘email_id’ in ‘field list’

Do you have any idea of what the problem is ?

Thank’s for you help

2

Hi @Rob_Colbourn,

Is this the first time you’ve tried the upgrade, or are you trying it again after another failure already happened? Make sure to restore your database from backup before trying an upgrade again.

Turn on the show_stacktrace option in config.inc.php to get a more in-depth error report.

Regards,
Alec Smecher
Public Knowledge Project Team

3

No that’s not the first time. I firstly had this error message:

Duplicate entry ‘SUBMISSION_ACK-0’ for key ‘email_templates_email_key’

So I deleted every duplicate entry in the “email_templates” table, re-run the script and got this error :

PKP-Database-Logger 1585221046.4798: Query:
INSERT INTO email_templates_settings (email_id, locale, setting_value, setting_name)
SELECT email_id, locale, subject, ‘subject’
FROM email_templates_data
failed. Unknown column ‘email_id’ in ‘field list’
PKP-Database-Logger 1585221046.4798: 1054: Unknown column ‘email_id’ in 'field list

Regards

4

Hi @Rob_Colbourn,

Are you using OJS 3.2.0, or 3.2.0-1? We released the 3.2.0-1 package last week with some related changes.

Just to confirm, are you restoring your database to its 3.1.2 state before trying the upgrade every time? This will be necessary to avoid garbling your database.

Regards,
Alec Smecher
Public Knowledge Project Team