Hi Everyone,
First time posting here. I am having a problem installing yaf on a DotNetNuke site which is hosted on Windows Azure.
After placing the yaz module on a page, and going through the yaz setup wizard, I get an error and the installation is not completed... Is it possible to install yaz on a DotNetNuke site which is hosted on azure? Any help would be greatly appreciated!
FILE:
mssql/tables.sql
ERROR:
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
The statement has been terminated.
STATEMENT:
if exists (select top 1 1 from sys.columns where object_id = object_id(N'[dbo].[dnnVR_yaf_Active]') and name='IP' and precision < 39)
alter table [dbo].[dnnVR_yaf_Active] alter column [IP] varchar(39) not null
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: FILE:
mssql/tables.sql
ERROR:
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
The statement has been terminated.
STATEMENT:
if exists (select top 1 1 from sys.columns where object_id = object_id(N'[dbo].[dnnVR_yaf_Active]') and name='IP' and precision < 39)
alter table [dbo].[dnnVR_yaf_Active] alter column [IP] varchar(39) not null
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: FILE:
mssql/tables.sql
ERROR:
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
The statement has been terminated.
STATEMENT:
if exists (select top 1 1 from sys.columns where object_id = object_id(N'[dbo].[dnnVR_yaf_Active]') and name='IP' and precision < 39)
alter table [dbo].[dnnVR_yaf_Active] alter column [IP] varchar(39) not null]
YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +1540
YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +188
YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +205
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1559
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +584
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.19453