DNN Forums

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

Forum: SQL and SQL Server

You are not authorized to create a new topic
13 Subscribed to this forum
Page 1 of 212 > >>


Last Post

How do I force refresh/update table on website    

Started By  Toni Frisbie
(Topic has multiple pages1 2 )
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...
152 4
by  Daniel ValadasJump to last post
7/2/2024 3:35 PM

FirstName and LastName being set blank    

Started By  Joe
I realize this is not the correct place for this, but I really dont know where to look and hopefully you can point me to the correct location. DNN has started setting the users.firstname, users.lastname to '' (Blank).  I ran a trace on the DB and here is the code see where 2=N'',3=N'' is set to blank. exec sp_executesql N';Exec dbo.UpdateUser 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15',N'0 int,1 int,2 nvarchar(4000),3 nvarchar(4000),4 int,5 nvarchar(4000),...
3 863 1
by  JoeJump to last post
11/29/2023 5:42 PM

Help with SQL Query    

Started By  amurraygbhu
I am using DNN Platform and I need help with an SQL query I am trying to run using the DNN SQL Console. I need to change a small block of code that is used in several locations throughout the website. So I am trying to write an SQL query that searches the htmltext table for modules that still contain the block of code in the content field as I have changes it in a few locations already. Here is the query Select moduleid from htmltext where content like 'codeblock' The problem is that th...
5 1528 4
by  amurraygbhuJump to last post
5/5/2023 8:33 AM

Database and DNN upgrade best practices    

Started By  Joshua Rose
So I'm looking at best practices upgrading DNN in a test/dev environment when there are active changes happening in a production context. Our ops team handles all servers and has just started naming them slightly different names in a production database environment then not changing the database name when it goes live. For example one dnn site in a test environment has this connection string name='SiteSqlServer' connectionString='Data Source=[Server]\PROD;Initial Catalog=clientname;User...
2 1387 2
by  Michael TobischJump to last post
9/28/2022 6:58 AM

SQL Log Files    

Started By  MrPuffyNZ
Hi Team, I have my sql log files growing too large taking up lots of disk space, I know that when first creating the database for each site the log is set to full and can be changed to simple. What I am wanting to know what is the best way to truncate these files and reclaim the disk space and am I best to change all the log file instances in each site to simple and do a full backup. Your help would be appreciated regards
3 1426 0
by  Michael TobischJump to last post
3/31/2022 3:52 AM

Adding User Via SQL | Updating User ID    

Started By  JordanM
Hi all, All users from my websites had been permanently deleted, these users had a re-occuring payment via paypal. Each Payment would send a notification to the website, extending a expiry date for the subscription role on that user. The Unique identifier is the 'UserID'. Once a user is deleted the UserID is gone. I can create a user via SQL scipt below - I then update DBO.profile, DBO.userprofile, DBO.Userportal,DBO.Userroles. - which shows the profile in DNN. But when I try to login to a u...
3608 2
by  Michael TobischJump to last post
12/27/2021 2:58 AM

DNN 9.1.1 on SQL 2019    

Started By  John Taylor
We're not in a position to upgrade DNN just yet but would like to move from SQL 2014 to 2019 on the database side.  After restoring the database and 'fixing' the logins, I can connect with SQLCMD using the SQL credentials and run a query but DNN is having an issue.  I am the DBA and know next to nothing about DNN other than updating the server name in the web.config file.   We're getting this error: Exception information:      Exception type: NullReferenceException      Exception message...
2 2230 1
by  John TaylorJump to last post
11/9/2020 12:04 PM

SQL query: Use of specific module    

Started By  catemarie2323
New to SQL, I hope this is simple.  I need a list of all pages that use a specific 2sxc content template. The template is called 'sidebar_links' so what would this query look like I need to basically rebuild all pages that use this and I don't know where they are.  I was able to export a list of pages using this template but it provides the page names as a GUID and I don't know how to translate this into a page name, which I supposed would be another option, but then I would have to trans...
1 1732 0
by  Joe CraigJump to last post
9/25/2020 8:43 AM

SQL Server 2014 Restore failure    

Started By  Patrick M
I had this problem on a VPS with SQL 2014 Express. There was not enough security permission to a do a restore from the default backup directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup (although backups worked fine) The error was: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. Actually, you ca...
6 3737 1
by  Patrick MJump to last post
7/21/2020 12:06 PM

XMod Pro Control Panel Connection String for additional Local Server database    

Started By  MarSim
I posted this question on the XMod Pro site but haven't received a response. I have a second local SQL database (in addition to the DNN database). I am trying to connect to that database using XMod Pro > Control Panel > Manage Forms > New Form > Data Source: External SQL Server Database Table > Connection String: 'Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|mssextradb.mdf;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient' Then I click 'Load Ta...
2626 1
by  shasdJump to last post
7/7/2020 8:25 AM
You are not authorized to create a new topic
Page 1 of 212 > >>

RSS Feed Available

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