Installation error.

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.
5/23/2008 5:47:14 PM
finn1309
Gravatar
Total Posts 3
View Posts

Installation error.

Hey,

I get this error on install:

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 needs upgrade.
0 site(s) found.
Running script mojoportal-core - 2.2.1.9 - 00:00:01.6093750
System.Data.SqlClient.SqlException: Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Inetpub\wwwroot\MojoPortal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in C:\Inetpub\wwwroot\MojoPortal\mojoPortal.Data.MSSQL\dbPortal.cs:line 568 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in C:\Inetpub\wwwroot\MojoPortal\mojoPortal.Data.MSSQL\dbPortal.cs:line 504 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in C:\Inetpub\wwwroot\MojoPortal\mojoPortal.Business\DatabaseHelper.cs:line 313 - 00:00:01.7187500
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.
 

Any help is appriciated, /Finn.

5/24/2008 6:25:42 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Installation error.

Hi Finn,

This is an upgrade right? Not a new installation. A new installation should start at 2.2.4.8 script.

If this is an upgrade what I would do is try copying the script ~/Setup/applications/mojopprtal-core/SchemaUpgradeScripts/mssql/2.2.1.9.config into query analyzer and run it from there. You will see parts of the script are renaming some columns. If those are the parts casuing the error then just manually change the column nnames and drop those parts out of the script. f you get through that script in Query Analyzer, then update the version in MP_SchemaVersion to 2.2.1.9, then you can revisit the setup page and maybe none of the other scripts will have problems.

Sorry for the difficulty, that script did work for me in testing.

If this is a SQL server you have control over, I would  make sure its up to date on all service packs.

Best,

Joe

5/24/2008 9:13:47 AM
finn1309
Gravatar
Total Posts 3
View Posts

Re: Installation error.

Hey Joe,

Thanks for yout reply. This is a new installation, but I did some F5's because there where some error's and I endded up with this error! I'll look into your solution and get back to you later.

My installation is for curiosity purpose only and is on localhost with full control over sqlserver2005.

 

/Finn.

5/24/2008 9:23:45 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Installation error.

Hi Finn,

If its a new installation I would disregard my previous advice and try starting again from a new clean db and also delete the current log file Data/currentlog.config so you will only see new errors.

It should not run the 2.2.1.9 script, it should start with 2.2.4.8 on a clean install. The first script, 2.2.4.8.config is located in /Setup/applications/mojoportal-core/SchemaInstallScripts/mssql (it should be the only script there) , after running that script it should start running scripts from /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql and it should start with 2.2.4.9.config in that folder and proceed up through the newest version.

Hope it helps,

Joe

5/24/2008 4:49:19 PM
finn1309
Gravatar
Total Posts 3
View Posts

Re: Installation error.

Hello Joe,

Thanks for the advice. This time it was succes! Looking forward to explore the features and will get back to you with more questions/credits.

 

/Finn.

6/12/2008 2:07:16 PM
bob
Gravatar
Total Posts 126
View Posts
YAF developer

Re: Installation error.

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 needs upgrade.
0 site(s) found.
Running script mojoportal-core - 2.2.1.5 - 00:00:13.2500000

An Error Occurred:The stored procedure 'mp_SchemaVersion_SelectOne' 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.SqlHelperParameterCache.DiscoverSPParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLHelper.cs:line 2513 at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLHelper.cs:line 2685 at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLHelper.cs:line 2629 at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLHelper.cs:line 2609 at mojoPortal.Data.SqlParameterHelper.InitializeArray() in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:line 63 at mojoPortal.Data.SqlParameterHelper.BeginDefineSqlParameters() in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:line 51 at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:line 86 at mojoPortal.Data.SqlParameterHelper..ctor(String connectionString, String commandText, Int32 paramCnt) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:line 43 at mojoPortal.Data.DBPortal.SchemaVersionGetSchemaVersion(Guid applicationId) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\dbPortal.cs:line 165 at mojoPortal.Data.DBPortal.SchemaVersionExists(Guid applicationId) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Data.MSSQL\dbPortal.cs:line 151 at mojoPortal.Business.DatabaseHelper.UpdateSchemaVersion(Guid applicationId, String applicationName, Int32 major, Int32 minor, Int32 build, Int32 revision) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\mojoPortal.Business\DatabaseHelper.cs:line 128 at mojoPortal.Web.UI.Pages.SetupHome.RunScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\Web\Setup\Default.aspx.cs:line 412 at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\Web\Setup\Default.aspx.cs:line 312 at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\Web\Setup\Default.aspx.cs:line 147 at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\bob\My Documents\Visual Studio 2008\Projects\mojosvn\Web\Setup\Default.aspx.cs:line 91 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

But initial schema doesn't exists! Only a new db file created as usually by hand. 3840 SQL Express 2005.

6/12/2008 2:14:33 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Installation error.

Its checking for existence of mp_Sites table so it must exist. Maybe you got some partial installation and should delete everything and start over or maybe its not using the db you think it is using. Are you using a user.config file? That will trump Web.config but changes you make there won't be noticed until you touch Web.config because .NET is not monitoring user.config for changes.

Hope it helps,

Joe

6/13/2008 9:23:00 AM
bob
Gravatar
Total Posts 126
View Posts
YAF developer

Re: Installation error.

I shut down  MySQL server, changed SubSonic provider settings to it in Web.config and the problem disappeared.

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