| Posted by: Harlequin - Thursday, 17 January 2013 16:50:21 |
|---|
| I am running on a upgraded (from DNN 6.2) DNN 7.0.2 trying to install latest DNN YAF. I am on .NET 4 and ran the DNN7 fix database sql script. However, after I click on the lic acceptance box and hit next the install page just sit on the waiting/working animation on my browser tab. I let it sit there for almost a hr and never changed. Any help appreciated! |
| Posted by: Harlequin - Friday, 18 January 2013 03:52:12 |
|---|
|
After some searching I increased the time out number in my web.config file. That seems to have been the issue. However, now I get to the first screen to enter the password. I enter the password I entered in the .config file under |
| Posted by: Harlequin - Friday, 18 January 2013 04:12:26 |
|---|
| Ok searching I just wiped the password and that got me started. I set the SQL server settings and email and it said both were good. I got to the page to add a admin. I put in my login for my DNN admin account hit next and then it said it could not connect to the sql database? The previous page said it was fine. Any help appreciated. |
| Posted by: Harlequin - Sunday, 20 January 2013 05:20:03 |
|---|
| Ok I just wiped and reinstall the module.. now I get this error when I add the module to a page to set it up; 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 --- |
| Posted by: tha_watcha - Sunday, 20 January 2013 06:56:08 |
|---|
|
Check your web.config i guess your connection string name does not match the default name in dnn which is "SiteSqlServer". If its a different name, then you need to change the YAF.ConnectionStringName Setting in the app settings area
[code=xml;-1] |
| Posted by: Harlequin - Monday, 21 January 2013 03:36:08 |
|---|
|
watcha, thank you so much for the reply. Well it seems I got the module installed, SQL issues resolved. However I am now getting the this error:
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. |
| Posted by: tha_watcha - Monday, 21 January 2013 12:52:27 |
|---|
| My only guess is that the installation was not successfully, you could try to run the install wizard again by going manually to the upgrade wizard 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 |
| Posted by: Harlequin - Monday, 21 January 2013 17:31:37 |
|---|
| Ok the setup ran without issue, db connection, email test were all fine. It finished, I went back to the module page and this is the new error I get; 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! |
| Posted by: tha_watcha - Tuesday, 22 January 2013 10:42:07 |
|---|
|
[quote=Harlequin;57351]Ok the setup ran without issue, db connection, email test were all fine. It finished, I went back to the module page and this is the new error I get;
Error: Could not find stored procedure 'dbo.wod_yaf_group_list'. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.wod_yaf_group_list'.[/quote]
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.
[code=xml;-1] |
| Posted by: Harlequin - Tuesday, 22 January 2013 21:56:52 |
|---|
| And that fixed everything! Thank you so much for your help and patience with me. I will certainly will be sending people to your project if asked. As the DNN forums quite frankly are horrible. One quick thing on on the bottom of the forum where the credits are I see this; 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! |
| Posted by: tha_watcha - Wednesday, 23 January 2013 13:14:46 |
|---|
| Sorry my mistake again, i reuploaded the files now without the message (which is only visible to admins). 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. |
| Posted by: Harlequin - Wednesday, 23 January 2013 17:14:29 |
|---|
| I uploaded files in question and everything seems to be working fine! I want to thank you again for all your help! This is a GREAT forum from what I have seen so far. 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! |
| Posted by: Harlequin - Wednesday, 23 January 2013 19:51:44 |
|---|
| One last thing I do not see a way to pin a topic..? |
| Posted by: Jaben - Wednesday, 23 January 2013 20:18:24 |
|---|
| [quote=Harlequin;57392]One last thing I do not see a way to pin a topic..?[/quote] You can favorite a topic and it will be in your favorite list. |
| Posted by: Harlequin - Thursday, 24 January 2013 17:13:19 |
|---|
| Found the pin option thanks. 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! |
| Posted by: Harlequin - Thursday, 24 January 2013 17:48:58 |
|---|
| Also the whats new module non-logged in users can't see any of the recent posts. Says no posts exist. How do I get it so visitors can see the most recent posts as well as those logged in? |
| Posted by: tha_watcha - Sunday, 27 January 2013 10:04:07 |
|---|
| [quote=Harlequin;57412]Found the pin option thanks. 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![/quote] Ok this is a serious issue, turns out all dnn roles that where importat to yaf getting the admin access mask applied. I changed that the default dnn roles "Registered Users" and "Subscribers" getting the Member Access Mask and all other Custom Dnn Roles getting the "Read Only Access Mask" by default (You can change that later in the YAF admin Area where you can modify the Access Mask for the Custom Role, after it was imported). I uploaded an updated Version (It maybe also fixes the other issue with the profile page) |
| Posted by: Harlequin - Sunday, 27 January 2013 15:52:02 |
|---|
| [quote=tha_watcha;57451][quote=Harlequin;57412]Found the pin option thanks. 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![/quote] Ok this is a serious issue, turns out all dnn roles that where importat to yaf getting the admin access mask applied. I changed that the default dnn roles "Registered Users" and "Subscribers" getting the Member Access Mask and all other Custom Dnn Roles getting the "Read Only Access Mask" by default (You can change that later in the YAF admin Area where you can modify the Access Mask for the Custom Role, after it was imported). I uploaded an updated Version (It maybe also fixes the other issue with the profile page) [/quote] Ok I will install the update and let you know. Just to let you know the user she changed her birth date to a valid date, and now I can view her profile without issue or errors. Perhaps new or imported members you should assign a date like 1/1/1980 or something like that to get rid of those 0's? Not sure if that is the issue but once a valid date was entered the issue went away. |
| Posted by: Harlequin - Sunday, 27 January 2013 23:01:47 |
|---|
| I tried to install the new version of the module and got this error during the install in DNN; Server Error in '/' Application. Request timed out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Request timed out. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HttpException (0x80004005): Request timed out.] ----/Error---- |
| Posted by: tha_watcha - Monday, 28 January 2013 11:35:35 |
|---|
|
Die you try to increase the execution timeout value in the web.config
|
| Posted by: Harlequin - Monday, 28 January 2013 16:23:41 |
|---|
| Ok I uploaded all the .DLL's from the new package. But I did increase the timeout variable for next time. Thanks. That said I am still having the issue, guests can not see data in the whats new module, it displays no data unless you are logged in. And the guests role is set to 'read only' most of the forums. Any ideas? Also did you read my post about the birth date issue? seems the default date was causing the problem. |
| Posted by: tha_watcha - Monday, 28 January 2013 16:41:50 |
|---|
| [quote=Harlequin;57462]Ok I uploaded all the .DLL's from the new package. But I did increase the timeout variable for next time. Thanks. That said I am still having the issue, guests can not see data in the whats new module, it displays no data unless you are logged in. And the guests role is set to 'read only' most of the forums. Any ideas? Also did you read my post about the birth date issue? seems the default date was causing the problem.[/quote] I changed only the code for about the roles problem, the what's new module is still unresolved. The read only access mask is applied to all custom dnn roles which are imported in to yaf. You can simply change that. Currently there is no other way when importing roles automatically. What I could do is create a setting where you can define the initial access mask for a custom role. Yes I read about the birthday issue, I hadn't time to look in to the problem. |
| Posted by: Harlequin - Monday, 28 January 2013 17:59:57 |
|---|
| [quote=tha_watcha;57463] I changed only the code for about the roles problem, the what's new module is still unresolved. The read only access mask is applied to all custom dnn roles which are imported in to yaf. You can simply change that. Currently there is no other way when importing roles automatically. What I could do is create a setting where you can define the initial access mask for a custom role. Yes I read about the birthday issue, I hadn't time to look in to the problem. [/quote] I don't mind guests default to read only, I was only stating that so you know guest should be able to see the posts in the whats new module. As if they go to the forum guests can read the forums without issue, those same posts don't appear in the whats new module however. Thanks for looking into all of these issues, I'll await word when you can look into it and post about them. On a related note, it's ok I removed all the roles except guest, registered member, admin and moderator? The other roles from the DNN site I don't need in the forums like custom roles I made and the unverified user. So I deleted them, that won't cause a issue will it or do I need all them there? |
| Posted by: Harlequin - Tuesday, 29 January 2013 01:18:26 |
|---|
| To follow up on the date issue to hopefully help you with more info, I get dozens of these errors in the event log a day mostly from guests; System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at YAF.Classes.Data.MsSqlDbAccess.GetDatasetBasic(IDbCommand cmd, Boolean transaction) at YAF.Classes.Data.MsSqlDbAccess.GetData(IDbCommand cmd, Boolean transaction) at YAF.Types.Interfaces.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd) at YAF.Classes.Data.LegacyDb.message_findunread(Object topicID, Object messageId, Object lastRead, Object showDeleted, Object authorUserID) at YAF.Pages.posts.GetFindMessageId(Boolean showDeleted, Int32 userId, Int32& messagePosition) |