new error in installtion

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

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

8/25/2008 3:43:41 AM

vsranjane

Total Posts 26

View Posts

new error in installtion

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:02.7656250
Running script mojoportal-core - 2.2.1.6 - 00:00:02.8281250
Running script mojoportal-core - 2.2.1.7 - 00:00:02.8437500
Running script mojoportal-core - 2.2.1.8 - 00:00:02.8437500
Running script mojoportal-core - 2.2.1.9 - 00:00:02.8593750
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 D:\mojoportal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in D:\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 568 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in D:\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 504 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in D:\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 313 - 00:00:03.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.

8/25/2008 11:55:09 AM

Joe Audette

Total Posts 18439

View Posts

Re: new error in installtion

Something very strange happened. It should not be running all those scripts unless you are upgrading a very old installation of mojoportal.

It should start with script 2.2.6.7

Make sure the file exists:
/Setup/applications/mojoortal-core/SchemaInstallScripts/mssql/2.2.6.7.config
there should be no other files in this folder.

I would delete all stored procedures and tables from the db and try setup again.

Hope it helps,

Joe

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