YAFLogo

creativeavatar
10 years ago
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

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
10 years ago

Is it possible to install yaz on a DotNetNuke site which is hosted on azure? Any help would be greatly appreciated!

Originally Posted by: creativeavatar 

No at the moment it is not possible. Only with a rewrite of the install Transcripts. Hopefully i can do that for version 2.2.0 or 2.3.0

creativeavatar
10 years ago

Is it possible to install yaz on a DotNetNuke site which is hosted on azure? Any help would be greatly appreciated!

Originally Posted by: tha_watcha 

No at the moment it is not possible. Only with a rewrite of the install Transcripts. Hopefully i can do that for version 2.2.0 or 2.3.0

Originally Posted by: creativeavatar 

Oh okay.... I appreciate your fast response. That's a shame that it doesn't support it now. You might want to put a notice on the site regarding that as it would have saved me hours of time wasted.

Look forward to seeing what's to come with yaf.