Intermittent "Welcome to Mojoportal Setup"

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
11/12/2013 7:34:38 PM
Gravatar
Total Posts 5

Intermittent "Welcome to Mojoportal Setup"

I've recently been getting the screen below intermittently, when attempting to add New Pages or edit html content on any of the sites on my server (which is as follows):

mojoPortal Version 2.3.9.7 MSSQL  (2008)
Operating System Microsoft Windows NT 6.1.7601 Service Pack 1  (Win2008 Server)
ASP.NET Info v4.0.30319 Running in Full Trust
Server Time Zone Eastern Standard Time
Server Local Time (GMT -5) 11/12/2013 7:47:33 PM
Greenwich Mean Time (GMT/UTC) 11/13/2013 12:47:33 AM

Its been working ok, but somehow this problem has just appeared.  Sometimes the New Pages will appear or the edit content will take but more often than not I get the following,  please advise:

UPDATE:    This problem seems to only appear when updating content through my Satellite ISP (high latency/weather issues).  If I remote desktop to the server and sign into Mojoportal in IE, New Pages and edit contents work ok.  No problems either with using remote desktop to a computer/browser with Mojoportal connected with a cable ISP.

Welcome to mojoPortal Setup

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.
10 site(s) found.
Running script mojoportal-core - 2.2.1.9 - 00:00:00.1035090
System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, 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) ClientConnectionId:93d72f22-37ad-4870-84ef-9526b20b069d - 00:00:00.1552635
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.

11/14/2013 10:00:23 AM
Gravatar
Total Posts 18439

Re: Intermittent "Welcome to Mojoportal Setup"

something is not right in your database if it is trying to run the script version 2.2.1.9

make sure in the mp_SchemaVersion table the row for mojoportal-core has version 2.3.9.7

if an unhandled error happens it checks that table to determine if it needs to run upgrade scripts and if it does it redirects to the setup page.

it should never run any script older than the current version

11/14/2013 10:31:08 AM
Gravatar
Total Posts 5

Re: Intermittent "Welcome to Mojoportal Setup"

thanks for the response.  In the table is says mojoportal-core is 2.2.1.8.  What is the best way to fix this problem?

11/14/2013 10:37:05 AM
Gravatar
Total Posts 18439

Re: Intermittent "Welcome to Mojoportal Setup"

correct the data to 2.3.9.7

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