Hi Froad,

Currently you can only install Contour on SQL Server.

OK, must have missed that information somewhere..

While I have you listening, Tim, could you please enlighten me about this problem: http://our.umbraco.org/forum/getting-started/questions-about-runway-and-modules/4582-Use-tags-in-Blog¤Umbraco

Im going nuts!

I'm actually having that same error on SQL Server 2008... is 2005 the version of choice?

• Database could not be installed +
  umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.cmsMacroPropertyType'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Usercontrols\Installer.ascx.cs:line 23
• Formpicker could not be added +
  umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoMacroProperty_umbracoMacroPropertyType". The conflict occurred in database "dbo", table "digithrive_umbarco.cmsMacroPropertyType", column 'id'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.macro.MacroProperty.MakeNew(Macro M, Boolean show, String alias, String name, MacroPropertyType propertyType) at umbraco.cms.businesslogic.macro.MacroProperty.Save() at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Usercontrols\Installer.ascx.cs:line 86

Seems as if the db schema is different? dbo versus digithrive.umbarco! Could that be your issue?

Hope this helps.

Regards,

/Dirk

It actually doesn't. My web config file only specifies "digithrive_umbarco" (a typo i've learned to live with); and this is on a 100% brand new installation from a completely empty database. The Umbraco install was freshly downloaded as well. So I basically fired up brand new "everything" and immediately received the above errors when I try to install Contour (with or without Runway). 

As a precautionary measure, I've been wiping everything out, and starting from scratch to ensure I'm dealing with absolutely zero influence from variables.

Right now; I'm removing every file from my server, and I'm dropping the database one more time. Wish me luck.

Hi Nrek,

I have it installed on both Win 7 & Win 2008 server using SQL 2008.

Cheers,

Chris

Alright, here's what I've done:

1. Uploaded freshly downloaded copy of Umbraco (to SoftSys, shared hosting, with SQL Server 2008)
2. Added schema for a newly created SQL 2008 database user "dthrive_adm" > "db_owner" via SQL Server Mgmt
3. Altered the default web.config file from download on umbraco.org to ::
4. Updated only this line: "umbracoDbDSN"  <add key="umbracoDbDSN" value="Server=72.***;Database=dthriveUmbraco;User ID=dthrive_adm;Password=****;Trusted_Connection=False"/>
5. Checked permission on required folders & files ... Installation - Ok
6. (In Umbraco) clicked Developer > Packages > "Umbraco Package Repository" > Umbraco Contour
7. Followed the simple steps, and receive:

• Database could not be installed +
  umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.cmsMacroPropertyType'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Usercontrols\Installer.ascx.cs:line 23
• Added the forms datatype
• Updated /umbraco/config/ui/create.xml
• Added dashboard to Contour application
• Updated web.config to use correct asp.net ajax assemblies
• Formpicker could not be added +
  umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoMacroProperty_umbracoMacroPropertyType". The conflict occurred in database "dthriveUmbraco", table "dthrive_adm.cmsMacroPropertyType", column 'id'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.macro.MacroProperty.MakeNew(Macro M, Boolean show, String alias, String name, MacroPropertyType propertyType) at umbraco.cms.businesslogic.macro.MacroProperty.Save() at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\39da791f9304089a\Umbraco.Forms.UI\Usercontrols\Installer.ascx.cs:line 86

Oh - if for some terrible reason anyone else on Earth ever has this problem, and needs to perform uninstalls & reinstalls or regenerate the error for support after they try to install it & uninstall it -

They may get a Primary Key error regarding a table.UmbracoUser2App record. Took a second to figure it out, but (modify and run) this:

DELETE FROM [database].[prefix].[umbracoUser2app]
      WHERE app='contour'

Not sure why it stays around, but it does & it produces a different error; which doens't help troubleshooting in the slightest, from what I can gather.

My problems are solved: 

I've posted about it here

http://our.umbraco.org/forum/getting-started/installing-umbraco/5412-Umbraco-and-Contour-on-Shared-Hosting

is working on a reply...