2 Antworten zu diesem Thema

[nickh]

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.

[Artar]

Please check and update the compatibility level of the database.
A current date is ideal

[nickh]

Thanks Artar, that has fixed it.