Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListError: Manage User Defined Table is currently unavailable. PLS HELP!Error: Manage User Defined Table is currently unavailable. PLS HELP!
Previous
 
Next
New Post
5/24/2007 6:45 AM
 
Dano

Joined: 10/23/2006
Posts: 73

 

Hi

I'm using DNN 4.5.1 and UDT 3.3.6

I've gone to use the UDT module for the first time and have the following error message when I try and 'manage uder defined table' 

Does anyone know if this is a bug, or how I can solve this problem?  Error shown below.

________

Error: Manage User Defined Table is currently unavailable.

DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.AddField(Int32 ModuleId, String FieldTitle, Boolean Required, String FieldType, String Default, Boolean Visible, String ExtendedSettings) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetFieldsTable(Int32 ModuleId, Boolean AddNewColumn, Boolean AddTrackColumns) at DotNetNuke.Modules.UserDefinedTable.ManageUserDefinedTable.BindData(Boolean blnInsertField) at DotNetNuke.Modules.UserDefinedTable.ManageUserDefinedTable.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
 
New Post
5/24/2007 7:14 AM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867

Please triple check that both connection strings inside web.config are identical!
 
New Post
5/24/2007 12:30 PM
 
Dano

Joined: 10/23/2006
Posts: 73

Hi

My provider Seekdotnet have done this, and say they are the same.  Any other solutions?
 
New Post
5/25/2007 4:16 AM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867

Did you provider setup DotnetNuke for you? If so, ask them for help, we are not aware of this issue.

Otherwise:
if you have control about your installation, you have host permissions and are using UDT for the first time, I would consider to remove UDT3.3.6 and install it again. Check for any errors during installation (there should not be any), we are quite sure that it will work.
 
New Post
5/25/2007 11:06 AM
 
Dano

Joined: 10/23/2006
Posts: 73

Hi, I did as you suggested and have copied the install file below, all the process completes it seems there are some strange messages coming up during the install, does this help?

* UPDATE - My provider has said -

-----
Dear Daniel,
>
>On the error message, the database connection is successfull. The
>problem only on the sql script of the module, please let the developer
>of the module know and consult with them about this. There is also a
>warning on the error message :'Incompatible DotNetNuke framework version
>installed. Please upgrade to V.
>3.3 or V. 4.1 or re-install previous version of this module!
>
>Best Regards

____

Dan

 Return

Resource Upload Logs
 
StartJob Starting Installation
StartJob Reading files
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.02.00.SqlDataProvider
Info File 03.02.00.SqlDataProvider read successfully
Info Loading 03.03.00.SqlDataProvider
Info File 03.03.00.SqlDataProvider read successfully
Info Loading 03.03.04.SqlDataProvider
Info File 03.03.04.SqlDataProvider read successfully
Info Loading 03.03.05.SqlDataProvider
Info File 03.03.05.SqlDataProvider read successfully
Info Loading 03.03.06.SqlDataProvider
Info File 03.03.06.SqlDataProvider read successfully
Info Loading DNN_UserDefinedTable.dnn
Info File DNN_UserDefinedTable.dnn read successfully
Info Loading DotNetNuke.Modules.UserDefinedTable.dll
Info File DotNetNuke.Modules.UserDefinedTable.dll read successfully
Info Loading DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.dll
Info File DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.dll read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
EndJob Reading files done.
 
StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'User Defined Table' module
EndJob Dnn load finished successfully
 
StartJob Begin Sql execution
Info Executing 03.01.00.SqlDataProvider
StartJob Start Sql execution: 03.01.00.SqlDataProvider file
EndJob End Sql execution: 03.01.00.SqlDataProvider file
 
Info Executing 03.02.00.SqlDataProvider
StartJob Start Sql execution: 03.02.00.SqlDataProvider file
EndJob End Sql execution: 03.02.00.SqlDataProvider file
 
