"Database could not be installed" when adding Countour to site in Azure
Hi,
I'm new to Umbraco (and Azure for that matter). I was able to install umbraco on Azure using the Azure Accelerator, however when I attempted to install Countour I receive the following...
Database could not be installed + umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Keyword or statement option 'pad_index' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) 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)
Added the forms datatype
Updated /umbraco/config/create/ui.xml
Added dashboard to Contour application
Updated web.config to use correct asp.net ajax assemblies
Formpicker could not be added + System.ArgumentException: No macro property type found with the id specified at umbraco.cms.businesslogic.macro.MacroPropertyType.setup() at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
Updated english language file with Contour keys
Just wondering if this is an Azure issue or perhaps something else. Has anyone encountered anything similar? The Umbraco version installed is 4.7.0.378.
"Database could not be installed" when adding Countour to site in Azure
Hi,
I'm new to Umbraco (and Azure for that matter). I was able to install umbraco on Azure using the Azure Accelerator, however when I attempted to install Countour I receive the following...
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Keyword or statement option 'pad_index' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) 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)
System.ArgumentException: No macro property type found with the id specified at umbraco.cms.businesslogic.macro.MacroPropertyType.setup() at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
Just wondering if this is an Azure issue or perhaps something else. Has anyone encountered anything similar? The Umbraco version installed is 4.7.0.378.
Thanks in advance,
Chris
Comment author was deleted
Hi Chris,
Looks like the database install script failed
You could try to manually execute the script, script can be found here:
http://our.umbraco.org/projects/umbraco-pro/contour
Bottom of page on the documentation tab
Cheers,
Tim
is working on a reply...