Installation and deployment
Version 3.x > Installation and deployment > error after log in View modes: 
User avatar
Member
Member
cheryl-abosoftware.co - 1/14/2009 6:24:04 AM
   
error after log in
when i try to run a new site i created using the site wizard i get the following error after i log in


Server Error in '/KenticoCMS' Application.
--------------------------------------------------------------------------------

[DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ( [EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName); SELECT @@identity AS [EventID]: caused exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__CMS_Event__SiteI__440B1D61". The conflict occurred in database "KenticotestCMS", table "dbo.CMS_Site", column 'SiteID'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ( [EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName); SELECT @@identity AS [EventID]: caused exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__CMS_Event__SiteI__440B1D61". The conflict occurred in database "KenticotestCMS", table "dbo.CMS_Site", column 'SiteID'.
The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ( [EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName); SELECT @@identity AS [EventID]: caused exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__CMS_Event__SiteI__440B1D61". The conflict occurred in database "KenticotestCMS", table "dbo.CMS_Site", column 'SiteID'.
The statement has been terminated.]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +810
CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +12
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryText, Object[,] parameters, QueryTypeEnum queryType, Boolean transaction) +160
CMS.DataEngine.GeneralConnection.RunQueryObject(Query query, Object[,] parameters) +332
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN) +82
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters) +14
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) +8
CMS.DataEngine.SimpleDataClass.Insert() +118
CMS.EventLog.EventLogProvider.LogEvent(String eventType, DateTime eventTime, String source, String eventCode, Int32 userId, String userName, Int32 nodeId, String documentName, String ipAddress, String eventDescription, Int32 siteId, String eventUrl) +791
CMS.SiteProvider.UserInfoProvider.AuthenticateUser(String userName, String password, String siteName) +729
CMS.MembershipProvider.CMSMembershipProvider.ValidateUser(String username, String password) +37
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 1/16/2009 8:06:57 AM
   
RE:error after log in
Hello,

this is very strange.
Could you please describe some more circumstances around this error?
Mostly if you have used fresh database, or connected to the existing.
Was there any import procedure done?

There is a conflict -- i.e. some inconsistence in the DB. Eventually we will need your database backup to find the cause of the error. But as I say, it's quite odd.

Thank you for information.

Regards,
Zdenek Cetkovsky, Kentico

User avatar
Member
Member
andreas-microlexus - 3/5/2010 11:40:29 AM
   
RE:error after log in
when I tried to install the Kentico 5, in the Database Setup - Step 5 I got error message :

ERROR: Error importing 'System tables' objects (User)
Message: [DataConnection.ExecuteQuery]: Query: DROP VIEW 1031_web2usolutions.View_CMS_User: caused exception: Incorrect syntax near.....

I restart again and try several time, but still got the same error message.

Is it a bug in Kentico 5 for the free license installation. Please advise and how to fix the issue. Thanks.

User avatar
Member
Member
andreas-microlexus - 3/9/2010 6:21:31 PM
   
RE:error after log in
heyy.. does anyone look into this

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 3/11/2010 4:09:23 AM
   
RE:error after log in
Hello,

Could you please let me know what version of SQL server you use? If you use SQL server 2000, could you please use some later version of SQL server instead?

If you use some later version already, could you please provide me with full error message and optionally also with screenshot so I can see where exactly it occurs?

Best Regards,

Martin Dobsicek