With old stored procedure GetPortals copied from DNN 7.3.1 I've some problem so I've fixed the original deleting this line:

WHEN @CultureCode = 'en-US' THEN DefaultLanguage

Right?

Now with this fix all seems work fine.

Scippy,
removing the line

WHEN @CultureCode = 'en-US' THEN DefaultLanguage 

is just the modification, contained in 07.04.00.sqldataprovider of my package (besides a few other fixes and improvements, which might not hurt your site). The issue will arise only on multilingual sites, where Default language is other than 'en-US'.

Another significant issue affects sites w/o Portal 0 (for which I included a workaround in my TurboDNN).

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Scippy,
to be clear: I included a fixed version of DNN 07.04.00.sqldataprovider in my TurboDNN package, mainly due to another issue, which affects TurboDNN users on upgrades only. DNN 7.4.0 has not been repackaged, I hope this procedure will be fixed in DNN 7.4.1.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN