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

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