Hello There,

I  me new to mojoProtal.

I get the massage when I try to edit the content for Page home.

Please help me to solve it .

[mojoPortal Content Management System]

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.2187500
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.2187500
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. 

Thank you for your prompt replay for my post.

It took me long time to respond to your request because I couldn't access the database on the webserver since I  have restricted privilege.

Now I could but the mp_SchemaVersion table is empty and the mp_SchemaVersionHistory table doesn't exist in list of tables of the database.

Thank you again for your help.

Thank you very much

I will do as your advise if I encounter any problem I will contact you.

By the way the mp_SchemaScriptHistory table is also empty.

Thank again,

All the best,
 
Haria