|
|
|
|
Joined: 8/10/2003
Posts: 3594
|
|
|
I have running DNN since over 12 Months, and uses the Forum Module of the Core since the first day. We used a Windows 2003 Server with Plesk 7.6.1 installed. Now I will post the problems with beginning.
Before we update to DNN 4.3.4 on Aug., 04. 2006 from DNN 4.3.3 the system runs stable. So we are using the Forum Version 3.20.08 now. On aug. 09. we have the first Problem in log with the Forum Module. Here the log:
ModuleId: -1 ModuleDefId: -1 FriendlyName: ModuleControlSource: AssemblyVersion: 04.03.04 PortalID: 0 PortalName: Moonlight Radio UserID: 126 UserName: XXXXXXX (private) ActiveTabID: 64 ActiveTabName: Forum RawURL: /dnn1/Forum/tabid/64/forumid/37/threadid/182/threadpage/2/scope/posts/Default.aspx AbsoluteURL: /dnn1/Default.aspx AbsoluteURLReferrer: http://www.moonlightradio.net/dnn1/Forum/tabid/64/forumid/37/threadid/182/scope/posts/Default.aspx UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: c231f878-2abd-4c4d-8b79-266df2bfa2e0 InnerException: This ID is already in use FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: Solpart.WebControls.SolpartMenu.AddMenuItem StackTrace: Message: DotNetNuke.Services.Exceptions.ModuleLoadException: This ID is already in use ---> System.ArgumentException: This ID is already in use bei Solpart.WebControls.SolpartMenu.AddMenuItem(XmlNode objParent, String sID, String sTitle, String sURL, String sImage, Boolean bRunatServer, String sItemStyle, String sImageStyle) bei Solpart.WebControls.SolpartMenu.AddMenuItem(String sID, String sTitle, String sURL) bei DotNetNuke.Modules.Forum.WebControls.ForumMenu.ForumMenu_Load(Object sender, EventArgs e) --- Ende der internen Ausnahmestapelüberwachung --- Source: Server-Name: XXXXXXX (private)
After this Day this thread cant be show up in the Forum. And if you try to show this thead the Server cpu will be in 100% used.
From Aug. 18 to Aug 19 our hoster notice on this days every 100% CPU used from our account, and do our account offline. Now we have a own Windows 2003 Server with Plesk 7.6.1 by this hoster. I have migrate the database to our sql-server. All Modules are running, but NOT the Forum Module. If we call the Forum on our Page we get this error message
Es ist ein kritischer Fehler aufgetreten! Could not find stored procedure 'Forum_AA_StatisticsSiteUpdate'.
Here the Log:
AssemblyVersion: 04.03.04 PortalID: 0 PortalName: Moonlight Radio UserID: 1 UserName: host ActiveTabID: 64 ActiveTabName: Forum RawURL: /dnn1/Forum/tabid/64/Default.aspx AbsoluteURL: /dnn1/Default.aspx AbsoluteURLReferrer: UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 9b10941a-112d-41ee-9219-12ad55afc3b4 InnerException: Could not find stored procedure 'Forum_AA_StatisticsSiteUpdate'. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.Data.SqlClient.SqlConnection.OnError StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: Could not find stored procedure 'Forum_AA_StatisticsSiteUpdate'. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'Forum_AA_StatisticsSiteUpdate'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData() bei System.Data.SqlClient.SqlDataReader.get_MetaData() bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) bei Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) bei DotNetNuke.Modules.Forum.SqlDataProvider.StatisticsGet(Int32 ModuleID, Int32 UpdateWindow, Int32 TabId) bei DotNetNuke.Modules.Forum.StatisticsInfo..ctor(Int32 ModuleID, Int32 TabId) bei DotNetNuke.Modules.Forum.StatisticsInfo.GetStats(Int32 ModuleID, Int32 TabId) bei DotNetNuke.Modules.Forum.Groups.RenderStatistics(HtmlTextWriter wr) bei DotNetNuke.Modules.Forum.Groups.RenderInfoContent(HtmlTextWriter wr) bei DotNetNuke.Modules.Forum.Groups.Render(HtmlTextWriter wr) bei DotNetNuke.Modules.Forum.ForumBaseControl.Render(HtmlTextWriter wr) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei ASP.desktopmodules_forum_forum_container_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Control.Render(HtmlTextWriter writer) bei DotNetNuke.Entities.Modules.PortalModuleBase.Render(HtmlTextWriter output) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) bei System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Control.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) bei System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Control.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Control.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) bei System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) bei System.Web.UI.Page.Render(HtmlTextWriter writer) bei DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer) bei System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) bei System.Web.UI.Control.RenderControl(HtmlTextWriter writer) bei System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- Ende der internen Ausnahmestapelüberwachung --- Source: Server-Name: PLESK
I have contact with Sebastian Leupold and try disable the the statistics in the Module Setting. Now the Worum shows up, and shows me All Forum Themes, Treads, Posts and the last Posts. But if I tray to show me one Forum to show me the exact threads the forum is empty. An on all Call of the Forum we get a 100% CPU use of our Server!
I have tray to delete the search index. But this have no effects. We have try to reinstall the Forum Module too, but witout deleting the Forum before, about we need still all existing threads.
In the processlist then the cidaemon.exe is in full cpu use!
Need HELP please !
Regards
Matthias
|
|
|
|
| |
|
|
|
Joined: 4/5/2003
Posts: 4377
|
|
|
First, for those viewing I don't see this as a security issue.
Second, this saying that is missing leads me to believe something went wrong on your upgrade. I am not sure what this is but you are the first to say this is not found. In most cases, I would say your object qualifier was changed.
|
|
|
|
| |
|
|
|
Joined: 8/10/2003
Posts: 3594
|
|
|
Hi Chris,
there was no change in ind dbowner or object qualifier ! The forum was run vor 2 weeks after update, only some thread was dobble in the forum. All other was perfectly runs this 2 weeks. And I have no problems with other moduls. If I have changes in this two thinks I must have any other problems with modules, like chatroom, ect.
|
|
|
|
| |
|
|
|
Joined: 8/10/2003
Posts: 3594
|
|
|
Hello Chris,
I have delete the Forum complitly. At the reinstall of the Forum I get this error Log of the Database install !
Info |
Ausführen03.10.02.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.10.02.SqlDataProvider |
Abbruch |
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: The column prefix 'Forum_Threads' does not match with a table name or alias name used in the query. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --clean up any orphan data --before we create the constraint UPDATE djhundi1963.Forum_Threads SET LastPostedPostID = (SELECT Max(FP.PostID) FROM djhundi1963.Forum_Posts FP WHERE FP.ThreadID = Forum_Threads.ThreadID AND IsApproved = 1) WHERE LastPostedPostID IN (SELECT LastPostedPostID FROM djhundi1963.Forum_Threads WHERE LastPostedPostID NOT IN (SELECT PostID FROM djhundi1963.Forum_Posts)) ALTER TABLE djhundi1963.Forum_Threads ADD CONSTRAINT FK_Forum_Threads_Forum_Posts FOREIGN KEY ( LastPostedPostID ) REFERENCES djhundi1963.Forum_Posts ( PostID ) . |
Job-Ende |
SQL-Ausführung beendet: Datei 03.10.02.SqlDataProvider |
|
Info |
Ausführen03.10.03.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.10.03.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.10.03.SqlDataProvider |
|
Info |
Ausführen03.10.04.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.10.04.SqlDataProvider |
Abbruch |
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: Invalid object name 'ModuleCONTROLS'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /***** REMOVE BLOG ITEMS, Leave a few items for possible future migration (Change foldername to avoid loosing forums data if user deletes Blog definition) *****/ DELETE FROM ModuleCONTROLS WHERE ControlSrc = 'DesktopModules/Forum/Blog_Container.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Blog_BlogEdit.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Blog_Search.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Blog_CategoryManage.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Blog_Settings.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Blog_AddComment.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Forum_BadWords.ascx' System.Data.SqlClient.SqlException: Invalid object name 'ModuleControls'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM ModuleControls WHERE ControlSrc = 'DesktopModules/Forum/Forum_BadWordEdit.ascx' System.Data.SqlClient.SqlException: Invalid object name 'DesktopModules'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE DesktopModules SET FolderName = 'Legacy Core Blog', Description = 'Legacy Core Blog, it is safe to delete this definition ONLY if you have no intentions of migrating data in future. This was only left for future migration possibility' WHERE ModuleName = 'DNN_Blog' AND FOlderName = 'Forum' . |
Job-Ende |
SQL-Ausführung beendet: Datei 03.10.04.SqlDataProvider |
|
Info |
Ausführen03.10.05.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.10.05.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.10.05.SqlDataProvider |
|
Info |
Ausführen03.20.00.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.00.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.00.SqlDataProvider |
|
Info |
Ausführen03.20.01.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.01.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.01.SqlDataProvider |
|
Info |
Ausführen03.20.02.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.02.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.02.SqlDataProvider |
|
Info |
Ausführen03.20.03.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.03.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.03.SqlDataProvider |
|
Info |
Ausführen03.20.04.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.04.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.04.SqlDataProvider |
|
Info |
Ausführen03.20.06.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.06.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.06.SqlDataProvider |
|
Info |
Ausführen03.20.07.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.07.SqlDataProvider |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.07.SqlDataProvider |
|
Info |
Ausführen03.20.08.SqlDataProvider |
Starte Job |
Starte SQL-Ausführung: Datei 03.20.08.SqlDataProvider |
Abbruch |
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: Invalid object name 'Forum_TrackedWhatsNew'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* GET RID OF BUG ISSUES FOR TRACKING */ DELETE FROM Forum_TrackedWhatsNew System.Data.SqlClient.SqlException: Invalid object name 'Forum_TrackedForums'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) DELETE FROM Forum_TrackedForums . |
Job-Ende |
SQL-Ausführung beendet: Datei 03.20.08.SqlDataProvider |
Whats UP with this ? I think this makes my Problems with my Forum. I still have a complete Database Backup, so I still can rescue my Forum. Please Help me.
Thanks!
Matthias |
|
|
|
|
| |
|
|
|
Matthias,
this might be an issue with missing databaseOwner qualifications in the statements, as many of the developers don't have the chance to test with a dbowner other than dbo (I am usually glad, if they support object qualifiers correctly). I sent you modified scripts, please test, if installation issues remain.
|
|
|
|
| |