Good morning,
We just aquired your product and we are kind of worried because just at the installation we are having an issue:
Our enviroment:
+ DNN 04.09.02
+ IIS 7
+ DNN running on Classic application pool
+ DMX 05.03.07
The problem:
When installing we are getting this message (BTW our DNN works with an spanish language package):
Ejecutando 05.03.06.SqlDataProvider
Comenzar ejecución SQL: archivo 05.03.06.SqlDataProvider
Como resultado de la ejecución SQL, surgieron las siguientes excepciones: System.Data.SqlClient.SqlException: Sintaxis incorrecta cerca de 'GO'. Sintaxis incorrecta cerca de 'GO'. 'CREATE/ALTER PROCEDURE' debe ser la primera instrucción en un lote de consultas. Sintaxis incorrecta cerca de 'GO'. en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) en System.Data.SqlClient.SqlCommand.ExecuteNonQuery() en DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) en DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (select * from dbo.sysobjects where id = object_id(N'DMX_SetDeleteRecursive') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.DMX_SetDeleteRecursive GO IF EXISTS (select * from dbo.sysobjects where id = object_id(N'DMX_SoftDeleteEntry') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.DMX_SoftDeleteEntry GO CREATE PROCEDURE dbo.DMX_SoftDeleteEntry @PortalId Int, @EntryId Int, @Delete Bit AS EXEC dbo.DMX_UpdatePaths @PortalId, @EntryId; DECLARE @LastVersionId INT SELECT @LastVersionId=(SELECT LastVersionId FROM dbo.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId) DECLARE @Path VARCHAR(4000) SELECT @Path = (SELECT [Path] FROM dbo.DMX_Entries WHERE EntryId=@LastVersionId AND PortalId=@PortalId) UPDATE dbo.DMX_Entries SET Deleted=@Delete WHERE LastVersionId=@LastVersionId AND PortalId=@PortalId; IF @Delete=1 UPDATE dbo.DMX_Entries SET Deleted=1 WHERE Path LIKE @Path + '%' AND PortalId=@PortalId; GO IF EXISTS (select * from dbo.sysobjects where id = object_id(N'DMX_GetEntryByTitleInCollection') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.DMX_GetEntryByTitleInCollection System.Data.SqlClient.SqlException: Ya hay un objeto con el nombre 'DMX_GetEntryByTitleInCollection' en la base de datos. en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) en System.Data.SqlClient.SqlCommand.ExecuteNonQuery() en DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) en DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.DMX_GetEntryByTitleInCollection @PortalId INT, @CollectionId INT, @Title NVARCHAR(255), @Locale NVarChar(10) AS SELECT e.*, ISNULL(stLoc.[Text], stDef.[Text]) Title, ISNULL(ltLoc.[Text], ltDef.[Text]) Remarks FROM dbo.DMX_Entries e INNER JOIN dbo.DMX_ShortTexts stDef ON e.EntryId=stDef.ObjectId AND stDef.TypeKey='ENT' AND stDef.SubTypeKey='TITLE' AND stDef.Locale='' LEFT JOIN dbo.DMX_ShortTexts stLoc ON e.EntryId=stLoc.ObjectId AND stLoc.TypeKey='ENT' AND stLoc.SubTypeKey='TITLE' AND stLoc.Locale=@Locale LEFT JOIN dbo.DMX_LongTexts ltDef ON e.EntryId=ltDef.ObjectId AND ltDef.TypeKey='ENT' AND ltDef.SubTypeKey='REMARKS' AND ltDef.Locale='' LEFT JOIN dbo.DMX_LongTexts ltLoc ON e.EntryId=ltLoc.ObjectId AND ltLoc.TypeKey='ENT' AND ltLoc.SubTypeKey='REMARKS' AND ltLoc.Locale=@Locale WHERE e.CollectionId=@CollectionId AND ((stDef.Text=@Title AND stLoc.Text IS NULL) OR (stLoc.Text=@Title AND (stLoc.Locale=@Locale OR @Locale=''))) AND PortalId=@PortalId AND e.LastVersionId=e.EntryId
Since we need to get running DMX we just take 05.03.06.SqlDataProvider file out of the installation package and execute it directly in our DNN Database. After removing the tags for the database owner and the prefix it runs flawless, so we end a little confused, but I have no time to investigate furter.
Anyway we found very unpleasant that a product that we just bought fail since installation.
P.S. BTW it would be nice if you could attach files in this forum for support. |