 |
|
|
 |
Joined: 10/30/2004
Posts: 293
|
|
|
Hi just wondered if anyone had recieved this error on upgrading forum to current release.
StartJob Starting Installation
Info Starting Installation - DNN_Forum
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 04.04.04.SqlDataProvider
Info Executing 04.04.04.SqlDataProvider
Info Start Sql execution: 04.04.04.SqlDataProvider file
Info End Sql execution: 04.04.04.SqlDataProvider file
Info Created - 04.04.05.SqlDataProvider
Info Executing 04.04.05.SqlDataProvider
Info Start Sql execution: 04.04.05.SqlDataProvider file
Info End Sql execution: 04.04.05.SqlDataProvider file
Info Created - 04.05.00.SqlDataProvider
Info Executing 04.05.00.SqlDataProvider
Info Start Sql execution: 04.05.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DECLARE @default_constraint_name SYSNAME, @sql NVARCHAR(3750) IF EXISTS ( SELECT name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_Users') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'Emailformat' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_Users') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'Emailformat' ) SET @sql = N'ALTER TABLE dbo.Forum_Users DROP Constraint ' + @default_constraint_name EXEC sp_executesql @sql END System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Users ADD CONSTRAINT DF_Forum_Users_Emailformat DEFAULT (1) FOR Emailformat System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DECLARE @default_constraint_name SYSNAME, @sql NVARCHAR(3750) IF EXISTS ( SELECT name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) SET @sql = N'ALTER TABLE dbo.Forum_EmailQueue_TaskEmails DROP Constraint ' + @default_constraint_name EXEC sp_executesql @sql END System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_EmailQueue_TaskEmails ADD CONSTRAINT DF_Forum_EmailQueue_TaskEmails_DateAdded DEFAULT (GETDATE()) FOR DateAdded
Info End Sql execution: 04.05.00.SqlDataProvider file
Info Created - 04.05.02.SqlDataProvider
MK
|
| |
|
|
 | |
|
|
|
Joined: 10/30/2004
Posts: 293
|
|
|
AssemblyVersion: 5.1.4
PortalID: 0
PortalName: -= Forum =-
UserID: 9393
UserName: JR
ActiveTabID: 61
ActiveTabName: ONLINE FORUMS
RawURL: /brforum/ONLINEFORUMS/tabid/61/ctl/PostDelete/mid/431/forumid/12/postid/1485/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.domain.com/brNiche/ONLINEFORUMS/tabid/61/ctl/PostDelete/mid/431/forumid/12/postid/1485/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 3.5.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 3.0.30729; AskTB5.4)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: de3c0e1f-53ed-4e79-8299-97c19fbb7ce2
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Modules.Forum.PostController.PostDelete
StackTrace:
Message: System.Exception: Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: Error: is currently unavailable. ---> DotNetNuke.Services.Exceptions.ModuleLoadException: Error: is currently unavailable. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Forum.PostController.PostDelete(Int32 PostID, Int32 ModeratorID, String Notes, Int32 PortalID, Int32 GroupID, Boolean DeleteThread, Int32 ParentID) at DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase objPortalModuleBase, Exception exc) at DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String EVENT_ARGUMENT) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String EVENT_ARGUMENT) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String EVENT_ARGUMENT) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) at DotNetNuke.Framework.PageBase.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.default_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Server Name: DEDI468
|
|
|
|
23/11/2009 08:39:01 General Exception JR AssemblyVersion: 5.1.4; PortalID: 0; PortalName< ... |
AssemblyVersion: 5.1.4
PortalID: 0
PortalName: -= FORUM =-
UserID: 9393
UserName: JR
ActiveTabID: 61
ActiveTabName: ONLINE FORUMS
RawURL: /brForum/ONLINEFORUMS/tabid/61/ctl/PostDelete/mid/431/forumid/12/postid/1485/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.domain.com/brForum/ONLINEFORUMS/tabid/61/ctl/PostDelete/mid/431/forumid/12/postid/1485/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 3.5.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 3.0.30729; AskTB5.4)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1e7ada48-3e80-4218-acf7-9df9ae45b112
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Exception: Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: Error: is currently unavailable. ---> DotNetNuke.Services.Exceptions.ModuleLoadException: Error: is currently unavailable. ---> System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Forum_Posts_Forum_Threads". The conflict occurred in database "dbniche_32063", table "dbo.Forum_Threads", column 'ThreadID'. The statement has been terminated. 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.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.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, String spName, Object[] parameterValues) at DotNetNuke.Modules.Forum.SqlDataProvider.PostDelete(Int32 PostID, Int32 ModID, String Notes, Int32 PortalID) at DotNetNuke.Modules.Forum.PostController.PostDelete(Int32 PostID, Int32 ModeratorID, String Notes, Int32 PortalID, Int32 GroupID, Boolean DeleteThread, Int32 ParentID) at DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase objPortalModuleBase, Exception exc) at DotNetNuke.Modules.Forum.PostDelete.cmdDelete_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String EVENT_ARGUMENT) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String EVENT_ARGUMENT) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String EVENT_ARGUMENT) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) at DotNetNuke.Framework.PageBase.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.default_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Server Name: DEDI468 |
|
|
As a follow up when iadmin deleted a post we got the follow error. It looked like the post was deleted but it showed it visible in forum last post but then when went to forum post it showed was deleted. Only way i could clear luckly that forum had only that post so deleted forum and re added back.
Any ideas
Craig
|
| |
|
|
| |
|
|
 |
Joined: 8/10/2003
Posts: 3594
|
|
|
Hi ,
I saw different issues on upgrading a 3.x Forum to 4.5.3. All these Forums had any issues on upgrating or installing before this upgrade. On your upgrade it looks that a constraint allready exists and the script didn't check if it exists before upgrade it. You could restore your Database and files from your previous made backup. Then check if the contrains are exists, add a "IF EXISTS" comment to the scripts or delete the constraints that affected into the database before you run the Forum upgrade.
Also some Timeouts on upgraditing I saw on Systems with a min. of Hardware or on Hostings which have a lot of other Websites and traffic. For this the solution is to restore back from your previous made backup of the Database and files. Try a new backup at time the traffic of the server isn't so much.
|
| |
|
|
| |
|
|
Joined: 2/11/2004
Posts: 22
|
|
|
Hi,
Can you fix this please ?
Thanks...
|
| |
|
|
| |
|
|
|
François, which error are you facing concretely?
|
| |
|
|
| |