Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: richwig83 on September 21, 2014, 03:21:42 AM

Title: Finding SMF version from DB?
Post by: richwig83 on September 21, 2014, 03:21:42 AM
Is it possible to look at a DBP and work out which version of SMF it uses?

Thanks.
Rich
Title: Re: Finding SMF version from DB?
Post by: margarett on September 21, 2014, 05:20:06 AM
Yes but not exactly.

You can safely identify version 1.1.x or 2.0.x by looking at the first record of smf_settings.
But in that you might not have the exact version... If SMF was installed with, say, 2.0.1 and was updated through time to 2.0.8 via patch updates, then the database version would still be 2.0.1 because there are no database changes meanwhile.

I hope it makes sense ;)
Title: Re: Finding SMF version from DB?
Post by: richwig83 on September 21, 2014, 05:41:25 AM
OK... thanks.

Let me give you some more info as it might enable you to answer 100%.

We have 1 DB. Our current forum uses the "smf_" prefix in that DB. (recently upgraded from 1.1.19 to 2.0.8

There is also a 'lost' forum that has not been accessed for a few years with the prefix "mk6_" in the same database as "smf_"

The "mk6_" tables are still in the DB.

Will the "mk6_" tables still be v1.1.X or will they have also been upgraded along with the "smf_" prefix?
Title: Re: Finding SMF version from DB?
Post by: Illori on September 21, 2014, 06:20:19 AM
they would not have been upgraded unless you have your Settings.php file set to look at those tables when you did the upgrade.
Title: Re: Finding SMF version from DB?
Post by: richwig83 on September 22, 2014, 03:21:30 AM
Cool so it still will be 1.x.x