|
|
Joined: 5/19/2009
Posts: 18
|
|
|
Yesterday I installed a site on microsoft Azure using the Dotnetnuke Accelerator 6.2.
the database is on Sql Azure. I think the problem is Sql Azure may not have the same commands as Sql Server.
When installing links 6.2.1 I get the following
| StartJob |
Starting Installation |
| Info |
Starting Installation - DNN_Links |
| Info |
Starting Installation - Cleanup |
| Info |
Processing Cleanup File - 6.0.0 |
| Info |
Completed Processing of Cleanup File - 6.0.0 |
| Info |
Component installed successfully - Cleanup |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Folder Created - X:\DotNetNuke\DesktopModules\Links\Providers\DataProviders\SqlDataProvider |
| Info |
Created - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider |
| Info |
Executing 03.01.00.SqlDataProvider |
| Info |
Start Sql execution: 03.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 'NOT FOR REPLICATION' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)/************************************************************//***** SqlDataProvider *****//***** *****//***** *****//***** Note: To manually execute this script you must *****//***** perform a search and replace operation *****//***** for dbo. and *****//***** *****//************************************************************//** Create Links Table **/IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[Links]') AND OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[Links] ( [ItemID] [int] NOT NULL IDENTITY(0, 1), [ModuleID] [int] NOT NULL, [CreatedByUser] [nvarchar] (100) NULL, [CreatedDate] [datetime] NULL, [Title] [nvarchar] (100) NULL, [Url] [nvarchar] (250) NULL, [ViewOrder] [int] NULL, [Description] [nvarchar] (2000) NULL ) ALTER TABLE dbo.[Links] ADD PRIMARY KEY NONCLUSTERED ([ItemID]) CREATE NONCLUSTERED INDEX [IX_Links] ON dbo.[Links] ([ModuleID]) ALTER TABLE dbo.[Links] WITH NOCHECK ADD FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION ENDSystem.Data.SqlClient.SqlException (0x80131904): Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)CREATE PROCEDURE dbo.GetLink@ItemId int,@ModuleId intASSELECT L.ItemId, L.ModuleId, L.Title, 'URL' = CASE WHEN F.FileName IS NULL THEN L.URL ELSE F.Folder + F.FileName END, L.ViewOrder, L.Description, 'CreatedByUser' = U.FirstName + ' ' + U.LastName, L.CreatedDate, UT.TrackClicks, UT.NewWindowFROM dbo.Links L LEFT OUTER JOIN dbo.Users U ON L.CreatedByUser = U.UserId LEFT OUTER JOIN dbo.UrlTracking UT ON L.URL = UT.Url AND L.ModuleId = UT.ModuleID LEFT OUTER JOIN dbo.Files F ON L.URL = 'fileid=' + CONVERT(varchar,F.FileID)WHERE L.ItemId = @ItemId AND L.ModuleId = @ModuleIdSystem.Data.SqlClient.SqlException (0x80131904): Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)CREATE PROCEDURE dbo.GetLinks @ModuleId intASSELECT L.ItemId, L.ModuleId, L.CreatedByUser, L.CreatedDate, L.Title, 'URL' = CASE WHEN F.FileName IS NULL THEN L.URL ELSE F.Folder + F.FileName end, L.ViewOrder, L.Description, UT.TrackClicks, UT.NewWindowFROM dbo.Links L LEFT OUTER JOIN dbo.UrlTracking UT ON L.URL = UT.Url AND UT.ModuleId = @ModuleID LEFT OUTER JOIN dbo.Files F ON L.URL = 'fileid=' + CONVERT(VARCHAR,F.FileID)WHERE L.ModuleId = @ModuleIdORDER BY L.ViewOrder, L.Title |
| Info |
End Sql execution: 03.01.00.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Rolling back component install - Cleanup |
| Info |
Component rolled back successfully - Cleanup |
| Info |
Installation Failed - DNN_Links |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
| |
|
| |
|
|