因?yàn)槌鲥e(cuò)代碼比較長(zhǎng)，就放在后面了。

出現(xiàn)"The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist."報(bào)錯(cuò)的情況很多

只要是安裝過(guò)程中出現(xiàn)異常終止，然后我們又試圖訪問(wèn)沒(méi)有安裝好的網(wǎng)站（因?yàn)槭茄b了一半終止的，所以DNN不會(huì)再觸發(fā)安裝的過(guò)程）；
或者其它的設(shè)置導(dǎo)致DNN不能正常運(yùn)行就有可能出現(xiàn)這個(gè)報(bào)錯(cuò)。

所以我們不要嘗試去還原dbo.GetPortalAliasByPortalID，而應(yīng)該去排查那個(gè)地方引起這個(gè)報(bào)錯(cuò)。比如：連接字符串是不是設(shè)置正確， Startkit的安裝是不是選擇了"Auto"模式，SQL 是不是正常啟動(dòng)，等等。

Server Error in '/DotNetNuke4.8.2' 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:


               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:

              [InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
              

              

            System.Data.SqlClient.SqlCommand.DeriveParameters() +2973
              

              

            System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +72
              

              

            Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +213
              

              

            Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +304
              

              

            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) +3346
              

              

            DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +1193
              

              

            System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138
              

              

            System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65

DNN安裝報(bào)錯(cuò)-The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.如何解決

更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索：z360901061

微信掃一掃加我為好友

QQ號(hào)聯(lián)系： 360901061

您的支持是博主寫(xiě)作最大的動(dòng)力，如果您喜歡我的文章，感覺(jué)我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。

【本文對(duì)您有幫助就好】元

2元

5元

10元

20元

自定義

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Server Error in '/DotNetNuke4.8.2' Application.

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