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
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/dnnsof...aProvider#L165-L4803
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.
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.
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:
Awesome! Simply post in the forums using the link below and we'll get you started.