DOTNETNUKE Platform Goes to C#

Posted: February 28, 2011 | Author: | Filed under: Uncategorized | Leave a comment

Just to make a note to another big change for a platform I have worked for some time. Shawn Walker announced this change today:

http://www.dotnetnuke.com/Resources/Blogs/tabid/825/EntryId/2978/DotNetNuke-Embraces-C.aspx

I have met many DOTNETNUKE celebrities at the MVP Summit today and it is an interesting day.

Missing items under HOST tab— DNN 5.6.1 bug

Posted: February 24, 2011 | Author: | Filed under: DotNetNuke (DNN) | Leave a comment

If you are running into this issue, you can search your Tabs table in dnn database with this:

SELECT   * FROM Tabs  WHERE TabPath Like ‘//Host%’ AND PortalID Is Not Null

You may see one or more records returned from above query.  If you do see more or more records,  you can run an UPDATE query to update PortalID  column’s value back to NULL for these HOST related items.

–Find it

If

Exists(SELECT 1 FROM Tabs WHERE TabPath Like ‘//Host%’ AND PortalID Is Not Null)


–Fix it

UPDATE

Tabs SET PortalID= Null WHERE TabPath Like ‘//Host%’ AND PortalID Is Not NULL

SQL Server 2005 SELECT MAX function for multiple columns

Posted: February 22, 2011 | Author: | Filed under: SQL Server, SQL Server 2005 | Leave a comment

I have participatedin  this discussion 5 years ago, and just for a record, I want to track the thread here:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b18f1209-47ae-4521-85df-66f766e59194

SQL snippet to Fill US state DropDownBox in Dynamic Forum (DNN)

Posted: February 22, 2011 | Author: | Filed under: Uncategorized | Leave a comment

Here is the code Snippet:

SELECT QuestionOption, QuestionOptionValue

FROM (SELECT ‘– Select –‘ AS QuestionOption, ‘-1’ AS QuestionOptionValue

UNION ALL

SELECT  TEXT AS QuestionOption, VALUE AS QuestionOptionValue FROM Lists WHERE ListName = ‘Region’ AND ParentID = (SELECT EntryID FROM Lists WHERE VALUE = ‘US’)) AS alias

ORDER BY QuestionOption

DNN 5.6.1 Email Validation Problem

Posted: February 8, 2011 | Author: | Filed under: DotNetNuke (DNN) | Leave a comment

There are some changes between 5.6.0 and 5.6.1 in how to validate email with RegExp in User Accounts.

These changes may break email function at DNN 5.6.1 site if you don’t have a working regular expression setup in Admin>User Settings>User Accounts Settings—-Email Address Validation: textbox.

To leave this textbox BLANK on your site may cause the validation problem with the validation bug introduced in DNN 5.6.1.

You can add a value which worked prior to 5.6.1:

\b[a-zA-Z0-9._%\-+’]+@[a-zA-Z0-9.\-]+\.[a-zA-Z]{2,4}\b

After you add this value, you can find this new entry from PotalSetting table at your DNN database. Your email validation function should work now. In our case, we can send emails from Dynamic Form (DataSpring) on our site again.

More info:http://dnn4.datasprings.com/products/product-forums/aft/23380