"Database core schema needs upgrade" on setup on MySQL

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.
8/26/2009 4:46:30 PM
Gravatar
Total Posts 5

"Database core schema needs upgrade" on setup on MySQL

I have problems deploying mojoPortal on an IIS7/MySQL Server 5.1.37.

Worked perfectly fine before - now I decided to make a fresh deploy, and suddenly I can't get past the installation script.

First thing happening is:

mojoPortal Content Management System Welcome to mojoPortal Setup

Probing system...

File system permissions ok.

MySQL database connection ok.

database permissions are sufficient to alter schema.

database initial schema needs to be created.

Running script mojoportal-core - 2.2.7.8 - 00:00:00.1240155

Running script mojoportal-core - 2.2.7.9 - 00:00:02.1082635

Running script mojoportal-core - 2.2.8.0 - 00:00:02.1473235

Running script mojoportal-core - 2.2.8.1 - 00:00:02.1639240

Running script mojoportal-core - 2.2.8.2 - 00:00:02.1981015

Running script mojoportal-core - 2.2.8.3 - 00:00:02.2098195

Running script mojoportal-core - 2.2.8.4 - 00:00:02.2225140

Running script mojoportal-core - 2.2.8.5 - 00:00:02.8015785

Running script mojoportal-core - 2.2.8.6 - 00:00:02.8347795

Running script mojoportal-core - 2.2.8.7 - 00:00:02.8718865

Running script mojoportal-core - 2.2.8.8 - 00:00:02.9128995

Running script mojoportal-core - 2.2.8.9 - 00:00:02.9226645

Running script mojoportal-core - 2.2.9.0 - 00:00:03.1736250

Running script mojoportal-core - 2.2.9.1 - 00:00:03.9665430

Running script mojoportal-core - 2.2.9.2 - 00:00:03.9880260

Running script mojoportal-core - 2.2.9.3 - 00:00:05.1744735

Running script mojoportal-core - 2.2.9.4 - 00:00:05.1871680

Running script mojoportal-core - 2.2.9.5 - 00:00:05.7398670

Running script mojoportal-core - 2.2.9.6 - 00:00:06.2662005

Running script mojoportal-core - 2.2.9.7 - 00:00:06.3081900

Running script mojoportal-core - 2.2.9.8 - 00:00:06.3833805

Running script mojoportal-core - 2.2.9.9 - 00:00:06.4058400

Running script mojoportal-core - 2.3.0.0 - 00:00:06.7495680

Running script mojoportal-core - 2.3.0.1 - 00:00:06.7671450

Running script mojoportal-core - 2.3.0.2 - 00:00:06.8013225

Running script mojoportal-core - 2.3.0.3 - 00:00:06.8296410

Running script mojoportal-core - 2.3.0.4 - 00:00:06.8579595

Running script mojoportal-core - 2.3.0.5 - 00:00:06.8794425

Running script mojoportal-core - 2.3.0.6 - 00:00:07.1880165

Running script mojoportal-core - 2.3.0.7 - 00:00:07.3217970

Running script mojoportal-core - 2.3.0.8 - 00:00:07.7143500

Running script mojoportal-core - 2.3.0.9 - 00:00:07.7387625

Running script mojoportal-core - 2.3.1.0 - 00:00:08.0395245

Running script mojoportal-core - 2.3.1.1 - 00:00:08.0531955

Running script mojoportal-core - 2.3.1.2 - 00:00:09.1800765

Running script mojoportal-core - 2.3.1.3 - 00:00:09.2074185

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.

 If I try to do anything after this point I get to the setup page again, only:

Probing system...

File system permissions ok.

MySQL database connection ok.

database permissions are sufficient to alter schema.

database initial schema already exists.

database core schema needs upgrade.

0 site(s) found.

 

All mp_*-tables seem to get created during setup, and I use my MySQL root account that's granted ALL on DATABASE.*.

8/26/2009 4:51:04 PM
Gravatar
Total Posts 5

Re: "Database core schema needs upgrade" on setup on MySQL

ADD:

If I switch to my "old" database, the site works perfectly as long as I don't try to edit content or access /Admin/SiteSettings.aspx.

Then I get the "database core schema needs upgrade. 1 site(s) found." again.

Most other pages seem to work fine, haven't tried all of them.

8/26/2009 7:55:16 PM
Gravatar
Total Posts 2239

Re: "Database core schema needs upgrade" on setup on MySQL

Did you make a backup of your site files prior to upgrading? If so, replace those and use your original DB. Make sure everything is working properly and then try again.

Hope this helps,
Joe

8/27/2009 6:09:29 AM
Gravatar
Total Posts 18439

Re: "Database core schema needs upgrade" on setup on MySQL

If you are use the new release version 2.3.1.5 then this means you did not upload all the scripts. It knows it needs to run more scripts to get up to date but it can't find them. It stopped at 2.3.1.3 so it can't find the script for 2.3.1.4 or 2.3.1.5.

I would upload the /Setup folder again and then visit the setup page again. You probably had ftp errors and not al the files made it the first time.

Hope it helps,

Joe

8/27/2009 6:14:15 AM
Gravatar
Total Posts 5

Re: "Database core schema needs upgrade" on setup on MySQL

Joe,

I deleted all of my old files except the config files and made sure all of my files transferred - that made the trick!

So either it was just as you said or some old files where left messing things up.

Thanks! :)

8/27/2009 6:18:21 AM
Gravatar
Total Posts 18439

Re: "Database core schema needs upgrade" on setup on MySQL

You should always use the new Web.config file. You can keep your user.config file and have most of your custom settings in there, but anything you have customised in your old Web.config you should transfer to the new Web.config, otherwise you may be missing new settings or changed default settings.

Best,

Joe

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