Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade 4.9.5 to 5.1.2 Error - Script & Package FileUpgrade 4.9.5 to 5.1.2 Error - Script & Package File
Previous
 
Next
New Post
10/1/2009 7:16 PM
Accepted Answer 

David,

check the top and end of the list of stored procedures - items with different DbOwner might be listed here.

otherwise, you might need to rebuilt the internal catalogue of items (I haven't needed it yet, please check out MSDN for details).


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/4/2009 12:59 AM
 

Hi Sebastian

Thank you very much for this! 

Just discovered 2 stored procedures at the end, and one of those is the Forums_NewsArticlesAdd. Really unsure how it happened, something I did quite some time ago I think but at least I can see the probable cause now - which i wouldn't have without your tips so it is much appreciated.

Cheers

David

 
New Post
10/4/2009 4:54 AM
 

 


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/9/2009 1:12 PM
 

Here is a follow-up for anyone else having this problem.  I had this problem and noticed some similarities between my situation and David's.  This doesn't seem to be user error, but rather a mini perfect storm that comes together to cause the problem: 

First I was using an object_identifier.  This is a field in the web.config that you can specify as a string to prefix all database objects.  Most people don't use this feature.

Second I had changed hosts and in doing so changed the username of my database during migration to the new host.  For some reason every object in my database changed owner names properly except for two stored procedures:  Forum_NewsArticleAdd and Forum_UserThreadsDelete.  I am guessing that some sort of permissions issue caused this.

The solution was to alter the owner using this script and to delete the second stored proc because for some reason it existed twice under the old database owner and the new database owner.  If you'r having this problem then consider doing the same. 

As always backup your DB and file system before going forward.  USE at YOUR OWN RISK.

**Note that the _jou in the script below was my objct identifier so replace that with your own.

alter schema [New_Owner_Name] transfer [Old_Owner_Name]._jou_Forum_NewsArticleAdd
alter authorization on [New_Owner_Name]._jou_Forum_NewsArticleAdd to schema owner

delete [Old_Owner_Name]._jou_Forum_UserThreadsDelete


-something clever or funny.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade 4.9.5 to 5.1.2 Error - Script & Package FileUpgrade 4.9.5 to 5.1.2 Error - Script & Package File


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:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out