Upgrade question

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/4/2006 4:36:11 AM
Gravatar
Total Posts 26
Microsoft MVP in C#

Upgrade question

I'm looking to upgrade my current installation of mojoPortal.  Looking over some of the DB scripts, I see a pretty big discrepancy between the version I have, and what is in 2.1.3.  I don't know exactly what version my database is, so am a bit sure of which of the update scripts I need to apply.  I know that my DB schema is 2.something.  Any tips/suggestions to help me figure out which of the upgrade scripts I need?

Thx.
10/4/2006 4:45:06 AM
Gravatar
Total Posts 18444

Re: Upgrade question

Hi Tom,

Yeah I've been thinking about that and plan to add a version table to a future release and possibly try to implement automatic upgrades soon after that.

Since you know you have 2. something, then take a look in  the 2-0 to 2-1 upgrade script and see if your db already has the columns that are beinng added in that script. If not then run that script.

There are no upgrade scripts to run after that since no schema changes since 2.1, just use the latest stored procedure script and it will upgrade your stored procedures (only applies to MS SQL and PostgreSQL since the others have no stored procs)

If you are working with the source you may also see the script upgrade...tonext.sql, don't run that one as it is work in progress for a future release.

Hope it helps,

Joe
10/4/2006 4:46:16 AM
Gravatar
Total Posts 18444

Re: Upgrade question

Oh and don't forget to backup your site and db first in case anything goes wrong.

Joe
10/4/2006 5:07:12 AM
Gravatar
Total Posts 26
Microsoft MVP in C#

Re: Upgrade question

Thanks for the quick reply.  I'll give it a kick, see what happens, and let you know. 

FWIW, in a couple of applications I've worked on I've added a table, named something like DbChangeLog with the following columns (MS SQL flavoured)

ChangeId     Guid
DbVersion     NVARCHAR(100)
ScriptFileName NVARCHAR(1000)
Description   NVARCHAR(4000)
DateApplied  DATETIME

Then in the application I have some code which checks the version # of the database and warns if the database version seems to be incompatible.
You must sign in to post in the forums. This thread is closed to new posts.