Forums (Obsolete)

Old Forums

Installation and deployment Questions on installation, system configuration and deployment to the live server.

Version 5.x > Installation and deployment > Error when installing

View modes:

Member

jfdesign-gmail - 2/20/2010 11:30:08 PM

Error when installing

Can anyone explain this error?

ERROR: An error occured: [DataConnection.ExecuteQuery]: Query: CREATE VIEW [View_Node_Document] AS SELECT CMS_Tree.NodeID, CMS_Document.DocumentID, CMS_Tree.NodeSiteID, CMS_Tree.NodeClassID FROM CMS_Tree INNER JOIN CMS_Document ON CMS_Document.DocumentNodeID = CMS_Tree.NodeID WHERE (CMS_Tree.NodeLinkedNodeID IS NULL) UNION ALL SELECT CMS_Tree_Linked.NodeID, CMS_Document_Linked.DocumentID, CMS_Tree_Linked.NodeSiteID, CMS_Tree_Linked.NodeClassID FROM CMS_Tree AS CMS_Tree_Linked INNER JOIN CMS_Document AS CMS_Document_Linked ON CMS_Document_Linked.DocumentNodeID = CMS_Tree_Linked.NodeLinkedNodeID WHERE (CMS_Tree_Linked.NodeLinkedNodeID IS NOT NULL) : caused exception: There is already an object named 'View_Node_Document' in the database.

Member

deanknight-ymail - 2/21/2010 10:01:48 PM

RE:Error when installing

Looks like you started creating the database objects with the sql installation scripts and this process was interrupted. It seems as if you tried running the database installer again from scratch...The CREATE VIEW command is going to fail because the view was already created.

The easiest solution, is to delete the database and recreate it and then rerun the Kentico installer.

Member

jfdesign-gmail - 2/21/2010 11:50:19 PM

RE:Error when installing

Yeah I've been having a lot of trouble getting the Kentico installed. First I got an error that seemed to indicate the DB wasn't big enough. So I tried again on another DB I have which got me a little further into the installation, but then I ran into some error regarding my logs being to big. I ran a couple of SQL commands to try and drop tables and clear my log files. After all that I got this latest error. I'll ask to get my DB reinstalled since I don't believe I have access to do that myself. Thanks for the suggestion.

Top