error upgrading fm 2.7.0.0 to 2.9.0.1

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.

3/10/2024 7:28:49 AM
Gravatar
Total Posts 12

error upgrading fm 2.7.0.0 to 2.9.0.1

 

I'm upgrading Mojoportal from 2.7.0.0 to 2.9.0.1

 

Verifica del sistema...
Privilegi del File system ok.
MSSQL connessione al database ok.
i privilegi per il database sono sufficienti per modificare lo schema.
lo schema database iniziale gia' esistente.
lo schema centrale del database necessita aggiornamento.
2 sito(i) trovati.
Esecuzione script mojoportal-core - 2.7.0.1 - 00:00:00.0670268
Esecuzione script mojoportal-core - 2.7.0.2 - 00:00:00.0890543
Esecuzione script mojoportal-core - 2.7.0.3 - 00:00:00.0980030
Esecuzione script mojoportal-core - 2.7.0.4 - 00:00:00.1110347
Esecuzione script mojoportal-core - 2.7.0.5 - 00:00:00.1400827
System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) ClientConnectionId:ddfaffdb-a462-49a2-b704-aefd2095daa3 Error Number:15248,State:1,Class:11 - 00:00:00.3580150
Nota: Questa pagina mostra alcune informazioni che sono utili durante l'installazione e gli aggiornamenti , ma per sicurezza sarebbe meglio non mostrare tutte le informazioni quando il sistema e' aggiornato. E' possibile disattivare la configurazione e sopprimere tutte le informazioni su questa pagina impostando DisableSetup = true in Web.config. Quando e' necessario eseguire l'aggiornamento, e' possibile impostare nuovamente questo valore a false. Se sei collegato come amministratore di installazione verra' eseguito e sarai in grado di vedere questa pagina, anche se e' disabilitato nel Web.config, in modo che tu possa facilmente lasciarlo disabilitato e fare il login appena prima di aggiornare. Ma se non si e' effettuato l'accesso e' necessario abilitarlo in WebConfig per consentire l'esecuzione.

 

any help would be much appreciated,

best regards

Roberto Castellano

3/10/2024 7:17:54 PM
Gravatar
Total Posts 2239

Re: error upgrading fm 2.7.0.0 to 2.9.0.1

Hi Roberto,

What version of SQL are you running?

Thanks,
Joe

3/11/2024 3:38:25 AM
Gravatar
Total Posts 12

Re: error upgrading fm 2.7.0.0 to 2.9.0.1

Hi Joe,

My MSSQL  version is 3.8.  

At current time I 've restored the site  with Mojo Portal 2.7 and I'm compelled to restore database backup to run it again.   

If there are no preclusions, I will try to update the site again later today or tomorrow.

best regards

Roberto