I have just created a new DNN 4.0.2 web site using Visual Wev Developer and I noticed one of the log files 03.01.01.log conatined an error. The log file is copied below. It says that it cannot create a stored procedure "dbo.GetList" because of a syntax error -the table "Lists" does not contain the column "DisplayName".  And I can tell you its right, there is no such column in my Lists table. There is no stored procedure GetList in the database, so none of the upgrade parts of the install (such as 3.00.02 or 4.00.00) fixed this.

Apart from that, things seem OK.

Need I concern myself ?

 Here is the complete log file:

System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Invalid column name 'DisplayName'.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE procedure dbo.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 Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
    (SELECT COUNT(EntryID) FROM Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
    IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key],    
    IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
    IsNull((SELECT [ListName] + '.' + [Value] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
    IsNull((SELECT [ListName] + '.' + [Text] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
    IsNull((SELECT [ListName] FROM Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
    From Lists E (nolock)
    where  ([ListName] = @ListName or @ListName='')
    and (DefinitionID = @DefinitionID or @DefinitionID = -1)
    Order By E.[Level], E.[DisplayName]
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 Lists WHERE [ListName] = E.[ListName]) As [MaxSortOrder],
    (SELECT COUNT(EntryID) FROM Lists WHERE [ListName] = E.[ListName] AND ParentID = E.[ParentID]) As EntryCount,
    IsNull((SELECT [ListName] + '.' + [Value] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [Key],    
    IsNull((SELECT [ListName] + '.' + [Text] + ':' FROM Lists WHERE [EntryID] = E.[ParentID]), '') + E.[ListName] As [DisplayName],
    IsNull((SELECT [ListName] + '.' + [Value] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [ParentKey],
    IsNull((SELECT [ListName] + '.' + [Text] FROM Lists WHERE [EntryID] = E.[ParentID]), '') As [Parent],
    IsNull((SELECT [ListName] FROM Lists WHERE [EntryID] = E.[ParentID]),'') As [ParentList]
    
    From Lists E (nolock)
    where  [ListName] = @ListName And
    [ParentID] = (SELECT [EntryID] From Lists Where [ListName] = @ParentListName And [Value] = @ParentValue)    
    Order By E.[Level], E.[DisplayName]

End