Update new data onto website

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
10/11/2012 3:50:04 AM
Gravatar
Total Posts 2

Update new data onto website

Welcome to mojoPortal Setup

Setup is disabled but running setup anyway because current user is an administrator.
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.
1 site(s) found.
Running script mojoportal-core - 2.3.7.7 - 00:00:00.3906250
System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'RolesChanged' in table 'dbo.mp_Users' is specified more than once. 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() 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, 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) - 00:00:00.3906250
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.

10/11/2012 9:02:55 PM
Gravatar
Total Posts 3
Scott Shepherd

Re: Update new data onto website

What version is currently running on your system that is trying to upgrade from and to what version are you trying to upgrade?

10/12/2012 8:49:35 AM
Gravatar
Total Posts 18439

Re: Update new data onto website

I suspect that somewhere along the way you manually ran some upgrade scripts and it did not record them so it is trying to run the script again.

You could try removing the script it is erroring on and see if it can run the next one, ie remove the file

/Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql/2.3.7.7.config

or comment out the part of the script that is adding the "RolesChanged" column to mp_Users table

10/17/2012 12:38:10 AM
Gravatar
Total Posts 2

Re: Update new data onto website

Thank  you.

The version of mssql 2005. I am not trying to upgrade mssql. I have tried to upload data on my website.

Best regards.

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