Hello all,

I'm getting a "vw_lists" error. this is after an upgrade to 4.6.2 on 2 different sites. I found this link to a posting on Mitchel Seller's site

http://www.mitchelsellers.com/Forums/tabid/123/forumid/2/postid/32/view/topic/Default.aspx

The upgrade went without errors and there are no object qualifiers..... I'd like to try and fix the issue and use my backups as a last resort for learning.

Any suggestions are welcome. Stack trace follows,

DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'vw_Lists'. ---> System.Data.SqlClient.SqlException: Invalid object name 'vw_Lists'. 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 DotNetNuke.Data.SqlDataProvider.GetLists(Int32 PortalID) at DotNetNuke.Common.Lists.ListController.GetListInfoDictionary(Int32 PortalId) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection(String ListName, String ParentKey, Int32 PortalID) at DotNetNuke.Common.Lists.ListController.GetListInfoCollection() at DotNetNuke.Common.Lists.ListEditor.BindTree() at DotNetNuke.Common.Lists.ListEditor.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Jeff

After pulling my head out of my butt, I finally took a good look at what was missing to give the dbo.vw_lists error I was getting on a few sites. This was due to putting up a quick site for my brand new Nephew Ben (shameless uncle plug....  www.ben.winterscom.ca ). I quickly built it on my dev site and moved it to my server. Bingo....dbo.vw_lists error.

When I do my migrations, I have been using a SQL manager to script out the db because of a shared hosting environment that I have no control over and lackluster support. For some reason the dbo.VW_LISTS view is being left out.

Here is the vie script to correct this issue (works like a charm....)

/****Copy & paste from this point forward ****/

USE [what_ever_your_db_is_called]
GO
/****** Object:  View [dbo].[vw_Lists]    Script Date: 02/11/2008 11:53:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[vw_Lists]
AS
    SELECT    
        EntryID,
        ListName,
        Value,
        Text,
        [Level],
        SortOrder,
        DefinitionID,
        ParentID,
        Description,
        PortalID,
        SystemList,
        dbo.GetListParentKey(ParentID, ListName, N'ParentKey', 0) AS ParentKey,
        dbo.GetListParentKey(ParentID, ListName, N'Parent', 0) AS Parent,
        dbo.GetListParentKey(ParentID, ListName, N'ParentList', 0) AS ParentList,
        (SELECT MAX(SortOrder) FROM dbo.[Lists] WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS MaxSortOrder,
        (SELECT COUNT(EntryID) FROM dbo.[Lists] AS Lists_1 WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS EntryCount,
        (SELECT COUNT(DISTINCT ParentID) FROM dbo.[Lists] AS Lists_2 WHERE (ParentID = L.EntryID)) AS HasChildren
    FROM  dbo.[Lists] AS L