DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID: a48534e5-dcab-4727-8765-b7956c603023

InnerException: Exception has been thrown by the target of an invocation.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: YAF.Classes.Config.get_ConnectionString

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object. at YAF.Classes.Config.get_ConnectionString() at YAF.Classes.Data.MsSqlDbConnectionManager.get_ConnectionString() at YAF.Classes.Data.MsSqlDbConnectionManager.InitConnection() at YAF.Classes.Data.MsSqlDbConnectionManager..ctor() --- End of inner exception stack trace --- at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.Activator.CreateInstance(Type type) at YAF.Classes.Data.MsSqlDbAccess.GetConnectionManager() at YAF.Classes.Data.MsSqlDbAccess.ExecuteScalar(IDbCommand cmd, Boolean transaction) at YAF.Types.Interfaces.IDbAccessExtensions.ExecuteScalar(IDbAccess dbAccess, IDbCommand cmd) at YAF.Classes.Data.LegacyDb.user_get(Int32 boardID, Object providerUserKey) at YAF.Core.UserMembershipHelper.GetUserIDFromProviderUserKey(Object providerUserKey) at YAF.Core.RoleMembershipHelper.UpdateForumUser(MembershipUser user, Int32 pageBoardID, String[] roles) at YAF.Core.YafContext.InitUserAndPage() at YAF.Core.UserPageBase.get_Page() at YAF.Core.UserPageBase.PageValueAsInt(String field) at YAF.Core.UserPageBase.get_PageUserID() at YAF.Forum.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

InnerException: Could not locate the guest user for the board id 1. You might have deleted the guest group or removed the guest user.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: YAF.Core.<>c__DisplayClass1.b__0

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Could not locate the guest user for the board id 1. You might have deleted the guest group or removed the guest user. ---> YAF.Core.NoValidGuestUserForBoardException: Could not locate the guest user for the board id 1. You might have deleted the guest group or removed the guest user. at YAF.Core.UserMembershipHelper.<>c__DisplayClass1.b__0() at YAF.Core.HttpRuntimeCache.GetOrSetInternal[T](String key, Func`1 getValue, Action`1 addToCacheFunction) at YAF.Core.HttpRuntimeCache.GetOrSet[T](String key, Func`1 getValue) at YAF.Core.UserMembershipHelper.get_GuestUserId() at YAF.Core.RoleMembershipHelper.UpdateForumUser(MembershipUser user, Int32 pageBoardID, String[] roles) at YAF.Core.YafContext.InitUserAndPage() at YAF.Core.UserPageBase.get_Page() at YAF.Core.UserPageBase.PageValueAsInt(String field) at YAF.Core.UserPageBase.get_PageUserID() at YAF.Forum.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

I found this thread which I think is about this issue:

http://forum.yetanotherforum.net/yaf_postst14592p3_Really-made-a-mess-of-it---Help.aspx?= 

But being a SQL novice I am really not sure what script to run as some of the conversation I get lost on. Any help greatly appreciated!

www.yourdomain.com/DesktopModules/YetAnotherForumDotNet/Install/Default.aspx

* replace the yourdomain.com with your actually url

If that doesn't help try to de-install the module again, and reinstall.

If both still fail, then i have to check the module on a new installation and find the problem

Error: YAF is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Could not find stored procedure 'dbo.wod_yaf_group_list'. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.wod_yaf_group_list'. 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() 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters) at YAF.DotNetNuke.Controller.Data.GetYafBoardRoles(Int32 boardId) at YAF.DotNetNuke.Utils.RoleSyncronizer.ImportDNNRoles(Int32 boardId, String[] roles) at YAF.DotNetNuke.Utils.RoleSyncronizer.SynchronizeUserRoles(Int32 boardId, Int32 portalId, Int32 yafUserId, UserInfo dnnUserInfo) at YAF.DotNetNuke.YafDnnModule.CheckForRoles(UserInfo dnnUser, Int32 yafUserId, MembershipUser dnnMembershipUser) at YAF.DotNetNuke.YafDnnModule.CreateOrUpdateUser() at YAF.DotNetNuke.YafDnnModule.DotNetNukeModule_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Thanks again for the help!

Ok this can not work if you are using a custom Database Object Qualifier. This means you have to uninstall and reinstall again. But before you Run the YAF install wizard adjust the YAF.DatabaseObjectQualifier Value in the app settings in the web.config.

<add key="YAF.DatabaseObjectQualifier" value="wod_yaf_" />

YAF Compiled in DEBUG MODE.

Recompile in RELEASE MODE to remove this information

But I got the module from the front page main dev site. Anyways just a minor issue. Thanks again!

If you want to update the files please don't try to reinistall this version, because dnn would skip the dll files. What you need to do is extract all dlls from the install zip and copy them over to your bin folder of your dnn installation and you are finally ready to use yaf.

Just a suggestion: I love the chat box, it would be great if you made it modular like the latest posts module so I could put that chat box on the front page separate from the forums page. This way the chat box exists in both the forums and my front page.

Also a question: If I set DNN to validate emails for new users (which works fine) do I also need to tick that same option in YAF?

Thanks again!

You can favorite a topic and it will be in your favorite list.

I do have a serious issue however. The DNN role Unverified Users keeps adding itself to the role list on YAF and giving those people mod access. As I see that role listed as a mod on the forum list. That role is not flagged as a mod and when I delete it from YAF it keeps getting re-added. How do I fix this? Thanks!