Question

We had been paying a third party to manage our FB server. Unfortunately they had a failure and were unable to recover the server we were assigned. Apparently the DB is still valid, but when they installed a FB version it does not match. I would prefer NOT to re-start the installation with a mismatch of version.

Given just the database how do I determine what version of the FB server to install?

I assume there is some sql query we can run on the DB.

Thanks

Answer 1

The version of FogBugz running is not currently stored in the database, however, this can be extrapolated from your database's schema version.

The database schema version is stored in the Version table of your database:

SELECT * FROM VERSION

That query should give you a 3 digit number. If you can tell us what that number is, we can find out what version of FogBugz you were running.

Answer 2

As far as I know, the FB installer will upgrade/downgrade the DB you point it at, so use the most recent version you can (but of course, back up the DB first)