DB Upgrade error 3.2.0 -> 3.2.0-1 Duplicate column name 'email_id'

During the DB upgrade step, I’m getting:

A database error has occurred: Duplicate column name ‘email_id’

Any ideas what might be going wrong?

Hello @theotherdy .
Can you start again?

new database backup

debug = On on config.inc.php

php tools/upgrade.php upgrade

Debug On, more information for you.

Thanks for getting back to me. I’ve reverted to an earlier snapshot so will have to start again. I can certainly switch debug on but am not entirely sure what you mean by “php tools/upgrade.php upgrade”?

Do you have access to shell?

@theotherdy look at [OJS to 3.2] Upgrade Error - Duplicate column name ‘email_id’ - #7 by asmecher

Reupload your database and resetup your config for new database , and before upgrade , you must do this …

run this SQL Query script in your New OJS db on your phpmyadmin

SET @@global.innodb_large_prefix = 1;


Try re upgrade your OJS … cheers !