A database error has occurred: Table 'users_tmp' already exists

Software Support
1

** [

Upgrading OJS 3.1. to 3.2. **

Dears,
Good day,

Please i try to upgrade the ojs from 3.1 to 3.2.0
I have:

  • PHP >= 7.2.0; you are currently using PHP 7.3.33
  • MySQL >= 4.1 or PostgreSQL >= 9.1.5
  • Apache >= 1.3.2x or >= 2.0.4x or Microsoft IIS 6

When i go to Upgrade Open Journal System bottom
I got this message:

(((A database error has occurred: Table ‘users_tmp’ already exists)))

Please can you help me to resolve it?

2

please can anyone help me to solve this issue?

3

Hi @AmmarAbbas,

As a starting point, you may wish to look at other posts where users have reported this error message: https://forum.pkp.sfu.ca/search?q="‘users_tmp’%20%20already%20exists

Additionally, if you haven’t seen it already, we do have our upgrade guide here: https://docs.pkp.sfu.ca/dev/upgrade-guide/

-Roger
PKP Team