Info Executing 03.03.00.SqlDataProvider
StartJob Start Sql execution: 03.03.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The default schema does not exist. 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 TABLE UDT_Install_Semaphore (value INT PRIMARY KEY) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) DECLARE @dnnVer INT SET @dnnver = (SELECT TOP 1 Major*10000+Minor*100+Build FROM dbo.[Version] ORDER BY Major DESC, Minor DESC, Build DESC) IF @dnnver < 30203 OR ( @dnnver >= 40000 AND @dnnver <40004) BEGIN INSERT INTO UDT_Install_Semaphore (value) VALUES (0) RAISERROR ('Incompatible DotNetNuke framework version installed. Please upgrade to V. 3.3 or V. 4.1 or re-install previous version of this module!', 16, 1) END ELSE INSERT INTO UDT_Install_Semaphore (value) VALUES (1) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** Add extended settings for UDT fields **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_AddData]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_AddData] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_AddField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_AddField] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_GetField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_GetField] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_GetFields]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_GetFields] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_UpdateField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_UpdateField] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_UpdateFieldOrder]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_UpdateFieldOrder] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_SwapFieldOrder]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_SwapFieldOrder] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** Optimize indexes AND PK **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_UserDefinedData') DROP INDEX UserDefinedData.[IX_UserDefinedData] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_UserDefinedData_1') DROP INDEX UserDefinedData.[IX_UserDefinedData_1] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND EXISTS (SELECT name FROM sysindexes WHERE name = 'PK_UserDefinedData') ALTER TABLE dbo.[UserDefinedData] DROP CONSTRAINT [PK_UserDefinedData] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND NOT (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[UserDefinedData]'),'UserDefinedDataId','AllowsNull')) IS NULL ALTER TABLE dbo.[UserDefinedData] DROP COLUMN [UserDefinedDataId] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 ALTER TABLE dbo.[UserDefinedData] WITH NOCHECK ADD CONSTRAINT [PK_UserDefinedData] PRIMARY KEY CLUSTERED ([UserDefinedFieldId], [UserDefinedRowId]) ON [PRIMARY] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_UserDefinedFields') DROP INDEX UserDefinedFields.[IX_UserDefinedFields] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 CREATE UNIQUE INDEX [IX_UserDefinedFields] ON dbo.[UserDefinedFields] (ModuleId, FieldOrder) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** update existing tables **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND (SELECT value FROM UDT_Install_Semaphore) = 1 AND (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[UserDefinedFields]'),'ExtendedSettings','AllowsNull')) IS NULL ALTER TABLE dbo.UserDefinedFields ADD ExtendedSettings nvarchar(2000) DEFAULT ('') NOT NULL System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** add fields Created at/by & last updated at/by **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedFields] (ModuleID, FieldTitle, Visible, FieldOrder, FieldType, Required) SELECT ModuleID, 'Created by' AS fTitle, 0 AS vis, MAX(FieldOrder) + 1 AS NewOrder, 'CreatedBy' as fType, 1 AS req FROM [UserDefinedFields] WHERE NOT ModuleID IN (SELECT ModuleID FROM [UserDefinedFields] WHERE FieldType = 'CreatedBy') GROUP BY ModuleID System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedFields] (ModuleID, FieldTitle, Visible, FieldOrder, FieldType, Required, [Default]) SELECT ModuleID, 'Created at' ASfTitle, 0 AS vis, MAX(FieldOrder) + 1 AS NewOrder, 'CreatedAt' as fType, 1 AS req, GetDate() as now FROM [UserDefinedFields] WHERE NOT ModuleID IN (SELECT ModuleID FROM [UserDefinedFields] WHERE FieldType = 'CreatedAt') GROUP BY ModuleID System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedFields] (ModuleID, FieldTitle, Visible, FieldOrder, FieldType, Required) SELECT ModuleID, 'Last updated by' AS fTitle, 0 AS vis, MAX(FieldOrder) + 1 AS NewOrder, 'ChangedBy' as fType, 1 AS req FROM [UserDefinedFields] WHERE NOT ModuleID IN (SELECT ModuleID FROM [UserDefinedFields] WHERE FieldType = 'ChangedBy') GROUP BY ModuleID System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedFields] (ModuleID, FieldTitle, Visible, FieldOrder, FieldType, Required, [Default]) SELECT ModuleID, 'Last updated at' AS fTitle, 0 AS vis, MAX(FieldOrder) + 1 AS NewOrder, 'ChangedAt' as fType, 1 AS req, GetDate() as now FROM [UserDefinedFields] WHERE NOT ModuleID IN (SELECT ModuleID FROM [UserDefinedFields] WHERE FieldType = 'ChangedAt') GROUP BY ModuleID System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** DROP rows without values **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 DELETE UserDefinedRows FROM dbo.UserDefinedRows LEFT JOIN dbo.UserDefinedData ON UserDefinedRows.UserDefinedRowId = UserDefinedData.UserDefinedRowId WHERE UserDefinedData.UserDefinedRowId IS NUll System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** add default values for existing records **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedData] (UserDefinedFieldId, UserDefinedRowId, FieldValue) SELECT UserDefinedFields.UserDefinedFieldId, UserDefinedRows.UserDefinedRowId, 'UDT-Import' As aUserName FROM (dbo.UserDefinedFields INNER JOIN dbo.UserDefinedRows ON UserDefinedFields.ModuleID = UserDefinedRows.ModuleID) LEFT JOIN dbo.UserDefinedData ON UserDefinedFields.UserDefinedFieldId = UserDefinedData.UserDefinedFieldId AND UserDefinedRows.UserDefinedRowId = UserDefinedData.UserDefinedRowId WHERE FieldType IN ('CreatedBy', 'ChangedBy') AND UserDefinedData.UserDefinedFieldId IS Null System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.[UserDefinedData] (UserDefinedFieldId, UserDefinedRowId, FieldValue) SELECT UserDefinedFields.UserDefinedFieldId, UserDefinedRows.UserDefinedRowId, GetDate() AS theDate FROM (dbo.UserDefinedFields INNER JOIN dbo.UserDefinedRows ON UserDefinedFields.ModuleID = UserDefinedRows.ModuleID) LEFT JOIN dbo.UserDefinedData ON UserDefinedFields.UserDefinedFieldId = UserDefinedData.UserDefinedFieldId AND UserDefinedRows.UserDefinedRowId = UserDefinedData.UserDefinedRowId WHERE FieldType IN ('CreatedAt', 'ChangedAt') AND UserDefinedData.UserDefinedFieldId IS Null System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** move AND rename Settings FROM ModuleSettings to TabModuleSettings **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 INSERT INTO dbo.TabModuleSettings (TabModuleID, SettingName, SettingValue) SELECT TabModules.TabModuleID, 'UDT_' + ModuleSettings.SettingName AS SN, ModuleSettings.SettingValue FROM dbo.TabModules INNER JOIN dbo.ModuleSettings INNER JOIN dbo.ModuleDefinitions INNER JOIN dbo.Modules ON ModuleDefinitions.ModuleDefID = Modules.ModuleDefID ON ModuleSettings.ModuleID = Modules.ModuleID ON TabModules.ModuleID = Modules.ModuleID WHERE ModuleSettings.SettingName IN (N'AlternatingItemStyleBackColor', N'sortfield', N'sortorder', N'Paging') AND (ModuleDefinitions.FriendlyName = N'User Defined Table') System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 DELETE ModuleSettings FROM dbo.ModuleSettings INNER JOIN dbo.Modules ON ModuleSettings.ModuleID = Modules.ModuleID INNER JOIN dbo.ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID WHERE ModuleDefinitions.FriendlyName = N'User Defined Table' AND ModuleSettings.SettingName IN (N'AlternatingItemStyleBackColor', N'sortfield', N'sortorder', N'Paging') System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 UPDATE ModuleSettings SET ModuleSettings.SettingName = 'UDT_' + ModuleSettings.SettingName FROM dbo.ModuleSettings INNER JOIN dbo.Modules ON ModuleSettings.ModuleID = Modules.ModuleID INNER JOIN dbo.ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID WHERE ModuleDefinitions.FriendlyName = N'User Defined Table' AND ModuleSettings.SettingName IN (N'ImageWidth', N'URLFullPath') System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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 new stored procedures **/ CREATE PROCEDURE dbo.[UserDefinedTable_GetField] @UserDefinedFieldId INT AS SELECT UserDefinedFieldId, ModuleID, FieldTitle, Required, FieldOrder, FieldType, [default], Visible, ExtendedSettings FROM UserDefinedFields WHERE UserDefinedFieldId = @UserDefinedFieldId System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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.[UserDefinedTable_GetFields] @ModuleId INT AS SELECT UserDefinedFieldId, ModuleID, FieldTitle, Required, FieldOrder, FieldType, [default], Visible, ExtendedSettings FROM UserDefinedFields WHERE ModuleId = @ModuleId ORDER BY FieldOrder System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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.[UserDefinedTable_AddField] @ModuleId INT, @FieldTitle VARCHAR(50), @Required BIT, @FieldType VARCHAR(20), @default NVARCHAR(2000), @Visible BIT, @ExtendedSettings nvarchar(2000) AS DECLARE @InsPos INT SET @InsPos = (SELECT MAX(FieldOrder) AS MaxPos FROM dbo.UserDefinedFields WHERE ModuleID = @ModuleID GROUP BY ModuleID) + 1 IF @insPos IS Null SET @InsPos = 1 INSERT INTO UserDefinedFields ( ModuleId, FieldTitle, Required, FieldType, FieldOrder, [Default], Visible, ExtendedSettings ) VALUES ( @ModuleId, @FieldTitle, @Required, @FieldType, @InsPos, @default, @Visible, @ExtendedSettings ) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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.[UserDefinedTable_UpdateField] @UserDefinedFieldId INT, @FieldTitle VARCHAR(50), @Required BIT, @FieldType VARCHAR(20), @default NVARCHAR(2000), @Visible BIT, @ExtendedSettings NVARCHAR(2000) AS UPDATE UserDefinedFields SET FieldTitle = @FieldTitle, Required = @Required, FieldType = @FieldType, [default] = @default, Visible = @Visible, ExtendedSettings = @ExtendedSettings WHERE UserDefinedFieldId = @UserDefinedFieldId System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_AddData' in the database. 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.UserDefinedTable_AddData @UserDefinedRowId INT, @UserDefinedFieldId INT, @FieldValue nvarchar(2000) AS INSERT INTO UserDefinedData ( UserDefinedFieldId, UserDefinedRowId, FieldValue ) VALUES ( @UserDefinedFieldId, @UserDefinedRowId, @FieldValue ) System.Data.SqlClient.SqlException: Cannot drop the table 'UDT_Install_Semaphore', because it does not exist or you do not have permission. 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) /** delete version table **/ DROP TABLE UDT_Install_Semaphore
EndJob End Sql execution: 03.03.00.SqlDataProvider file
 
