Adam
river guide Posts:116
|
09-08-2010 05:11 AM |
|
After an upgrade to DNN 5.5 my dynamic views module produces an error. the error is displayed when I go to Module configuration in the Dynamic views control panel, the following error is display at the bottom of the screen.... please help...
Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) 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 --- |
|
|
|
|
Adam
river guide Posts:116
|
09-08-2010 05:41 AM |
|
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? |
|
|
|
|
Adam
river guide Posts:116
|
09-08-2010 05:55 AM |
|
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 |
|
|
|
|
Candace
river guide Posts:2431
|
09-08-2010 06:57 AM |
|
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
|
|
|
|
|
THS
going with the flow Posts:48
|
09-08-2010 07:47 AM |
|
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 |
|
|
|
|
Chad Nash Posts:5260
|
09-08-2010 08:57 AM |
|
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 |
|
|
|
|
THS
going with the flow Posts:48
|
09-08-2010 09:38 AM |
|
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
|
|
|
|
|
THS
going with the flow Posts:48
|
09-10-2010 12:45 PM |
|
So, anything more on this? We still have the problem. -Tim |
|
|
|
|
Nestor
new to the springs Posts:1
|
09-10-2010 08:55 PM |
|
Dynamic Views 2.0 In 01.00.00.SqlDataProvider you can change line 589 orig Select A.ModuleID, ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A -> modified Select A.ModuleID, A.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A |
|
|
|
|
Chad Nash Posts:5260
|
09-19-2010 05:18 PM |
|
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 |
|
|
|
|
Alan UMW
skipping stones Posts:11
|
10-08-2010 11:38 PM |
|
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 |
|
|
|
|
Ryan Bakerink
river guide Posts:1900
|
10-15-2010 09:54 AM |
|
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 |
|
|
|
|
The Dad
going with the flow Posts:71
|
12-06-2010 05:02 PM |
|
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? |
|
|
|
|
Ryan Bakerink
river guide Posts:1900
|
01-20-2011 03:24 PM |
|
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
|
|
|
|
|