After numerous tries, I finally was able to get the website running on 2019 Server. However, after turning the server off and on this morning, I get the below SQL error. My login page comes up, but when trying to log in I get this error. I tried to going to /CMSSiteManager/Default.aspx webpage and then trying to log in, but same result.
Has anyone encountered this issue and if so, have a solution?
Using VS2008 and ASPX templates.
[Exception: [DataConnection.ExecuteQuery]: Query: DELETE FROM [CMS_EventLog]
WHERE ([EventID] NOT IN (SELECT [EventID] FROM [CMS_EventLog] WITH (NOLOCK)
WHERE SiteID = 1 00)) AND (SiteID = 1): caused exception: Incorrect syntax near '00'.]
On a hunch, I deleted all of the eventlog entries in the EventLog table. I'm able to access the website. I'm not sure why this fixed it and hope that permanently fixed my issue.
Please, sign in to be able to submit a new answer.