azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-03T12:47:00Z
Hi Guys,
we have error on show topic details
this is the log
2021-04-03 16:54:24.253+04:30 [WIN-GFETDMFDOD6][D:3][T:81][FATAL] DotNetNuke.Framework.PageBase - An error has occurred while loading page.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'yaf_TopicTag'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at ServiceStack.OrmLite.OrmLiteResultsFilterExtensions.ExprConvertToList[T](IDbCommand dbCmd, String sql, IEnumerable`1 sqlParams, HashSet`1 onlyFields) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteResultsFilterExtensions.cs:line 150
   at ServiceStack.OrmLite.ReadExpressionCommandExtensions.SelectMulti[T,T2](IDbCommand dbCmd, SqlExpression`1 q) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\Expressions\ReadExpressionCommandExtensions.cs:line 30
   at ServiceStack.OrmLite.OrmLiteExecFilter.Exec[T](IDbConnection dbConn, Func`2 filter) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteExecFilter.cs:line 70
   at YAF.Core.Data.DbAccessBase.Execute[T](Func`2 execFunc, IDbCommand cmd, IDbTransaction dbTransaction)
   at YAF.Controls.TopicTags.BindData()
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.<LoadRecursiveAsync>d__246.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Util.WithinCancellableCallbackTaskAwaitable.WithinCancellableCallbackTaskAwaiter.GetResult()
   at System.Web.UI.Page.<ProcessRequestMainAsync>d__523.MoveNext()
ClientConnectionId:2e8fac94-68fa-435f-9445-bc86651e35f1
Error Number:208,State:1,Class:16
2021-04-03 16:54:24.314+04:30 [WIN-GFETDMFDOD6][D:3][T:81][ERROR] DotNetNuke.Services.Exceptions.Exceptions - ~/Default.aspx?tabid=155&error=Invalid+object+name+%27yaf_TopicTag%27.&content=0
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'yaf_TopicTag'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at ServiceStack.OrmLite.OrmLiteResultsFilterExtensions.ExprConvertToList[T](IDbCommand dbCmd, String sql, IEnumerable`1 sqlParams, HashSet`1 onlyFields) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteResultsFilterExtensions.cs:line 150
   at ServiceStack.OrmLite.ReadExpressionCommandExtensions.SelectMulti[T,T2](IDbCommand dbCmd, SqlExpression`1 q) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\Expressions\ReadExpressionCommandExtensions.cs:line 30
   at ServiceStack.OrmLite.OrmLiteExecFilter.Exec[T](IDbConnection dbConn, Func`2 filter) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteExecFilter.cs:line 70
   at YAF.Core.Data.DbAccessBase.Execute[T](Func`2 execFunc, IDbCommand cmd, IDbTransaction dbTransaction)
   at YAF.Controls.TopicTags.BindData()
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.<LoadRecursiveAsync>d__246.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Util.WithinCancellableCallbackTaskAwaitable.WithinCancellableCallbackTaskAwaiter.GetResult()
   at System.Web.UI.Page.<ProcessRequestMainAsync>d__523.MoveNext()
ClientConnectionId:2e8fac94-68fa-435f-9445-bc86651e35f1
Error Number:208,State:1,Class:16
and this is my url after this error:
Default.aspx?tabid=155&error=Invalid+object+name+%27yaf_TopicTag%27.&content=0

Mathematics site in Persian language: http://rayeshmand.ir 
Sponsor
tha_watcha
2021-04-03T13:45:00Z
Which version are you running?

Did you run the upgrade wizard?
UserPostedImage
azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-04T07:36:39Z
image.png

Click to View Image5 View(s)


current version is: 2.31.146017

I have run upgrade version to the latest version Yesterday
Mathematics site in Persian language: http://rayeshmand.ir 
tha_watcha
2021-04-04T10:01:31Z
Can you check the database if the yaf_TopicTag table exist in the dnn installation?
UserPostedImage
azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-04T10:11:09Z
this table is not exist
image.png

Click to View Image4 View(s)


Mathematics site in Persian language: http://rayeshmand.ir 
tha_watcha
2021-04-04T10:37:12Z
I can see that the tables yaf_Tag and yaf_TopicTag do exist but with the wrong database owner ..

mrmohajeratsbuser.yaf_TopicTag

instead of

dbo.yaf_TopicTag

But i dont know yet why that happend
UserPostedImage
azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-04T10:43:38Z
😯
I see it.
can I change the owner manually?

Mathematics site in Persian language: http://rayeshmand.ir 
azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-04T10:54:27Z
I have change it this query
ALTER SCHEMA dbo TRANSFER mrmohajeratdbuser.yaf_Tag; 
but could you please recheck the create table schema in module Data Providers?
Mathematics site in Persian language: http://rayeshmand.ir 
azarbara
  •  azarbara
  • 85.4% (Honored)
  • YAF Lover Topic Starter
2021-04-04T10:55:32Z
after this change the issue has resolved
Mathematics site in Persian language: http://rayeshmand.ir 
tha_watcha
2021-04-04T12:00:25Z
The Database owner is defined in the appsettings in the web.config

<add key="YAF.DatabaseOwner" value="dbo" />

This Value is used during installation and upgrade
UserPostedImage

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved