Page 3 Maximum stored procedure, function, trigger, or view nesting lev

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

Development and...

SQL and SQL Ser...

Maximum stored procedure, function, trigger, or view nesting level exceeded

10/6/2014 9:15 AM

Craig Hubbard

www.Traada.com
Joined: 8/22/2005

Posts: 82

Re: Maximum stored procedure, function, trigger, or view nesting level exceeded

Sebastian Leupold wrote:
Craig,
DNN 7.3.3 upgrade script does include regions for all countries and therefore requires all countries to be present

Thanks Sebastian

At present we remove countries because of an ecommerce module that uses the countries list as the country that we sell to, unfortunately we only sell to a subset of the countries - so it's a workaround to avoid people being disappointed at the checkout.

I will test if this is a problem prior to upgrading to 7.3.3.

Cheers

Craig

Craig Hubbard TechnicaOne Business Solutions - Australia

10/6/2014 9:31 AM

Sebastian Leupold

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

Posts: 46212

Re: Maximum stored procedure, function, trigger, or view nesting level exceeded

Craig, in this case you'll need to remove all Region entries for the countries from upgrade script as well (or add a check for parent, when inserting it)

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

10/6/2014 9:39 AM

Craig Hubbard

www.Traada.com
Joined: 8/22/2005

Posts: 82

Re: Maximum stored procedure, function, trigger, or view nesting level exceeded

Sebastian Leupold wrote:
Craig, in this case you'll need to remove all Region entries for the countries from upgrade script as well (or add a check for parent, when inserting it)

Sebastian - Yes, I was just taking a deeper look as your message came through. I think I can change the modules procedure so that I don't have to change the core data.... BTW looks like you attempted to visit our site, it got blocked but should be ok for you now. We have quite aggressive security for the sites and in particular for markets that we do not sell too.

Cheers

Craig

Craig Hubbard TechnicaOne Business Solutions - Australia

Page 3 of 3

Maximum stored procedure, function, trigger, or view nesting level exceeded

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)