Info Executing 03.03.04.SqlDataProvider
StartJob Start Sql execution: 03.03.04.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The default schema does not exist. 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 TABLE UDT_Install_Semaphore (value INT PRIMARY KEY) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) DECLARE @dnnVer INT SET @dnnver = (SELECT TOP 1 Major*10000+Minor*100+Build FROM dbo.[Version] ORDER BY Major DESC, Minor DESC, Build DESC) IF @dnnver < 30203 OR ( @dnnver >= 40000 AND @dnnver <40004) BEGIN INSERT INTO UDT_Install_Semaphore (value) VALUES (0) RAISERROR ('Incompatible DotNetNuke framework version installed. Please upgrade to V. 3.3 or V. 4.1 or re-install previous version of this module!', 16, 1) END ELSE INSERT INTO UDT_Install_Semaphore (value) VALUES (1) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** Convert DataType for FieldTitle from VARCHAR to NVARCHAR in order to allow usage of Unicode characters **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND (SELECT UserType FROM syscolumns WHERE id = object_id(N'dbo.[UserDefinedFields]') AND Name = 'FieldTitle')=2 ALTER TABLE dbo.UserDefinedFields ALTER COLUMN FieldTitle NVARCHAR(50) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_AddField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_AddField] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_UpdateField]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_UpdateField] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_UpdateFieldOrder]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_UpdateFieldOrder] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_SwapFieldOrder]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_SwapFieldOrder] System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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.[UserDefinedTable_AddField] @ModuleId INT, @FieldTitle NVARCHAR(50), @Required BIT, @FieldType VARCHAR(20), @default NVARCHAR(2000), @Visible BIT, @ExtendedSettings NVARCHAR(2000) AS DECLARE @InsPos INT SET @InsPos = (SELECT MAX(FieldOrder) AS MaxPos FROM dbo.UserDefinedFields WHERE ModuleID = @ModuleID GROUP BY ModuleID) + 1 IF @insPos IS Null SET @InsPos = 1 INSERT INTO UserDefinedFields ( ModuleId, FieldTitle, Required, FieldType, FieldOrder, [Default], Visible, ExtendedSettings ) VALUES ( @ModuleId, @FieldTitle, @Required, @FieldType, @InsPos, @default, @Visible, @ExtendedSettings ) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name 'ExtendedSettings'. 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.[UserDefinedTable_UpdateField] @UserDefinedFieldId INT, @FieldTitle NVARCHAR(50), @Required BIT, @FieldType VARCHAR(20), @default NVARCHAR(2000), @Visible BIT, @ExtendedSettings NVARCHAR(2000) AS UPDATE UserDefinedFields SET FieldTitle = @FieldTitle, Required = @Required, FieldType = @FieldType, [default] = @default, Visible = @Visible, ExtendedSettings = @ExtendedSettings WHERE UserDefinedFieldId = @UserDefinedFieldId System.Data.SqlClient.SqlException: Cannot drop the table 'UDT_Install_Semaphore', because it does not exist or you do not have permission. 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) /** delete version table **/ DROP TABLE UDT_Install_Semaphore
EndJob End Sql execution: 03.03.04.SqlDataProvider file
 
