When clicking Add event, module times out and aborts.

[shash99]

Please summarize your question in one sentence

When attempting to display the add page, the process performs sql stored procedure(s) (aspnet_Membership_GetUserByName, and more) for every user on the system. Is this how version 7.00.07 works?

Give a more extended description

When attempting to display the add page, the process performs sql stored procedure(s) (aspnet_Membership_GetUserByName, and more) for every user on the system. We have over 92,000 users and the system will timeout and abort at just over record 7100. This occurred after the DNN upgrade to 9.10.06 and Event module v. 7.00.07. We did not have this issue before the upgrade.

Steps to reproduce (if needed)

Other comments or remarks

[WillStrohl]

Ah, this sounds like it's related to the other issue. The built-in API isn't friendly to sites with large numbers of user accounts, but the persona bar has a more optimized method for doing this (not in the main API). We've had to update this in the Upendo DNN User Manager Module recently. Here's the PR, just in case anyone here has the time to implement it in this module.

[shash99]

Hi Will, Thank you for responding. So it looks like I am at a standstill with this and in search of another calendar module. As we upgraded to DNN v 9.10.06 the issue with the events module v 7.00.07 began. The prior versions of the events module didn’t respond that way. Am I able to use a prior version of the events module that would work with my latest DNN version? If not, do you recommend another calendar module that is compatible with our DNN version? At the moment I use a backend script to insert the data into the database (not optimal). Thanks for your assistance with this. Sharon From: Will Strohl ***@***.***> Sent: Thursday, September 14, 2023 12:42 PM To: DNNCommunity/DNN.Events ***@***.***> Cc: Poirier, Sharon ***@***.***>; Author ***@***.***> Subject: [EX] Re: [DNNCommunity/DNN.Events] When clicking Add event, module times out and aborts. (Issue #252) *** CAUTION: This email originated from outside of AIPSO. ***

…

________________________________ Ah, this sounds like it's related to the other issue. The built-in API isn't friendly to sites with large numbers of user accounts, but the persona bar has a more optimized method for doing this (not in the main API). We've had to update this in the Upendo DNN User Manager Module<https://github.com/UpendoVentures/Upendo-Dnn-UserManager#readme> recently. Here's the PR<UpendoVentures/Upendo-Dnn-UserManager#76>, just in case anyone here has the time to implement it in this module. — Reply to this email directly, view it on GitHub<#252 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ABM56H5HDDVXN7R74YQ75PLX2MXU3ANCNFSM6AAAAAA4YDJP5U>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[WillStrohl]

Well, a lot of people have used a lot of other methods to display events. DnnGo has one that some people use. There's also another one by DnnSmart. I haven't used either one myself.

We tend to use a structured content module and list events, instead of implementing a calendar UI.

• Structured Content: OpenContent
• Structured Content: 2sxc

Also, it's worth noting that if you wish to just stay on this Events module, there are many people who would be willing to do the work as a sponsored project. If that's the approach you'd prefer, I'd recommend going through the Agencies on the community site. Find ~3 or so that you want to interview and choose one. Alternatively, you can do the same by targeting folks who are known to be active in the community leaderboard. Most of them are great developers and even have an agency that you may have overlooked.

So, you still have plenty of options. This module just doesn't have someone leading it the same way as it was before. That also could change. The open-source world is full of excitement and changes. :)

[shash99]

Thank you very much for this information. I’ll be researching the use of the available modules you mentioned. Take care, Sharon From: Will Strohl ***@***.***> Sent: Saturday, September 23, 2023 1:37 PM To: DNNCommunity/DNN.Events ***@***.***> Cc: Poirier, Sharon ***@***.***>; Author ***@***.***> Subject: [EX] Re: [DNNCommunity/DNN.Events] When clicking Add event, module times out and aborts. (Issue #252) *** CAUTION: This email originated from outside of AIPSO. ***

…

________________________________ Well, a lot of people have used a lot of other methods to display events. DnnGo has one<https://www.dnngo.net/OurModules/xEvent.aspx> that some people use. There's also another one by DnnSmart<https://www.dnnsmart.net/dnnmodules/supercontent/eventcalendar.aspx>. I haven't used either one myself. We tend to use a structured content module and list events, instead of implementing a calendar UI. * Structured Content: OpenContent<https://opencontent.readme.io/> * Structured Content: 2sxc<https://2sxc.org/> Also, it's worth noting that if you wish to just stay on this Events module, there are many people who would be willing to do the work as a sponsored project. If that's the approach you'd prefer, I'd recommend going through the Agencies on the community site<https://dnncommunity.org/community/agencies>. Find ~3 or so that you want to interview and choose one. Alternatively, you can do the same by targeting folks who are known to be active in the community leaderboard<https://dnncommunity.org/Community/Dashboard>. Most of them are great developers and even have an agency that you may have overlooked. So, you still have plenty of options. This module just doesn't have someone leading it the same way as it was before. That also could change. The open-source world is full of excitement and changes. :) — Reply to this email directly, view it on GitHub<#252 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ABM56H3EVVTYMVJSDKUIAADX34M35ANCNFSM6AAAAAA4YDJP5U>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[WillStrohl]

My pleasure 😄