Sign In  |  Register
 
 
DotNetNuke Support Forums
DotNetNuke_04.07.00_Source Installation Error
Last Post 15 Feb 2008 09:12 AM by eyitomi. 4 Replies.
Printer Friendly
Sort:
PrevPrevNextNext
Please Register to post a reply.
Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.
AuthorMessages
eyitomi
New Member
New Member
Send Private Message
Posts:42

--
15 Feb 2008 08:41 AM  

Hi James,

  Any thought on why I am getting this error message when trying to install DNN:

 

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:

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.

Stack Trace:

<pre>[InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +883612
   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&amp; completedSynchronously) +64</pre>

SnapsisHost
Basic Member
Basic Member
Send Private Message
Posts:239
Avatar

--
15 Feb 2008 08:50 AM  
That error usually means that you are not connecting to the DNN database.
If you are connecting then it means the DNN database has only been partially initialized. Look in the DB and you may find that there is only a version table, if that is the case then you need to drop the version table or just start completely over with the install.
eyitomi
New Member
New Member
Send Private Message
Posts:42

--
15 Feb 2008 08:58 AM  

Thanks a lot for your prompt response. I have tried doing a reinstall twice and I still got the same error message. What do you reckon I do?

John Mitchell
Administrator
Veteran Member
Veteran Member
Send Private Message
Posts:4350
Avatar

--
15 Feb 2008 09:06 AM  
Check closely that you have the correct connection string in your web.config file.
eyitomi
New Member
New Member
Send Private Message
Posts:42

--
15 Feb 2008 09:12 AM  

Thanks, I found what it was. As you said in the config file, i set autoupgrade equals false.

Please Register to post a reply.
Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.


Active Forums 4.1
Visit our Store for great DotNetNuke Modules and Skins
DotNetNuke CSS Menu 3.4.6 (single use)

Item codeCSSNM33SU
AuthorJohn Mitchell
Base Price$39.00
Product Information 
DotNetNuke CSS NavMenu 3.4.6 (Developers)

Item codeCSSNM33DEV
Base Price$149.00
Product Information 
DotNetNuke Performance Caching & Compression - PageBlaster 3.4.5 - Professional Edition

AuthorJohn Mitchell
Base Price$59.00
Product Information