DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

How do I force refresh/update table on website

 13 Replies
 4 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Page 1 of 212 > >>
Author
Messages
New Around Here
Posts: 4
New Around Here

Have a DNN website with an SQL DB behind it.  The issue is when I create a new user record, it does not reflect that user record in the displayed table on the utilities page.  It does create the record in the table on the backend though, and I can search for the record on the site and find it as an Admin, but I cannot see the record in the main table to be able to do anything with it.  I have also verified that I can log on as the newly created user record. 

Is there a way to force a table to refresh or repull the data?  I have restarted the website, SQL, server, etc.  Everything appears to be connecting ok. on the site I have looked at the module settings, etc. and I am not seeing anything that would prevent the new user record to populate in the master table.

This is on a Win2008R2 server, the only SQL service running is the SQL Server and the SQL Server VSS Writer.

Veteran Member
Posts: 349
Veteran Member
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
If you mean that you are manually adding a user using SQL, I highly recommend not doing that. DNN does a lot of things when a user is created such as creating a profile, calling the underlying membership provider, calling some hooks for 3rd party entensions (events), etc.
New Around Here
Posts: 4
New Around Here
No that is not what I am doing. From the Website, I am using the Add user function, sometimes it errors other times it does not, either way the record gets created and you can see it. There is another page on the dnn site that has a table on it that the record also needs to reflect in, that table never reflects new or removed user records.
Veteran Member
Posts: 349
Veteran Member
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
So the first thing would be to find out why it sometimes fails. You may be able to get some clues in 3 places:
1. The browser console (F12) and/or the network tab in devtools to see what was posted/received.
2. In the persona bar, in Admin Logs
3. On disk at Portals/_default/logs you will see daily logs.

Then for the table that displays them, what is that table made in, a custom module ?
Veteran Member
Posts: 360
Veteran Member
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
What version of DNN is this?

David Poindexter


Creator:


Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Posted By Toni Frisbie on 6/28/2024 1:50 PM
No that is not what I am doing. From the Website, I am using the Add user function, sometimes it errors other times it does not, either way the record gets created and you can see it. There is another page on the dnn site that has a table on it that the record also needs to reflect in, that table never reflects new or removed user records.

This sounds like an environmental issue with this specific instance of DNN.  If it's not a newer version, your first step should be to upgrade to the most current release you're able to.  This alone may resolve the issue for you. 

Otherwise, troubleshooting it using Daniel's suggestion is a great next step.  

 

New Around Here
Posts: 4
New Around Here
Thank you for the replies, I am sorry - this will seem like a dumb request, but I am really new to DNN - what is the easiest way to find out the version. I feel like I remember seeing that somewhere and now I cannot remember where I stumbled upon it.
Veteran Member
Posts: 360
Veteran Member
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
If you have super user access (aka "host" level access), then upon logging in you can hover the DNN icon in the upper left corner and you will see the version in a flyout menu of the "PersonaBar". This is in version 9.x. If you are in an earlier version, then it will be a little different. Just let us know if you see something other than what I have described for DNN 9.x.

If you have direct access to the SQL database, you can look in the Versions table and look for the last record. Or you can run the following from a Query window for the database of DNN:

SELECT * FROM [dbo].[Version]

David Poindexter


Creator:


New Around Here
Posts: 4
New Around Here
Thank you - I see it was Last Updated By Administrator Account On 6/1/2022 1:48:46 PM. I am logged in as the Administrator, and I am seeing this under Extensions:
Framework
DotNetNuke DotNetNuke Community Edition 5.6.2 Critical Update Available. [Click Here To Get The Upgrade]

So do I just need the upgrade package or do I need all of the packages from GitHub? Also, Is there a best practice to upgrading? There is not a dev site for this company, so I want to make sure I do not completely blow them out of the water. I am a sys admin by trait, not so much web app or SQL, but I am crash learning!

Thank you in advanced.
Senior Member
Posts: 1607
Senior Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!

If you have direct access to the file system, you can also look at the details in the properties of the <code>DotNetNuke.dll</code> assembly to see what that version is. 

Page 1 of 212 > >>

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved