DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next
Forums Development and Extensions SQL and SQL Server

How do I force refresh/update table on website

 13 Replies
 4 Subscribed to this topic
 13 Subscribed to this forum
Sort:
Page 1 of 212 > >>
Author
Messages
Toni Frisbie
New Around Here
Posts: 4
New Around Here
6/28/2024 5:12 PM

    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.

    2
    Daniel Valadas
    Advanced Member
    Posts: 214
    Advanced Member
    6/28/2024 5:45 PM
      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.
      3
      Toni Frisbie
      New Around Here
      Posts: 4
      New Around Here
      6/28/2024 5: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.
        1
        Daniel Valadas
        Advanced Member
        Posts: 214
        Advanced Member
        6/28/2024 7:51 PM
          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 ?
          2
          David Poindexter
          Veteran Member
          Posts: 341
          Veteran Member
          6/29/2024 12:07 AM
            What version of DNN is this?

            David Poindexter


            Creator:


            1
            Will Strohl
            Senior Member
            Posts: 1357
            Senior Member
            6/29/2024 1:49 PM
              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.  

               

              Toni Frisbie
              New Around Here
              Posts: 4
              New Around Here
              7/2/2024 11:45 AM
                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.
                3
                David Poindexter
                Veteran Member
                Posts: 341
                Veteran Member
                7/2/2024 1:38 PM
                  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:


                  2
                  Toni Frisbie
                  New Around Here
                  Posts: 4
                  New Around Here
                  7/2/2024 2:06 PM
                    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.
                    2
                    Will Strohl
                    Senior Member
                    Posts: 1357
                    Senior Member
                    7/2/2024 2:15 PM

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

                      Page 1 of 212 > >>

                      These Forums are dedicated to the discussion of DNN Platform.

                      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