Please Support Me,
I’m using OJS version 3.1.1.0
i failed to upgrade ojs 3.1.1.0 to version ojs 3.1.2.4
there is an error description:
- ERROR: Upgrade failed: DB: ERROR: type “serial” does not exist
- A database error has occurred: Table 'users_tmp’ already exists
Many Thanks,
An error indicating that the ‘users_tmp’ table already exists implies that you have previously tried to upgrade your installation, but it failed, and you are attempting to upgrade it again without having restored your database from a back up. You must completely restore your database from a dump created before you attempt the upgrade again.
Best
Jason
I second the answer made by Jason, and I encourage you to upgrade directly to OJS 3.2.1-4 (or better, last stable-3.2)
yes I did upgrade the OJS version using from database dump. when I restore to the new database there seems to be no problem. I’m using postgresql 10 and php7.3, any suggestions so that the backup and restore database in my single database can work fine?
Maybe there are other suggestions for me to upgrade OJS to the latest version
Thanks marc for the advice, I’ll consider it. OJS is a new job experience for me. so I seek help from experts in this forum 
Finally, I can upgrade versi OJS after trial and error
now I use the OJS version 3.2.1-4. and prepare upgrade to OJS latest version.
maybe any suggestions for me before upgrade to OJS latest version ?
Many Thanks,