Problem installing CWS 2.0.2 on clean Umbraco 4.0.3

May 18, 2010 at 1:25 PM
Edited May 18, 2010 at 1:29 PM
Installing Umbraco and CWS on server hosted with my ISP I get this error:

--------------------------------------------------------------------------------------------------------------

Server Error in '/' Application.
Must declare the scalar variable "@uniqueID".
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.Data.SqlClient.SqlException: Must declare the scalar variable "@uniqueID".

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:
[SqlException (0x80131904): Must declare the scalar variable "@uniqueID".]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:51
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:194


[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:198
umbraco.cms.businesslogic.CMSNode.IsNode(Guid uniqueID) +135
umbraco.cms.businesslogic.datatype.DataTypeDefinition.Import(XmlNode xmlData) +185
umbraco.cms.businesslogic.packager.Installer.InstallBusinessLogic(Int32 packageId, String tempDir) +163
umbraco.presentation.developer.packages.Installer.processInstall(String currentStep) +180
umbraco.presentation.developer.packages.Installer.Page_Load(Object sender, EventArgs e) +334
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
umbraco.BasePages.BasePage.OnLoad(EventArgs e) +15
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
--------------------------------------------------------------------------------------------------------------
It's a clean Umbraco installation. This error comes after uninstalling the package, and reinstalling it.
I forgot to change the web.config on the first install, so I could only see the "friendly" error message. But the initial installation did fail too (hence the re-installation).

Any clue as to why this happens?

Coordinator
May 18, 2010 at 1:27 PM
Hello ellersgaard, Unfortunately my package is quite complex and does not get unistalled properly. So to reinstall CWS, you need to reinstall Umbraco a fresh again (including a clean database). Sorry for this. Warren :)
May 18, 2010 at 1:35 PM
Edited May 18, 2010 at 2:06 PM

Hi Warren, I actually did this - twice :) Nuked the DB, cleared out all the Umbraco files and replaced them with a fresh installation. Ran the installer-script and installed your package before doing anything else. Same result. Do you think it's an IIS or SQL-setup issue?

Coordinator
May 18, 2010 at 3:35 PM
Hmmm I think this is more of an umbraco issue it seems: http://umbraco.codeplex.com/WorkItem/View.aspx?WorkItemId=19320 http://forum.umbraco.org/yaf_postst6827_Error-Must-declare-the-scalar-variable-uniqueID.aspx I recommend you use the forum on http://our.umbraco.org to see if someone can help you as I am not a SQL or IIS expert. Warren :)