Hi, collegues.

OS: Win Server (hosting)

DB: MSSQLServer2005

Version mojo: "mojoportal-2-3-5-1-mssql-net35-deploymentfiles"

There is (already was) a site with the latest version mojo under ASP.NET 2.0.
Created:
1 On the hosting included support ASP.NET 3.5
2. I uploaded the latest version mojo
3. Launched /Setup/Default.aspx

The result:

MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.2.8.0 - 00:00:00.7968750
Running script mojoportal-core - 2.2.8.1 - 00:00:00.8750000
Running script mojoportal-core - 2.2.8.2 - 00:00:00.8750000
System.Data.SqlClient.SqlException: Invalid column name 'SiteId'. 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) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.9062500
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.

I remember that before I encountered this error. And I corrected it by changing the script in the "Id" to "ID". I do not know why sqlserver not like it.
You can do this in all scripts?
If necessary, I can write about all these errors as corrected.

Running script feed-manager - 0.0.0.5 - 00:00:01.6406250
System.Data.SqlClient.SqlException: Invalid column name 'FeedID'.

I don't know what I must change.

Running script surveyfeature - 0.0.1.4 - 00:00:02.3750000
System.Data.SqlClient.SqlException: Invalid column name 'ModuleId'.

ModuleID

Thanx.

How about that:

Running script feed-manager - 0.0.0.5 - 00:00:01.6406250
System.Data.SqlClient.SqlException: Invalid column name 'FeedID'.

I don't know what I must change.

 

Oh! Did not properly read the name in the database :)

In DB: FeedId

In file: FeedID

I changed and all OK now. Thanx. :)