Setup error : SQL2008, DiscountASP.NET

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/10/2009 9:23:43 AM

me.yahoo.comahbDk

Total Posts 4

View Posts

Setup error : SQL2008, DiscountASP.NET

Hi Guys,

Im getting this error when setting up mojoportal at DiscountAsp.net Please help. I've been stuck for a day already.

DB : SQL2008

Mojoportal Version : 2.2.9.6

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.0312508
An Error Occurred:Could not find stored procedure 'mp_SchemaVersion_SelectOne'.
Source:.Net SqlClient Data Provider
Stack Trace at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at mojoPortal.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at mojoPortal.Data.SqlParameterHelper.ExecuteReader() at mojoPortal.Data.DBPortal.SchemaVersionGetSchemaVersion(Guid applicationId) at mojoPortal.Data.DBPortal.SchemaVersionExists(Guid applicationId) at mojoPortal.Business.DatabaseHelper.UpdateSchemaVersion(Guid applicationId, String applicationName, Int32 major, Int32 minor, Int32 build, Int32 revision) at mojoPortal.Web.UI.Pages.SetupHome.RunSetupScript(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.CreateInitialSchema(String applicationName) 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/10/2009 9:48:08 AM

Joe Audette

Total Posts 18439

View Posts

Re: Setup error : SQL2008, DiscountASP.NET

Hi,

That is very strange, I have not seen this error before. I would re upload the file:
/Setup/applications/mojoportal-core/SchemaInstallScripts/mssql/2.2.7.8.config

if that file is missing it may try to run this one instead and it could cause that error:
/Setup.applications/mojoportal-core/SchemUpgradeScripts/mssql/2.2.7.8.config

Hope it helps,

Joe

4/12/2009 11:53:10 PM

me.yahoo.comahbDk

Total Posts 4

View Posts

Re: Setup error : SQL2008, DiscountASP.NET

Hi Joe,

Thanks for your reply! I re-uploaded my entire Setup folder and I didn't encounter the errror anymore. :)

However, the home page is just showing up as plain HTML, i mean like this (http://www.mediafire.com/file/4j1twoyjygx/mojoportalPlain.png). There was no styling on the page. Am I missing more files? I've re-uploaded the folders many time already.

4/13/2009 4:48:07 AM

Joe Audette

Total Posts 18439

View Posts

Re: Setup error : SQL2008, DiscountASP.NET

Hi,

The setup process is "supposed to" copy the skins from the /Data/skins folder to /Data/Sites/[SiteID]/skins folder, but if it failed partway through it may cause this. I would manually copy the /Data/skins folder to /Data/Sites/1/skins, then touch your Web.config file to clear the cache.

Hope it helps,

Joe

4/20/2009 4:03:56 AM

me.yahoo.comahbDk

Total Posts 4

View Posts

Re: Setup error : SQL2008, DiscountASP.NET

Hi Joe,

I did just that and it worked! thanks!

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