Site setup problem

Naresh Ede asked on October 18, 2017 11:41

Hi

I'm facing problems while setting up my website.

here is the error message i got The database version '8.2' does not match the project version '9.0', please check your connection string.

I had checked in database, it is showing the database version 8.2.

So guys tell me where i did wrong and suggest what i have to do now.

Recent Answers


Master User answered on October 18, 2017 13:17 (last edited on October 18, 2017 13:17)

0 votesVote for this answer Mark as a Correct answer

Matt Nield answered on October 18, 2017 13:18

Run the following query to double-check your database:

SELECT KeyName, KeyValue
FROM CMS_SettingsKey
WHERE KeyName IN ('CMSDataVersion','CMSDBVersion','CMSHotfixVersion')

Then, have a look at the assemblies that you have installed (in the Lib folder) to check you've not got any mis-aligned assemblies and that they are also have 8.x version assemblies.

PS: Sorry, the above was me logged in as a company account :)

1 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on October 18, 2017 16:20

Glad i'm not the only one that's done that Matt :P

Naresha, were you trying to upgrade a site? It's odd that you would have the files of 9.0 but the database of 8.2, you cannot just point a new Kentico 9 site to an old database. If you did try to upgrade, how did you do it? Through the tool or manually?

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 19, 2017 14:39 (last edited on October 19, 2017 14:39)

You have a mismatch of versions with code files and database data.

This StackOverflow answer has all the possible ways to check what version you're on in code and in the database.

There are typically a few places you can find this:

Database File system Kentico UI If you get your info from the database, it will only be relevant to the data. If you get your info from the file system, it will tell you the version of the files. If you look in the Kentico UI, it will show you what is in the database.

To get the info out of the database run this query:

SELECT *
FROM CMS_SettingsKey
WHERE KeyName = 'CMSDataVersion' OR
KeyName = 'CMSDBVersion' OR
KeyName = 'CMSHotfixVersion'
The KeyValue fields will have the info you are looking for.

To get the info from the file system, go to the Bin directory and right click on any of the CMS dll's and go to properties>details. The Product Version will provide you with the version information.

In the file system you can also find the hotfix in a txt file under /App_Data/Install/Hotfix.txt

To get the info from the UI, log into Kentico and click the question mark at the top right of the screen, it will show the current version.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.