Upgraded to DNN 9.10.06 event module not able to add/update event

[shash99]

Describe the bug

Upgraded to DNN 9.19.06 event module not able to add/update event. It just hangs until aborted. The only error that shows is that it was aborted.

To Reproduce

Steps to reproduce the behavior:

1. Go to Event Calendar

2. Click on + to add event

3. Module hangs

Expected behavior

I should get the Add event page

Screenshots

If applicable, add screenshots to help explain your problem.

Error log

nothing is displayed in error log

[WillStrohl]

FYI - You might have better results if you update the issue to follow the template format so others can have a chance to fully understand the issue you're running into. Otherwise, it will most likely go stale, and never get worked on. :(

[shash99]

FYI - You might have better results if you update the issue to follow the template format so others can have a chance to fully understand the issue you're running into. Otherwise, it will most likely go stale, and never get worked on. :(

Thanks, I added steps to reproduce. It's pretty simple when I hit the add event button the module hangs. I can't find any erro logs and the HAR file shows me not much.

[shash99]

I tried deleting the events module and re-intalling it. Now it goes into error instead of hangs and I get this error:

The value '' of the MaximumValue property of 'valReminderTime' cannot be converted to type 'Integer'.

[WillStrohl]

Without troubleshooting it, it sounds to me that maybe it didn't fully uninstall previously and you're running into a schema conflict. YOu should uninstall again, then check the file system and database to be sure it's fully uninstalled. Then, reinstall.

[shash99]

Thank you for responding, I did the reinstall after making sure fileshare and database was cleaned. The same issue exists.

[shash99]

I found out why it's not working. It times out and aborts because it calls the stored procedure
aspnet_Membership_GetUserByName for every user in our database. We have 92,450 users.

I don't know why it needs to look up every user and not just the user that is signed in.

Any idea on how to address this?

[WillStrohl]

FYI... The built-in API in DNN 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.