Hi,

Bit of a mouthful this situation.

On a live site running dnn 5 .net 3.5, we had dynamic forms 3.0 working fine. All of a sudden the client decided to upgrade .net to 4 and dynamic forms broke. So we were advised to upgrade to 3.4 which we did. We made backups of all the forms on the site and tried to upgrade. Now we are getting install errors yet Dnn recognises it as a successful install with warnings.

Here is the error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'dnn_DynamicForms_AddUpdateDynamicExtendedSettings' 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() 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.[dnn_DynamicForms_AddUpdateDynamicExtendedSettings] @InitialJavaScript ntext, @FormHeader ntext, @FormFooter ntext, @FormDisplayAfter ntext, @ModuleID integer AS Declare @MyCount Integer Set @MyCount = (Select Count(*) from dbo.[dnn_DynamicForms_ExtendedSettings] Where ModuleID = @ModuleID) IF @MyCount = 0 BEGIN Insert Into dbo.[dnn_DynamicForms_ExtendedSettings](InitialJavaScript, FormHeader,FormFooter,FormDisplayAfter, ModuleID) Values(@InitialJavaScript,@FormHeader,@FormFooter,@FormDisplayAfter,@ModuleID) END ELSE Update dbo.[dnn_DynamicForms_ExtendedSettings] Set InitialJavaScript = @InitialJavaScript, FormHeader = @FormHeader, FormFooter = @FormFooter, FormDisplayAfter = @FormDisplayAfter Where ModuleID = @ModuleID

We think its the client made a mistake on upgrading to .net 4 framework but apparently it should be compatible.

Any ideas?

Thanks

Weng

Hi Weng,

Well only 3.4 is compatible with the .NET Framework 4.0. This error should be more of a warning, it really is saying that its trying to create a stored procedure that already exists during the install process (maybe it already executed this stored procedure during a failed install?)

As long as it did install (even with warnings) and it now shows 3.4 under host, module definitions, then you should be ok.

Thanks,

Chad

Hi Chad,

Thanks for the reply. We inserted the module on a page but we get a critical error.

A critical error has occurred.
Method 'get_EnableCdn' in type 'System.Web.UI.ScriptManager' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' does not have an implementation.

Any ideas? I can provide host access if necessary.

Weng