Hi. I'm currently running V5.0.5 and when I attempt to upgrade to V5.1.0 I get the following error message when the site starts up:
Controller: Error, Action: Error, Status: 500 (InternalServerError)
Incorrect syntax near '$'.
If I remove the App_Data Settings.txt file, it creates a new DB and the site looks fine, but I want to use my existing DB. I had a look for any obvious differences between the newly created DB and my existing one (which worked absolutely fine with V5.0.5), and I noticed that the collation is different: the old DB has a collation of Latin1_General_CI_AS but the new one is SQL_Latin1_General_CP1_CI_AS. Also the "Compatibility level" is different, although I'm not sure how this could relate to the above error.
Is this a known breaking change? If the collation difference isn't to blame, what else could I try? There is nothing logged to the event viewer about this.