CODEWITHSUNDEEP
upgradekentico
masterlopau
masterlopau

Reputation: 563

Security Exception when loading the site after Kentico upgrade from v9 to v10

After upgrading the existing v9 site to Kentico 10 I'm getting a security exception error when loading the site. The CMS admin however loads fine. I already added the FULL trust setting in web.config but it did not work. Any idea?

enter image description here

Upvotes: 0

Views: 122

Answers (2)

Michal Samuhel
Michal Samuhel

Reputation: 511

Problem, based on part that I can see and exception type would be in new SQL parser which was added in one of the hotfixes for v9 and thus it is part of v10.

You seem to be using one of the properties in a web part and than passing incomplete query via ##WHERE## macro. If a where condition is like {%CurrentDocument.DocumentID%} it is not a valid WHERE and whole property has to be complete SQL statement on its own, so it could be like DocumentID = {%CurrentDocument.DocumentID%}.

You can find a bit more in this thread:

https://devnet.kentico.com/questions/invalid-sql-query-error-on-a-page

Upvotes: 2

Rui
Rui

Reputation: 494

Try load the template in the Admin UI pages application, then check the event log application, you should see the detail information about the SQL error. Most likely you have a SQL call that is trying to get some data from a column that's no longer there (through upgrade).

Upvotes: 1

Related Questions