Page 3 DNN628 > DNN706 Issues - Upgrading DNN Platform

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

Home

Using DNN Platf...

Upgrading DNN P...

DNN628 > DNN706 Issues

2/23/2014 9:35 PM

haygood

Joined: 3/8/2004

Posts: 42

Re: DNN628 > DNN706 Issues

After Allow Null for IsDeleted in TabModules ... I can now add modules to pages ...

This is good - thank you again Sebastian!

2/24/2014 2:57 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: DNN628 > DNN706 Issues Modified By Sebastian Leupold on 2/24/2014 3:00:31 AM

I am glad you were able to figure it out. Another (better) option for isDeleted would be making the property not null and provide default value (0) for it - you will need to update existing records before applying this change

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

2/24/2014 8:06 AM

haygood

Joined: 3/8/2004

Posts: 42

Re: DNN628 > DNN706 Issues

Summary of my DNN706 mods to database
To enable page add
Tab table - TabPath column - check to Allow Nulls

To enable module add to page
TabModules table - IsDeleted - check to Allow Nulls
-----
I understand how to implement your other (better) option for IsDeleted by making the property not null and provide default value (0) for it.

So, I don't know which existing records require updating before applying this option.
And update to what?

Thank you.

My goal is to upgrade to DNN721

2/25/2014 2:50 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: DNN628 > DNN706 Issues Modified By Sebastian Leupold on 2/25/2014 2:52:17 AM

UPDATE TabModules set isDeleted = 0 WHERE isDeleted is Null;
ALTER TABLE TabModules ADD CONSTRAINT DF_Tabs_isDeleted DEFAULT (0) FOR isDeleted;
ALTER TABLE TabModules ALTER COLUMN isDeleted BIT NOT Null;

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

2/25/2014 9:17 AM

haygood

Joined: 3/8/2004

Posts: 42

Re: DNN628 > DNN706 Issues Modified By haygood on 2/25/2014 9:23:21 AM

Studied and understood your script. Figured I could undo it if problems arose.

Backed up my site on PowerDNN

===========================================

No Constraints present

============================================

Run Your Script

(1 row(s) affected)

=========================================================================

Results - Constraint added, IsDeleted updated ...

Recycle Application Pool

Clear Cache

Verified capability to create new page and add module. And then delete created page.

I am going to hold at DNN706 for now.

Thank you Sebastian for your support!

Page 3 of 4

DNN628 > DNN706 Issues

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

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.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)