I did not successfully Upgrade our OJS 3.1.2-1 to the latest version it because of this error that I got “A database error has occurred: Table ‘dbname.email_template_data’ does not exist”.
on the README instruction once you don’t have changes in templates(design) or any changes you can copy and paste the patch but u need to remain the "config.php, public folder, and files folder as per instruction.
From patch OJS 3.2.1-1 I copied and pasted(except the config, public folder) it to the directory of my publication. Deleted the file of OJS 3.1.2-1 and remain the (config, public, files, and folders). Then after that Execute the Upgrade into Shell Command the upgraded can not push through due to the error "A database error has occurred: Table ‘dbname.email_template_data’ does not exist”
Then, I revert this Using this --> I follow this https://github.com/pkp/pkp-lib/issues/5296 topic and then, tried to revert to 3.1.2 but got this error ‘citations_sequence_id’ and then check the database, the table.email_templates_data is there. So, I decided to Export the table email_templates_date table and Alter It.
and proceed to upgrade to again to the OJS 3.2.1-1.
To Understand: Here is the Flow.
- From OJS 3.1.2-1 to 3.2.1-1 Upgrade but got this error table email_templates_data does not exist.
- Revert from 3.2.1-1 Files to OJS 3.1.2 execute the shell command but got this error ‘citations_sequence_id’.
- Check the database the email_templates_data are in here. decided to export and import to new execution which is to OJS 3.2.1-1.
- in the Final Testing of execution the error is this DB: Duplicate column name ‘email_id’.
and now I am looking into the DB which table is this email_id Column name.
Thanks for your response we appreciate it.