Unable to login after restoring the data

Added by Anjith Kumar 2 months ago

Hi Team,

Please be informed that in installed redmine in centos 7 with Postgre SQL. Then i restored the database using the existing data in postgre SQL. Now i'm unable to login into redmine and its giving Internal error 500.
Below is the production log

"Successful authentication for '----' from ----- at 2020-06-04 03:43:15 UTC
Completed 500 Internal Server Error in 33ms (ActiveRecord: 19.6ms)

ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column "updated_on" does not exist
LINE 1: ...user_id" = $1 AND "tokens"."action" = $2 ORDER BY "updated_o...
HINT: Perhaps you meant to reference the column "tokens.created_on".
: SELECT "tokens"."id" FROM "tokens" WHERE "tokens"."user_id" = $1 AND "tokens"."action" = $2 ORDER BY "updated_on" DESC OFFSET $3):

app/models/token.rb:136:in `delete_previous_tokens'
app/models/user.rb:435:in `generate_session_token"

Can someone help to bypass the rror

Replies (1)

RE: Unable to login after restoring the data - Added by Go MAEDA 2 months ago

Maybe you are using a recent version of Redmine against the database for Redmine prior to 3.1. The updated_on column of tokens table was added in Redmine 3.1.

I think you need to do step 4 in RedmineUpgrade to resolve the error.