Hi again, after some research I have found the following details..
Your function:

[i2i_DataSprings_DynamicViews_LoadDynamicForms]
is trying to get a field called [ModuleTitle] from dnn table [Modules] but in DNN 5.5 they have removed this field from the table, for some strange reason, thus breaking your Dynamic Views module.

Can you fix it?

I have made the following fix, please can you confirm this fix is OKAY and won't have any knock on affects;

Your module =

Create Procedure [dbo].[i2i_DataSprings_DynamicViews_LoadDynamicForms_v5_4]

@PortalID Int

AS

Select ModuleID, ModuleTitle + ' / ModuleID: ' + Cast(ModuleID as nvarchar(7)) As ModuleTitle

from dbo.[i2i_Modules]

Where ModuleDefID In (Select ModuleDefID from dbo.[i2i_ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')

AND PortalID = @PortalID

AND IsDeleted =0

GO

My Fixed Module =

ALTER Procedure [dbo].[i2i_DataSprings_DynamicViews_LoadDynamicForms]

@PortalID Int

AS

Select ModuleID, Cast(ModuleDefID as nvarchar(7)) + ' / ModuleID: ' + Cast(ModuleID as nvarchar(7)) As ModuleTitle

from dbo.[i2i_Modules]

Where ModuleDefID In (Select ModuleDefID from dbo.[i2i_ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')

AND PortalID = @PortalID

AND IsDeleted =0

 

GO

Hi Adam,

We just posted a new patch in Snowcovered yesterday.  Please log in to your Snowcovered account and find Dynamic Views 1.00.50 in Patches and Hotfixes or in MyDownloads if you have the Collection 3.0.  Thanks!

Candace

I just downloaded and installed the patch. No errors during the patch install, but when adding the DV module to a page and going to config, we're getting this error at the bottom of the page:

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.DataSprings_DynamicViews_LoadDynamicForms' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.DataSprings_DynamicViews_LoadDynamicForms' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicViews.Data.SqlDataProvider.GetDynamicForms(Int32 PortalID) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.GetDynamicForms(Int32 PortalId) at DataSprings.DNN.Modules.DynamicViews.Settings.RefreshDynamicForms() at DataSprings.DNN.Modules.DynamicViews.Settings.LoadMySettings() --- End of inner exception stack trace ---

-Tim

Tim - Are you also running on 5.5? It sounds like the main stored procedure was fixed but maybe not one others (there is a missing column that was removed in 5.5).

Can you run this under Host/SQL and this should fix you up:
Create Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select ModuleID, 'Dynamic Forms / ModuleID: ' + Cast(ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = @PortalID
AND IsDeleted =0
GO


Thanks,

Chad

Chad -
I edited the script to this:

Create Procedure dbo [DataSprings_DynamicViews_LoadDynamicForms]
@PortalID = 0
AS

Select ModuleID, 'Dynamic Forms / ModuleID: ' + Cast(ModuleID as nvarchar(7)) As ModuleTitle from dbo [Modules] Where ModuleDefID In (Select ModuleDefID from dbo [ModuleDefinitions] where FriendlyName like '%Dynamic Forms%')
AND PortalID = 0
AND IsDeleted =0
GO

But, I'm getting this error when I run it:

System.Data.SqlClient.SqlException: Incorrect syntax near 'DataSprings_DynamicViews_LoadDynamicForms'. 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 ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) Create Procedure dbo [DataSprings_DynamicViews_LoadDynamicForms] @PortalID = 0 AS Select ModuleID, 'Dynamic Forms / ModuleID: ' + Cast(ModuleID as nvarchar(7)) As ModuleTitle from dbo [Modules] Where ModuleDefID In (Select ModuleDefID from dbo [ModuleDefinitions] where FriendlyName like '%Dynamic Forms%') AND PortalID = 0 AND IsDeleted =0

We're not using any object qualifiers... not sure if I edited the correct items or not.

-Tim

So, anything more on this? We still have the problem.

-Tim

Dynamic Views 2.0
In 01.00.00.SqlDataProvider you can change line 589
orig

->
modified

Thanks for posting this solution... We will be updating the build for future updates... It appears that DNN removed this column in the latest 5.5 version which is whats causing the solution.

-Chad

Hi, I have exactly the same error in Adam's first message. and I did all this post had suggested. Without any luck.

Do you have any other solution for this error? Any help appreciated.

Thanks,
Alan

Hello Alan,

If you'd like me to take a look under the hood and fix your Dynamic View can you please email me credentials to your site:

Host Username, Host Password, and the URL to your Dynamic View.

Please email me at rbakerink (at) datasprings (dot) com

If you have any questions please let me know.

Thanks,

Ryan

Chad, I'm a bit confused. Exactly what needs to be done to fix this problem? Is there a patch, I do not see one in Snowcovered. Can you give a step by step?

Hello The Dad,

Is this still unresolved for you? Please let us know so we can be of assistance.

Sorry for the delayed response.

If you have any questions please let us know.

Thanks,

Ryan