YAFLogo

azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
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

https://studio01.ir 
View All Posts by User
Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
3 years ago
Which version are you running?

Did you run the upgrade wizard?

View All Posts by User
+1
azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
 image.png You have insufficient rights to see the content.

current version is: 2.31.146017

I have run upgrade version to the latest version Yesterday

https://studio01.ir 
View All Posts by User
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
3 years ago
Can you check the database if the yaf_TopicTag table exist in the dnn installation?
View All Posts by User
+1
azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
this table is not exist

 image.png You have insufficient rights to see the content.

https://studio01.ir 
View All Posts by User
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
3 years ago
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

View All Posts by User
+1
azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
😯

I see it.

can I change the owner manually?

https://studio01.ir 
View All Posts by User
azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
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?
https://studio01.ir 
View All Posts by User
azarbara
  • azarbara
  • 86% (Honored)
  • YAF Lover Topic Starter
3 years ago
after this change the issue has resolved
https://studio01.ir 
View All Posts by User
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
3 years ago
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

View All Posts by User
+1
yaf_TopicTag
Similar Topics
Users browsing this topic