Info Executing 03.03.05.SqlDataProvider
StartJob Start Sql execution: 03.03.05.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The default schema does not exist. 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 TABLE UDT_Install_Semaphore (value INT PRIMARY KEY) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) DECLARE @dnnVer INT SET @dnnver = (SELECT TOP 1 Major*10000+Minor*100+Build FROM dbo.[Version] ORDER BY Major DESC, Minor DESC, Build DESC) IF @dnnver < 30203 OR ( @dnnver >= 40000 AND @dnnver <40004) BEGIN INSERT INTO UDT_Install_Semaphore (value) VALUES (0) RAISERROR ('Incompatible DotNetNuke framework version installed. Please upgrade to V. 3.3.x or V. 4.3.x or re-install previous version of this module!', 16, 1) END ELSE INSERT INTO UDT_Install_Semaphore (value) VALUES (1) System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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) /** Convert DataType for FieldValue from NVARCHAR to NTEXT in order to allow large Texts **/ IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND (SELECT Type FROM syscolumns WHERE id = object_id(N'dbo.[UserDefinedData]') AND Name = 'FieldValue')<>35 ALTER TABLE dbo.UserDefinedData ALTER COLUMN FieldValue NTEXT NOT NULL System.Data.SqlClient.SqlException: Cannot switch to in row text in table "UserDefinedData". 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) sp_tableoption N'dbo.[UserDefinedData]', 'text in row', 'ON' IF (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_AddData]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_AddData] System.Data.SqlClient.SqlException: Invalid object name 'UDT_Install_Semaphore'. 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 (SELECT value FROM UDT_Install_Semaphore) = 1 AND exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[UserDefinedTable_UpdateData]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.[UserDefinedTable_UpdateData] System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_AddData' in the database. 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.UserDefinedTable_AddData @UserDefinedRowId int, @UserDefinedFieldId int, @FieldValue nText AS INSERT INTO UserDefinedData ( UserDefinedFieldId, UserDefinedRowId, FieldValue) VALUES (@UserDefinedFieldId, @UserDefinedRowId, @FieldValue) System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_UpdateData' in the database. 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.[UserDefinedTable_UpdateData] @UserDefinedRowId int, @UserDefinedFieldId int, @FieldValue nText AS DELETE FROM dbo.[UserDefinedData] WHERE UserDefinedFieldId = @UserDefinedFieldId AND UserDefinedRowId = @UserDefinedRowId IF @FieldValue NOT LIKE '' INSERT INTO dbo.[UserDefinedData] ( UserDefinedFieldId, UserDefinedRowId, FieldValue) VALUES (@UserDefinedFieldId, @UserDefinedRowId,@FieldValue) System.Data.SqlClient.SqlException: Cannot drop the table 'UDT_Install_Semaphore', because it does not exist or you do not have permission. 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) /** delete version table **/ DROP TABLE UDT_Install_Semaphore
EndJob End Sql execution: 03.03.05.SqlDataProvider file
 
