Have just launched a new site and I have three separate exceptions that keep occurring.  How do we go about fixing these?

This is the first one.

9/9/2011 9:45:06 AM   Search Indexer Exception       ModuleId: 639; SearchItemId: 0; Title: Our f ...

ModuleId: 639 SearchItemId: 0 Title: Our first new caravan SearchKey: 33 GUID: ItemId=33 AssemblyVersion: 5.6.3 PortalID: -1 PortalName: UserID: -1 UserName: ActiveTabID: -1 ActiveTabName: RawURL: AbsoluteURL: AbsoluteURLReferrer: UserAgent: DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: d63464d1-b6f3-480d-bf0a-1fbbf3d19cee InnerException: Cannot insert the value NULL into column 'PubDate', table 'rvsupertramp.dbo.ald_SearchItem'; column does not allow nulls. INSERT fails. The statement has been terminated. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.Data.SqlClient.SqlConnection. StackTrace: Message: DotNetNuke.Services.Exceptions.SearchException: Cannot insert the value NULL into column 'PubDate', table 'rvsupertramp.dbo.ald_SearchItem'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'PubDate', table 'rvsupertramp.dbo.ald_SearchItem'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddSearchItem(String Title, String Description, Int32 Author, DateTime PubDate, Int32 ModuleId, String Key, String Guid, Int32 ImageFileId) at DotNetNuke.Services.Search.SearchDataStoreController.AddSearchItem(SearchItemInfo item) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems) --- End of inner exception stack trace --- Source: Server Name: GENERICAU01

All help is gratefully accepted .

DNN 5.6.3 on PowerDNN

Thanks CC. I haven't run SP yet.

Had this turned up in the log too

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Raised a trouble ticket with PowerDNN and apparently that is so and they made the changes to web.config. Doing that has cured almost all errors, still a few page load errors.

Do you think I should create your SP anyway.

How it looks

/****** Object: StoredProcedure [dbo].[ald_AddSimpleTerm] Script Date: 09/10/2011 05:59:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[ald_AddSimpleTerm]
@VocabularyID int,
@Name nvarchar(250),
@Description nvarchar(2500),
@Weight int,
@CreatedByUserID int
AS
INSERT INTO dbo.ald_Taxonomy_Terms (
VocabularyID,
[Name],
Description,
Weight,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
)

VALUES (
@VocabularyID,
@Name,
@Description,
@Weight,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
)

SELECT SCOPE_IDENTITY()