Found error while upgrade to 3.3.0.7

I found a problem while I upgrade OJS. The error code shown below.

  • A database error has occurred: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘email_id’ (SQL: ALTER TABLE email_templates_data ADD email_id BIGINT)

Capture008

Hi @Natthakorn_Ruengdit,

Is this the first attempt to upgrade, or was there an interrupted attempt, and you tried again without restoring the database backup?

Also, are you upgrading from which OJS version?

I am also having that problem, for me there was an interrupted attempt and I don’t have the backup database so how can I fix this

Hi @Pee-Kay,

I see you’ve opened a new topic about this – it’s best just to post in one place. I’ll close this topic and continue the discussion over there.

Thanks,
Alec Smecher
Public Knowledge Project Team