|
|
|
|
|
|
2 Replies and 603 Views
Database and DNN upgrade best practices 603 2
Started by Joshua Rose
So I&39;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=&91;Server&93;\PROD;Init...
|
|
|
|
2 |
603 |
|
|
4 Replies and 649 Views
Help with SQL Query 649 4
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 &39;codeblock&39;
The problem is...
|
|
|
|
4 |
649 |
|
|
3 Replies and 933 Views
SQL Log Files 933 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 |
933 |
|
|
6 Replies and 2400 Views
Adding User Via SQL | Updating User ID 2400 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 |
2400 |
|
|
2 Replies and 1840 Views
DNN 9.1.1 on SQL 2019 1840 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 |
1840 |
|
|
1 Replies and 1330 Views
SQL query: Use of specific module 1330 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 |
1330 |
|
|
6 Replies and 3261 Views
SQL Server 2014 Restore failure 3261 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 |
3261 |
|
|
4 Replies and 2114 Views
XMod Pro Control Panel Connection String for additional Local Server database 2114 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 |
2114 |
|
|
5 Replies and 2628 Views
Can't find DNN database with SQL Server Management Studio 2628 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 |
2628 |
|
|
10 Replies and 4708 Views
update Lists table 4708 10
Started by drcz
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 |
4708 |
by drcz 5/2/2020 3:59 AM |