I am trying to install mojoPortal on Windows 2003/MSSQL 2005. I have created the folder and copied the files over. I ran the 3 sql scripts from the download and setup my web.config. But when I launch the site for install it says mp_SiteFolder_Exists cannot be found.

Hey -

Clean install (I think).  I had installed an older version for MySQL, but removed it and deleted the database tables and sprocs, never ran setup on it.  I then installed 2.2.3.3b for MS-SQL.  And that's where I am.

UseFoldersInsteadOfHostnamesForMultipleSites was already set false; so I tried true with no difference.

The URL in question is www.onegenerationtoanother.com/mojoportal/Setup.aspx. 

Thanks in advance.

-----------------------------

Hi Tim,

Is this a clean install or upgrade? What version of mojoportal? What db?
What is the full url, "www.../mojoportal/Setup/Default.aspx" doesn't tell me how deep the folder is.

Try setting UseFoldersInsteadOfHostnamesForMultipleSites to false in Web.config

If you have further difficulty please post in the forums instead of email. That way anyone encountering the same problem can benefit and I don't have to answer the same issues more than once.

Hope it helps,

Joe

On 8/10/07, Tim Wise <tjwise@mail.com> wrote:
>
> Joe -
>
> I'm getting "The stored procedure 'mp_SiteFolder_Exists' doesn't exist." error when I do www.../mojoportal/Setup/Default.aspx. I've done your trick of modifying web.config to get it to rerun, but to no avail (I actually did it about 8 times, just for luck). The full error follows.
>
> Any suggestions?
>
> Thanks in advance......
> Tim
>
>
>
> Server Error in '/MojoPortal' Application.
> ----------------------------------------------------------------------
> ----------
>
> The stored procedure 'mp_SiteFolder_Exists' 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 'mp_SiteFolder_Exists' 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 'mp_SiteFolder_Exists' doesn't exist.]
> System.Data.SqlClient.SqlCommand.DeriveParameters() +878648
> System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
> mojoPortal.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +83
> mojoPortal.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +124
> mojoPortal.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +96
> mojoPortal.Data.dbPortal.SiteFolder_Exists(String folderName) +147
> mojoPortal.Business.SiteFolder.Exists(String folderName) +5
> mojoPortal.Business.WebHelpers.VirtualFolderEvaluator.VirtualFolderName() +527
> mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app) +83
> mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e) +368
> 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.210
>
>

>>> are there any rows in mp_SchemaScriptHistory with errors? If so we need to resolve the errors and then delete those rows so the script can run again

>> Yes, four. mp_SchemaScriptHistory_SelectByApp doesn't exist. And, it doesn't exist in 2CreateTables.sql.

Things that make you say hmmmmm?  I cleared the records from mp_SchemaScriptHistory, changed web.config and reran Setup.  Same error, but no errors in mp_SchemaScriptHistory.

Later....