• Login
  • Register

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Search this forum:
You are not authorized to create a new topic
Page 1 of 212 > >>
 Last Post
3 Replies and 300 Views SQL Log Files  300  3 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 300
by  Michael TobischJump to last post
31 Mar 2022 03:52 AM
6 Replies and 1346 Views Adding User Via SQL | Updating User ID  1346  6 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 w...
6 1346
by  Michael TobischJump to last post
27 Dec 2021 03:58 AM
2 Replies and 1409 Views DNN 9.1.1 on SQL 2019  1409  2 Started by  John Taylor We&39;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&39;re getting this error: Exception information:     ...
2 1409
by  John TaylorJump to last post
09 Nov 2020 01:04 PM
1 Replies and 902 Views SQL query: Use of specific module  902  1 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&39;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&39;t know how to translate this into a page name, which I supposed would be another option, bu...
1 902
by  Joe CraigJump to last post
25 Sep 2020 08:43 AM
6 Replies and 2715 Views SQL Server 2014 Restore failure  2715  6 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 2715
by  Patrick MJump to last post
21 Jul 2020 12:06 PM
4 Replies and 1569 Views XMod Pro Control Panel Connection String for additional Local Server database  1569  4 Started by  MarSim I posted this question on the XMod Pro site but haven&39;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" ...
4 1569
by  shasdJump to last post
07 Jul 2020 08:25 AM
5 Replies and 2068 Views Can't find DNN database with SQL Server Management Studio  2068  5 Started by  MarSim I am a total newbie with DNN. I installed DNN 9.6.1 on my local Windows PC 3 days ago and have only had one major issue. Every morning I attempt to login to my DNN site using the user name "host" and I&39;m told the password is incorrect. I am certain the password is correct and I have made no changes to the host account or password. So (1): Why is the host password being reset every night I researched how to add a new superuser by registering a new user and then changing the supe...
5 2068
by  Joe CraigJump to last post
10 Jun 2020 04:16 PM
10 Replies and 3783 Views update Lists table  3783  10 Started by  drcz
(Topic has multiple pages1 2 )
I have a very old database, running since DNN 2, and I have updating it regularely. Currently I am on last stable version DNN950. Recently I had the need to use the Countries and Regions form table Lists. And, I do not know for what reason, I have just 405 entries there and just few countries. I checked a newer database and I saw over 5000 and all the countries and regions.  One attept was to delete the entries in the old table and insert the new content. Just that the EntryID does not ma...
10 3783
by  drczJump to last post
02 May 2020 04:59 AM
3 Replies and 1992 Views Connection error after SQL server upgrade  1992  3 Started by  raymondvazquez Hello, I recently upgraded my sql server version from 2016 to 2017. Now I get &39;DNN Error Connection To The Database Failed&39; on all of my local DNN sites. My server name is the same. I have resynced logins but it does not seem to help.   Has anyone expericened this issuse and wouldn&39;t mind sharing a resoultion Please help! Thank you!
3 1992
by  Will StrohlJump to last post
04 Oct 2019 06:16 PM
2 Replies and 1565 Views sql express free  1565  2 Started by  Shankar Installing DNN with sql express (free) . How much Gb of data this can support & if there is a chance of this crossing the limit . Which is the best practise any advice please  Thanks    
2 1565
by  Sebastian LeupoldJump to last post
06 Sep 2019 03:09 AM
You are not authorized to create a new topic
Page 1 of 212 > >>

RSS Feed Available

These Forums are dedicated to 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 send an email to [email protected]
  2. No Advertising. This includes 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