install precompiled version

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
4/12/2014 11:45:38 PM
Gravatar
Total Posts 20

install precompiled version

http://downloadmaghale.ir/Setup/Default.aspx

Welcome to mojoPortal Setup

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema is up to date.
37 site(s) found.
Configuring feature Html Content - 00:00:00.0312528
Configuring feature Site Statistics - 00:00:00.0625032
Configuring feature Child Page Site Map - 00:00:00.0625032
Configuring feature Newsletter Sign Up Form - 00:00:00.0781269
Configuring feature Recent Content - 00:00:00.1093788
Configuring feature Sign In Module - 00:00:00.1250073
Configuring feature Site Search - 00:00:00.1250073
Configuring feature Bing Map - 00:00:00.1250073
Configuring feature Blog - 00:00:00.1406325
Configuring feature Comments - 00:00:00.2187595
Configuring feature Contact Form - 00:00:00.2187595
Configuring feature Event Calendar - 00:00:00.3281440
Configuring feature Feed Manager - 00:00:00.5156531
Configuring feature Flickr Slide Show - 00:00:00.6250304
Configuring feature Flickr Gallery - 00:00:00.6250304
Configuring feature Image Gallery (Simple Folder Version) - 00:00:00.7187874
Configuring feature Forums - 00:00:00.7969173
Configuring feature Google Map - 00:00:00.8437911
Configuring feature Google Translate - 00:00:00.8594175
Configuring feature Html Fragment Include - 00:00:00.8594175
Configuring feature IFrame - 00:00:00.8750433
Configuring feature Image Gallery - 00:00:00.8750433
Configuring feature Audio Player - 00:00:00.8906688
Configuring feature Video Player - 00:00:00.9062946
Configuring feature List/Links - 00:00:00.9375487
Configuring feature Poll - 00:00:00.9375487
Configuring feature Shared Files - 00:00:00.9531751
Configuring feature Survey - 00:00:00.9531751
Configuring feature Web Store - 00:00:00.9688009
Configuring feature Xml/Xsl - 00:00:00.9844261
Ensuring all features are installed in server admin sites... - 00:00:00.9844261
An Error Occurred:The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.
Source:System.Data
Stack Trace at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName) at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName) at mojoPortal.Data.SqlParameterHelper.InitializeArray() at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt) at mojoPortal.Data.DBSiteSettings.GetSiteIdByHostName(String hostName) at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache() at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext() at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint

4/14/2014 8:46:20 AM
Gravatar
Total Posts 18444

Re: install precompiled version

According to the error you are missing this stored procedure:

CREATE PROCEDURE [dbo].[mp_SiteHosts_SelectSiteIdByHost]

/*
Author:               Joe Audette
Created:             2011-08-24
Last Modified:         2011-11-25

*/

@HostName nvarchar(255)

AS


SELECT COALESCE(    
    (SELECT TOP 1 SiteID
        FROM [dbo].mp_SiteHosts 
        WHERE HostName = @HostName),
                 
        (SELECT TOP 1 SiteID FROM [dbo].mp_Sites ORDER BY SiteID)
            )

 


GO

4/15/2014 2:24:55 AM
Gravatar
Total Posts 20

Re: install precompiled version

nsuring all features are installed in server admin sites... - 00:00:01.4531970
An Error Occurred:The stored procedure 'mp_Pages_CountBySite' doesn't exist.
Source:System.Data
Stack Trace at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName) at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName) at mojoPortal.Data.SqlParameterHelper.InitializeArray() at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt) at mojoPortal.Data.DBPageSettings.GetCount(Int32 siteId, Boolean includePending) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 

4/15/2014 7:25:03 AM
Gravatar
Total Posts 18444

Re: install precompiled version

CREATE PROCEDURE [dbo].[mp_Pages_CountBySite]

/*
Author:               Joe Audette
Created:             2011-02-06
Last Modified:         2011-02-06
*/

@SiteID            int,
@IncludePending bit

As

Select    Count(*)
From    [dbo].mp_Pages
Where    
    SiteID = @SiteID
    AND ((IsPending = 0) OR (@IncludePending = 1))

 

GO

 

You must sign in to post in the forums. This thread is closed to new posts.