 |
|
|
 |
Joined: 4/8/2010
Posts: 143
|
|
|
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
|
| |
|
|
 | |
|
|
 |
 |
www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
|
|
|
not sure how this can happen as the date is set within the stored procedure, please check that addsimpleterm looks like so:
CREATE PROCEDURE [dbo].[dnn_AddSimpleTerm]
@VocabularyID int,
@Name nvarchar(250),
@Description nvarchar(2500),
@Weight int,
@CreatedByUserID int
AS
INSERT INTO dbo.dnn_Taxonomy_Terms (
VocabularyID,
[Name],
Description,
Weight,
CreatedByUserID,
CreatedOnDate,
LastModifiedByUserID,
LastModifiedOnDate
)
VALUES (
@VocabularyID,
@Name,
@Description,
@Weight,
@CreatedByUserID,
getdate(),
@CreatedByUserID,
getdate()
)
Buy the new Professional DNN7: Open Source .NET CMS Platform book
Amazon US
|
| |
|
|
| |
|
|
|
Joined: 4/8/2010
Posts: 143
|
|
|
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.
|
| |
|
|
| |
|
|
|
Joined: 4/8/2010
Posts: 143
|
|
|
Famous last words.
I just check the Events Log and it's back. Will look at the procedure.
|
| |
|
|
| |
|
|
|
Joined: 4/8/2010
Posts: 143
|
|
|
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()
|
| |
|
|
| |