Info Executing 03.03.06.SqlDataProvider
StartJob Start Sql execution: 03.03.06.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'UserDefinedTable_SwapFieldOrder' in the database. 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.[UserDefinedTable_SwapFieldOrder] @FirstUserDefinedFieldId INT, @SecndUserDefinedFieldId INT AS DECLARE @Pos1 INT DECLARE @Pos2 INT SET @Pos1 = (SELECT FieldOrder FROM dbo.UserDefinedFields WHERE UserDefinedFieldId = @FirstUserDefinedFieldId) SET @Pos2 = (SELECT FieldOrder FROM dbo.UserDefinedFields WHERE UserDefinedFieldId = @SecndUserDefinedFieldId) UPDATE UserDefinedFields SET FieldOrder = -1 WHERE UserDefinedFieldId = @SecndUserDefinedFieldId UPDATE UserDefinedFields SET FieldOrder = @Pos2 WHERE UserDefinedFieldId = @FirstUserDefinedFieldId UPDATE UserDefinedFields SET FieldOrder = @Pos1 WHERE UserDefinedFieldId = @SecndUserDefinedFieldId
EndJob End Sql execution: 03.03.06.SqlDataProvider file
 
EndJob Finished Sql execution
 
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
 
StartJob Expanding Resource file
EndJob Resource Files created
 
Info Created D:\Clients\C3526\udoido.com\public_html\bin\DotNetNuke.Modules.UserDefinedTable.dll
Info Created D:\Clients\C3526\udoido.com\public_html\bin\DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.dll
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Uninstall.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.02.00.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.03.04.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.03.05.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\Providers\DataProviders\SqlDataProvider\03.03.06.SqlDataProvider
Info Created D:\Clients\C3526\udoido.com\public_html\DesktopModules\UserDefinedTable\DNN_UserDefinedTable.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
EndJob Installation successful.

 

 

 

 
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListError: Manage User Defined Table is currently unavailable. PLS HELP!Error: Manage User Defined Table is currently unavailable. PLS HELP!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out