Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

DMX 4 Install Errors
Last Post 01/18/2008 2:54 PM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Paul kavanagh
New Member
New Member
Posts:5


--
01/17/2008 4:44 PM

I initially tried to upgrade DMX 3 to your current DMX 4 version. I was getting errors, and figured there were no documents that I could not replace (and I was having that mutiple folders problem) so no biggie. BTW< I am on DNN version 4.08.00.

I uninstalled DMX, read the document, removed the web.config entries, double checked that there were no DMX tables or stored procedures, then added the DMX4 module again. I have done this several times, and keep getting the following error:

tartJob Begin Sql execution
Info Executing Install.04.00.00.SqlDataProvider
StartJob Start Sql execution: Install.04.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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) if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.DMX_LongTexts') and OBJECTPROPERTY(id, N'IsTable') = 1) CREATE TABLE dbo.DMX_LongTexts ( [Locale] NVARCHAR (6) NOT NULL, [ObjectId] INT NOT NULL, [SubTypeKey] NVARCHAR (20) NOT NULL, [Text] NVARCHAR(MAX) NOT NULL, [TypeKey] NVARCHAR (3) NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: Cannot alter table 'dbo.DMX_LongTexts' because this table does not exist in database 'DNN4x1'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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) if not exists (select * from dbo.sysobjects where id = object_id(N'PK_DMX_LongTexts') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE dbo.DMX_LongTexts ADD CONSTRAINT PK_DMX_LongTexts PRIMARY KEY CLUSTERED ( [Locale], [ObjectId], [SubTypeKey], [TypeKey] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.DMX_AddLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS INSERT INTO dbo.DMX_LongTexts ( [TypeKey], [SubTypeKey], [ObjectId], [Locale], Text ) VALUES ( @TypeKey, @SubTypeKey, @ObjectId, @Locale, @Text ) System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.DMX_UpdateLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS UPDATE dbo.DMX_LongTexts SET [Text] = @Text WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale 
EndJob End Sql execution: Install.04.00.00.SqlDataProvider file

There are no other errors, always shows up on this line.

Would really like to get this installed, or I have to roll back to version 3. Thanks Peter.

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
01/18/2008 2:54 PM
Hi Paul,

Errrr ... you're trying to install on SQL 2000. You need 2005 (or Express) for DMX 4.

Peter

PS Stay away from 04.08.00 until all teething issues have been solved. For production I always advise to stay away from .00 releases of DNN (or DMX for that part).
You are not authorized to post a reply.