You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > Everything Else
Subject: Restoring Database error:
Prev Next
You are not authorized to post a reply.

Author Messages
anandprak
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:5
26 Feb 2008 8:12 AM  

In my pc(m/c 1), local DNN(4.7) website which is working perfectly.I just locally hosted my website in another machine(2nd m/c) in which DNN(4.7) is already installed in it(viz.Copy all my dnn file folders except app data in 2nd m/c and taking the back up of db in 1st  m/c and restoring it in db of 2nd m/c  and modyfying web.config in 2nd m/c to access local db.when i run default.aspx, i get following error.But before restoring my db files in 1st m/c to my znd m/c,default.aspx was running perfectly in my 2nd m/c.Anyone who knows solution or sugestion, pls reply.


Server Error in '/DNN' Application.

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

Source Error: 

<span style="font-size: 10pt; color: black;">An
  unhandled exception was generated during the execution of the current web
  request. Information regarding the origin and location of the exception can
  be identified using the exception stack trace below.</span>


Stack Trace: 

 
[InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +878696
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetPortalAliasByPortalID(Int32 PortalID) +87
   DotNetNuke.Entities.Portals.PortalAliasController.GetPortalAliasByPortalID(Int32 PortalID) +35
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasLookup() +74
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasInfo(String PortalAlias) +14
   DotNetNuke.HttpModules.UrlRewriteModule.RewriteUrl(HttpApplication app) +3527
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +826
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

 

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
26 Feb 2008 8:37 AM  
Why did you not copy app_code?
Did you change portalalias in the moved database?
Joe Craig
DNN Creative Support
Subscribe to the website
anandprak
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:5
26 Feb 2008 11:53 PM  
I have copied the app_code as well.

No.I have not changed the portal alias in moved database.Can u please explain how to change portal alias in
moved database.
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
27 Feb 2008 8:12 AM  
My recommendation is that you reveiw

To edit portalalias, you'll need SQL Server Management Studio Express (or the complete version).  Open your database, then open the portalalias table.  You can then edit it manually.
Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > Restoring Database error:


ActiveForums 3.7

Latest Forum Posts

RE: Restart Application by leesykes
It will restart your DotNetNuke installation and reload the application.Clearing cache will clear th...
RE: How can i edit any module from front end by leesykes
hello,I have just tested this and can see exactly the same as you, I suspect the core team have set ...
RE: EasyCGI help? by leesykes
You may want to ask them to reset the correct permissions on your DotNetNuke installation files, som...
RE: quick question by leesykes
Hello,It will be possible to a degree, but it depends on how both of the skins have been built. You ...
RE: EasyCGI help? by Dr Joe
I'll let you know how it works out. I think I opened up about 6 tickets with them so far. ...
RE: EasyCGI help? by derpir
Hi Joe amazing to say the least! I will change host to PowerDNN as soon as possible, seems to me t...
RE: EasyCGI help? by Dr Joe
Amazing - I'm going through this exact same thing with EasyCGI! I managed to successfully instal...
Running the local host installation after building the application by saintX
My localhost installation of DNN was running blameless. After I oppened the application with VWD it ...
RE: quick question by derpir
Hello Is it possible to buy two skins and combine them? for example put one skins visual attributes...
RE: Environment Variables by leesykes
Thanks for the info,
RE: How can i edit any module from front end by sanju_k1421
ok if i added an text html . now i want to fill into that have to log in ,but i want that an...
Module not working when logged off. by t.ramya85
Hi friends,I have created two modules which interact with each other and i have kept one module to b...
RE: Environment Variables by fandnet
There are many ways to use variables like what I was trying to use...But here is how I did it.DotNet...
RE: OpenForce '08 by mgordon
It was truly a great time.  I really feel this year was much better than last year.  I hope to ge th...
Environment Variables by fandnet
I am creating a simple module that registered users can use to send an email invitation to people wh...
RE: How can i edit any module from front end by leesykes
I'm not sure that I follow, could you provide an example?
RE: Development of modules by leesykes
Hello,Glad you find them useful, at the moment there are not any plans to go into Module Development...
RE: SQL Server 2008 Documents Module DotNetNuke by leesykes
Hello,Thanks for the tip. Yes both connection strings are in correctly and the user has full permiss...
RE: Now, portal creation problem by jncraig
Since you have other issues with installing modules, etc. I believe that you are correct that it's a...
RE: How do I display the current time by jncraig
The [CURRENTDATE] skin object has a DateFormat attribute. The examples give MMMM dd, yyyy as a typi...
DotNetNuke Modules
RSS Feeds