Finding SMF version from DB?

[richwig83]

Is it possible to look at a DBP and work out which version of SMF it uses?

Thanks.
Rich

[margarett]

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

[richwig83]

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?

[Illori]

they would not have been upgraded unless you have your Settings.php file set to look at those tables when you did the upgrade.

[richwig83]

Cool so it still will be 1.x.x