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

Mohsen

Total Posts 26

View Posts

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

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

I am Waiting To answer...

10/13/2012 5:14:55 AM

Asad Samarian

Total Posts 550

View Posts

Buy Asad a cup of coffee

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

Joe Audette

Total Posts 18439

View Posts

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

Mohsen

Total Posts 26

View Posts

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

Joe Audette

Total Posts 18439

View Posts

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

Mohsen

Total Posts 26

View Posts

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

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

ok schemaversion of mojoportal core is 2.2.1.8

10/13/2012 8:43:19 AM

Joe Audette

Total Posts 18439

View Posts

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

Mohsen

Total Posts 26

View Posts

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?

10/13/2012 8:53:47 AM

Mohsen

Total Posts 26

View Posts

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

10/13/2012 9:13:50 AM

Joe Audette

Total Posts 18439

View Posts

Re: upgrade errorrrrrrrrrrrrr

please tell me what all the other rows in mp_SchemaVersion have?

also do ALL of the tables have the dbo prefix or not?

On this site to be logged in the url must start with https, cookies are not passed in the headers unless it is a secure request therefore you appear to be not legged in if you use an url with only http

10/14/2012 2:32:03 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

HI joe thanks

yes all tabales have dbo.prefix

and other rows

blog 0.0.1.9

gallery 0.0.0.7

link module 0.0.0.7

forum 0.0.1.7

contact form 0.0.0.5

poll 0.0.05

webstore 6.9

evetcalender 0.5

my site is down and my rank and seo is decreasing

thanks

mohsen

10/14/2012 6:57:27 AM

Joe Audette

Total Posts 18439

View Posts

Re: upgrade errorrrrrrrrrrrrr

I'm sorry your site is down but that is not my responsibility. You should backup your entire site and database before upgrading, especially before upgrading from a 5 year old version. That way you can restore the site as it was if something goes wrong.

Here is what I would do if I were you.

1. Make sure you are using MS SQL 2005 or higher, we dropped supprt for SQL 2000 after mojoPortal version 2.3.4.5

2. Try to run this script manually from SQL Query analyzer

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

If it still gives errors then chop out tha perts that are trying to drop existing stored procs and drop the ones it is trying to drop manually, then see if it can run the rest of the script.

Once you get that script to run then update the mojoportal-core row in mp_SchemaVersion to 2.2.1.9 and try to use the setup page to run the rest of the upgrade scripts.

Hope that helps,

Joe

10/14/2012 7:11:26 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

thank you joeeeeeeeeee

joe my sites down is not from your side i am sorry to you for your spend time to me

i have backup and i installed mojo 2.3.9 in this server for new site and is ok is not from server

i will try it to manualy like you sey and tell you result

thanks to your kindly replys

10/14/2012 8:50:49 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

HELLO AGAIN Joe

i restored my database and files from my backup and i see wizard thing at sites admin mojoveriosn is 2.3.5.4 and i can not view that for right to left issue problem for persian translation and i now i most change schema veriosn of mojoportal core to 2.3.5.4 to wirk right? but at schema table was 2.2.1.8 at here can i use update at subdomain or other domain for test for update i have fear for new errors if i want change core verion manualy most change other config for changing of domain or no? thanks

with very thanks before

mohsen

10/14/2012 10:07:59 AM

Joe Audette

Total Posts 18439

View Posts

Re: upgrade errorrrrrrrrrrrrr

I'm sorry but what you are telling me makes no sense at all.

If you were upgrading from 2.3.5.4 it would already have 2.3.5.4 for mojoportal-core in the mp_SchemaVersion table

This is why I suspect you have been leaving out information or giving me false answer to the questions I've asked you. You are either not correctly restoring the database or doing something to make the database in a strange state that makes these errors happen when trying to upgrade.

If the site was really at version 2.3.5.4 and the database user is dbo and the tables and procedures all have the dbo prefix, then the mp_SchemaVersion table would already have mojoportal-core as version 2.3.5.4 and the setup page would start upgrading with script version 2.3.5.6 not with script 2.2.1.9

If you site was really at version 2.2.1.8 then it would still need to run the same upgrade scripts to upgrade to version 2.3.5.4.

you should not manually change the version in the database unless you manually are able to run the script from query analyzer with no errors, if you run the script manually then you must update the version of mojoportal-core in mp_SchemaVersion to match the script version

You are either leaving out information about what you did to the database (ie if you restored it how you restored it) or you are not giving truthfull answers to the questions I asked you in trying to figure out what is wrong in your database. I cannot help to solve the problem without complete and accurate information.

You also have not mentioned what version of SQL Server you are using. At minimum it must be SQL 2005 with all the service paks installed or higher.

10/16/2012 3:05:22 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

HI JOE

i am very sorry to i cannot resolve this with your kindly helps

my sql is 2005 workgroup with latest updates and servis paks and all tabels have .dbo prefix

at mojoportal core at mp_schemaversion table is 2.2.1.8

but at mojo admin panel(system information) shows mojoprtla version 2.3.5.4

and i tested (at backup recovered to new database at other domain for test )at sql manager manualy. query of 2.2.1.9 was not worked and want error

but i manualy changed mojoportal core mp_schemaversion manualy to 2.3.5.4 and quserys of 2.3.5.5 and next releases changed database successfully

i think my portal is at version 2.3..5.4 but mp_schemaversion is not update my for some error at last update?

i copyed 2.3.5.5 to Setup\applications\mojoportal-core\SchemaUpgradeScripts\mssql then i run setup but after setup shows mojoportal is updated to 2.3.5.4

now i most? try to upgrade with copy and replace all files of mojoportal 2.3.9.3 to root then change mojoportal-core schemaversion manualy to 2.3.5.4 then run setup like your setup help or most change version of other modules to?

for test i recovered database and files from backup at other domain but for run redirected to my source domain?

thanks

mohsen

10/16/2012 6:35:00 AM

Joe Audette

Total Posts 18439

View Posts

Re: upgrade errorrrrrrrrrrrrr

at mojoportal core at mp_schemaversion table is 2.2.1.8

but at mojo admin panel(system information) shows mojoprtla version 2.3.5.4

That does not make sense, the grid in the system information page that shows the versions is populated from the mp_SchemaVersion table so it cannot show something different than what the table shows.

Maybe you are looking in the wrong database

I don't have any further suggestions since your system is in a state that is unknown to me

10/16/2012 9:14:00 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

HI Joe and thanks to your good helps

i changed mojoportal-core mp_shemaversion from 2.2.1.8 to 2.3.5.4 manualy and step by step tryed to upgrade and now ugraded to 2.3.9.3

my think was right and schema version wasnot updated at my last update

now that is fine

thanks

have a nice life joe

mohsen

10/16/2012 9:20:03 AM

Joe Audette

Total Posts 18439

View Posts

Re: upgrade errorrrrrrrrrrrrr

I'm glad you were able to resolve the problem.

Best,

Joe

10/16/2012 9:23:23 AM

Mohsen

Total Posts 26

View Posts

Re: upgrade errorrrrrrrrrrrrr

Thanks

with your perfect help

thanks

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