Upgrade database core schema

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.
3/26/2008 12:39:48 PM
Gravatar
Total Posts 48

Upgrade database core schema

hi there,

I've followed the upgrade instructions, however, when i run setup it says "database core schema needs upgrade". Can anybody point me in the right direction of how to update this. I'm working from the svn files. The "System information" section under admin settings reads as follows:

System Information
mojoPortal Version 2.2.5.1 MSSQL
Server Time Zone: GMT Standard Time
Server Local Time: 26/03/2008 17:33:18
Current Time in Greenwich (aka GMT or UTC): 26/03/2008 17:33:18
Server GMT Offset: 0
Preferred GMT Offset Web.config Setting:

The setup page reads as follows:

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.
This site appears to be running in a secured environment using Medium Trust policy or lower.

 


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.

Thanks in advance for any help

3/26/2008 12:45:09 PM
Gravatar
Total Posts 18439

Re: Upgrade database core schema

Hmm, that is strange. Is the site working ok besides the setup page saying that?

Are you sure you upploaded all the files with no errors? Sometimes I find it works better if you don't upload them all at once. Some of the big folders I ususally upload o0ne at a time, like the Setup , ClientScript, Data folders.

I would have a look in the mp_SchemaVersion table and see what versions are reported there.

I would also look in the mp_SchemaScriptHistory table and see if any of the scripts logged errors.

Hope it helps,

Joe

3/26/2008 1:08:31 PM
Gravatar
Total Posts 48

Re: Upgrade database core schema

Hi Joe,

Yeah the site seems to running ok, I haven't come across any errors since uploading the new version.

I've checked to 2 tables that you suggested and they contain the following info:

mp_SchemaVersion:

ApplicationName   Major Minor Build Revision
mojoportal-core    2      2      4      8

mp_SchemaScriptHistory:

ScriptFile          RunTime                     ErrorOccurred     ErrorMessage     ScriptBody
2.2.4.8.config    11/03/2008 02:33:24    False 

I've uploaded the files again and there seems to be no errors when uploading. Any ideas?

Thanks, reiss

 

 

3/26/2008 1:18:40 PM
Gravatar
Total Posts 18439

Re: Upgrade database core schema

It doesn't look like it has been able to run the upgrade scripts. Can you verify the upgrade scripts are on the server under webroot/Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql

you should see incremental scripts up to 2.2.5.2.config

If the files exist check the permissions on them.

In worst case you can run them manually then set your version to 2.2.5.2 in mp_SchemaVersion

Hope it helps,

Joe

3/26/2008 1:19:45 PM
Gravatar
Total Posts 18439

Re: Upgrade database core schema

er, I meant up to 2.2.5.1.config

3/26/2008 1:42:01 PM
Gravatar
Total Posts 48

Re: Upgrade database core schema

Hi Joe,

Don't know what had happened, the files were there but i hadn't noticed their size was 0kb. Uploaded the files again, ran setup, and everything is now showing up to date.

Thanks again for the help,

Reiss

3/26/2008 1:46:26 PM
Gravatar
Total Posts 48

Re: Upgrade database core schema

Also just noticed.... I'm using firefox and when i'm adding a smilie to my forum posts it isn't displaying once the post has been submitted. Just thought i'd let you know.

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