DNN Forums

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

Forums
Search Forum
Advanced SearchTopicsPosts

update Lists table

You are not authorized to post a reply.

Forums > SQL and SQL Server

Sort:

Page 1 of 2

Author

Messages

drcz

New Around Here

Posts:18

4/21/2020 10:49 AM

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 match and of course It creates errors (could not login anymore as host, and the error was that an object was not found - though in errorlog could not have a clue that this is form the list table. In the end I have scripted the table for the backup and drop and recreated it and not I see all ok.

I need an advice how to update this table with the missing entries and still keep the entries are there without destroing the dependenccies? the IDs are not the same and has dependencies ....
thank you!
C

Brian Dukes

Advanced Member

Posts:129

4/21/2020 11:32 AM

The extra countries and regions should have been added in the 7.3.3 upgrade. Re-run this section of that script https://github.com/dnnsoftware/Dnn....L165-L4803

DNN partner specializing in custom, enterprise DNN development https://engagesoftware.com/showcase

Sebastian Leupold

Veteran Member

Posts:529

4/21/2020 12:09 PM

if you really just have a few countries in your list, running 07.03.03.SqlDataProvider won't fix it.
Besides, the region key had been changed in DNN 7.4.0, AFAIR.
You would need a sanitizing script, adding all the missing entries properly.
I hope I'll find some time next week to create it.

drcz

New Around Here

Posts:18

4/22/2020 12:43 AM

Thank you Sebastian,
yes, only 4 countries are there, and probably because of the keys changed everything got a mess just copy/paste only the content from a new DNN Lists table there.

Sebastian Leupold

Veteran Member

Posts:529

4/22/2020 8:41 AM

drcz,
I hope I'll find some time next week to create a script for you (and others with same issue).

drcz

New Around Here

Posts:18

4/30/2020 11:10 AM

It will help to know what to consider when I may insert few countries until you can do a full script: I need to get something working this week.
Thank you!

Sebastian Leupold

Veteran Member

Posts:529

5/1/2020 1:09 PM

I hadn't much time to test, but you may download the script from http://dnnwerk.de/AdjustDNNLists960.zip.

There is a known glitch, that deleted Countries and Regions are not properly listed in the summery report.

it would be nice, if you could provide some feedback.

Sebastian Leupold

Veteran Member

Posts:529

5/1/2020 1:11 PM

PS: The script does not cover bannedPasswords and ProfanityFilter lists

drcz

New Around Here

Posts:18

5/1/2020 1:26 PM

Thank you Sebastian,
I do not have too much need now for bannedPasswords and ProfanityFilter but Countries. I will do some tests and come back with feedback.
Danke

Sebastian Leupold

Veteran Member

Posts:529

5/1/2020 3:28 PM

to be honest, I didn't write this script - I only wrote the script, which generated this script.
The generator is executed on a newly installed DNN (latest version), the generated script might be executed on any DNN instance of Version DNN 7.4.2 up to 9.6.0. It adjusts any list contained in Lists table, except BannedPasswords and ProfanityFilter.

You are not authorized to post a reply.

Page 1 of 2

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:

If you have (suspected) security issues, please do not post them in the forums but send an email to [email protected]
No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
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