When I try to navigate to lists in DNN4 I get the following error

Error: Lists is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.GetList' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.GetList' 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.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetList(String ListName, String ParentKey, Int32 DefinitionID) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection(String ListName, String ParentKey, Int32 DefinitionID) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection(String ListName, String ParentKey) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection(String ListName) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection() at DotNetNuke.Common.Lists.ListEditor.BindTree() in E:\brigidcollins\Admin\Lists\ListEditor.ascx.vb:line 457 at DotNetNuke.Common.Lists.ListEditor.Page_Load(Object sender, EventArgs e) in E:\brigidcollins\Admin\Lists\ListEditor.ascx.vb:line 78 --- End of inner exception stack trace ---

I'm getting the same error. What is the solution? I've been poking around trying to find the GetList stored procedure for DNN 4 with no success.

Tanks

I finally found the missing stored proc. Apparently there was a bug in the installation. The proc source was in the following file:

Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.SqlDataProvider

Here it is. Just run it from within Host > SQL

--**************************************************.

CREATE procedure {databaseOwner}{objectQualifier}GetList

@ListName nvarchar(50),
@ParentKey nvarchar(150),
@DefinitionID int

as
If @ParentKey = ''
Begin
 Select DISTINCT  
 E.[ListName],
 E.[Level], 
 E.[DefinitionID],
 E.[ParentID], 
 (SELECT MAX([SortOrder]) FROM {objectQualifier}Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
 (SELECT COUNT(EntryID) FROM {objectQualifier}Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
 IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key], 
 IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
 IsNull((SELECT [ListName] + '.' + [Value] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
 IsNull((SELECT [ListName] + '.' + [Text] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
 IsNull((SELECT [ListName] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
 From {objectQualifier}Lists E (nolock)
 where  ([ListName] = @ListName or @ListName='')
 and (DefinitionID = @DefinitionID or @DefinitionID = -1)
End
Else
Begin

 DECLARE @ParentListName nvarchar(50)
 DECLARE @ParentValue nvarchar(100)
 SET @ParentListName = LEFT(@ParentKey, CHARINDEX( '.', @ParentKey) - 1)
 SET @ParentValue = RIGHT(@ParentKey, LEN(@ParentKey) -  CHARINDEX( '.', @ParentKey))
 Select DISTINCT  
 E.[ListName],
 E.[Level], 
 E.[DefinitionID],
 E.[ParentID], 
 (SELECT MAX([SortOrder]) FROM {objectQualifier}Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
 (SELECT COUNT(EntryID) FROM {objectQualifier}Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
 IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key], 
 IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
 IsNull((SELECT [ListName] + '.' + [Value] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
 IsNull((SELECT [ListName] + '.' + [Text] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
 IsNull((SELECT [ListName] FROM {objectQualifier}Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
 
 From {objectQualifier}Lists E (nolock)
 where  [ListName] = @ListName And
 [ParentID] = (SELECT [EntryID] From {objectQualifier}Lists Where [ListName] = @ParentListName And [Value] = @ParentValue) 

End

Hi seether, thanks for your help. Its working great after this Update.

tx man its working correctly now is there any fix for core search module im getting no results always :S

I had the same problem and your solution worked for me too. Thanks !

Patrick