Find out version?

Added by Devon Fritz about 8 years ago

Hello,

I was running Redmine until my server died. Luckily I have a database backup and also the files directory. However, I don't know where I can find which version of redmine I ran, as I don't have the server files. Can I find this somewhere in the database?

Thanks.
Devon

Replies (1)

RE: Find out version? - Added by Martin Denizet (redmine.org team member) about 8 years ago

Hi Devon,
In case you didn't find a solution yet, I've one for you:
On your MySQL, run:

SELECT CONVERT(version,UNSIGNED INTEGER) as last_migration FROM redmine.schema_migrations WHERE version NOT LIKE '%-%' ORDER BY last_migration DESC;

The number you get is the code of the last migration file applied to your database (in my case '20140228130325').
Now that you have that number, look it up on this page: http://www.redmine.org/projects/redmine/repository/show/trunk/db/migrate
In my case the file is source:trunk/db/migrate/20140228130325_change_changesets_comments_limit.rb and it was committed at r12944.
Now got to http://www.redmine.org/projects/redmine/repository/show/tags and look for the first version that has a number superior to the migration file commit revision.
In my case it's version 2.5.0 at r12954.

Will be correct if you were using a stable release.

Cheers

(1-1/1)