upgrade errorrrrrrrrrrrrr

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.

This thread is closed to new posts. You must sign in to post in the forums.
10/13/2012 1:00:04 AM
Gravatar
Total Posts 26

upgrade errorrrrrrrrrrrrr

HI JOE AND ALL

i want to upgrade my mojo site but it want error and i cannot find any article to resolve it i am copying error here please help me to resplve it

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.
2 site(s) found.
Running script mojoportal-core - 2.2.1.9 - 00:00:01.6875432
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) 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:01.9688004
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/13/2012 4:28:30 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

I am Waiting To answer...

1

2

3

10/13/2012 5:14:55 AM
Gravatar
Total Posts 550

Re: upgrade errorrrrrrrrrrrrr

Hi Mohsen,

Can you send me 2.2.1.9.config file to me(a dot samarian at gmail dot com) ? It exists in [yourdomain]/Setup/Applications/mojoportal-core/SchemaUpgradeScripts/mssql

Maybe I can help you.

 

 

10/13/2012 7:03:20 AM
Gravatar
Total Posts 18439

Re: upgrade errorrrrrrrrrrrrr

I think you are leaving out some information, ie possibly your have deployed your own modified build that you made from source code, possibly you have done something with the database like copy the objects to a new db instead of doing a real backup and restore. Possibly some database objects are missing or have incorrect permissions.

How the setup works:

1. It looks to see if the mp_Site table exists, if so it knows it is an upgrade not a new installation

2. It checks for the current version in mp_SchemaVersion table this info tells it which upgrade script to start with so that it only runs newer scripts. This is the step where it is going wrong so maybe the table is missing

Even on a new installation it should start with script version 2.3.4.8, not 2.2.1.9

It should never run script version 2.2.1.9 unless you are really upgrading from a version that is about 5 years old. So something is wrong about your database before it tries to upgrade. I would first look to see if the mp_SchemaVersion and mp_SchemaScriptHistory tables exist and what data is in them if they do exist.

10/13/2012 7:29:52 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

HI joeand assad thanks to your reply

thanks to your reply now i replaced all files to old files and now i am trying to use from my backup and i remeid at admin panel of my mojo was not shown verstion of that and it was a question to me

and i see database dbo.mp_SchemaScriptHistory and dbo.mp_Schemaversion is exist at database how i can resolve it or never i dont upgrade it

 

 

thanks mohsen

10/13/2012 7:56:22 AM
Gravatar
Total Posts 18439

Re: upgrade errorrrrrrrrrrrrr

What is the data in mp_SchemaVersion for the mojoportal-core row?

Are you sure the database user in your connection string is a dbo? (database owner) if not then the user does not see that table and it could cause this problem.

10/13/2012 8:14:05 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

HI AGAIN joe

databse username is database admin dba

and data in mojoprtal-core is : 077e4857-f583-488e-836e-34a4b04be855

?

thanks

10/13/2012 8:16:17 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

ok schemaversion of mojoportal core is 2.2.1.8

10/13/2012 8:43:19 AM
Gravatar
Total Posts 18439

Re: upgrade errorrrrrrrrrrrrr

Really??? This installation is 5 years old and has never been upgraded before?

Even on this old thread you were upgrading from 2.3.5.4

10/13/2012 8:50:06 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

hi again yes i cannot remember it my update was resolved or no but i now at admin panel i cannot see verion and it was empty now i want to upgrae and start new customization and custom modules  for traveling i see http://eranews.ir/ is good worked

thanks how i do to upgrade? Cry

10/13/2012 8:53:47 AM
Gravatar
Total Posts 26

Re: upgrade errorrrrrrrrrrrrr

joe a problem is at mojoportal.com i can not login to it with mobile after login redirected to home page without login and for forget password like that

 

 

thanks to your kindly replys

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