Database core schema needs upgrade

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.
5/15/2010 8:22:36 PM
Gravatar
Total Posts 85

Database core schema needs upgrade

Hi ,

    I changed the host company. My backup copy to all my new host company. I did convert MsSQL 2005 to  MsSQL 2008. After MojoPortal setup then asked, I accepted it. ( i did change <add key="DisableSetup" value="false" /> to <add key="DisableSetup" value="true" /> )

   Then I saw this error. What should I do ?

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.
0 site(s) found.
Running script mojoportal-core - 2.2.1.5 - 00:00:00.3906325

An Error Occurred:Could not find stored procedure 'mp_SchemaVersion_SelectOne'.
Source:.Net SqlClient Data Provider
 

     [ I Use MsSQL 2008, ASP.NET 3.5, Windows Server, MojoPortal Version 2.3.4.2 ]

    Best,

   Volkan PEKGOZEGU

   www.abapspecialist.com

5/16/2010 10:11:54 AM
Gravatar
Total Posts 383
Thanks Squire Dude

Re: Database core schema needs upgrade

ISSUE:

I had the almost exact same issue when I copied the files from my local machine to the new hosting server.

SOLUTION:

If you compare your local fodler scructure to that on the server and especially the SETUP folder and all its child folders and files I believe you will find that there are a lot of files missing.  Copy the files over again and this time DO NOT COPY the entire SETUP folder at once.  Take smaller steps as it will result in a more accurate (complete) transfer of the system.

5/16/2010 4:11:51 PM
Gravatar
Total Posts 85

Re: Database core schema needs upgrade

    Hi, I tried some more. I compared the files no problem. "/Httpdocs/Data/Sites/1/index/ *.*"  I deleted the file. (httpdocs my www root name, do not use my new hosting WWW, they are httpdocs use)... I again restored MSSQL database.

   The error continues...

[note : if not made to restore database, the installation is successful. After restoring I get the error.]

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.
0 site(s) found.
Running script mojoportal-core - 2.2.1.5 - 00:00:00.0468762

An Error Occurred:The stored procedure 'mp_SchemaVersion_SelectOne' doesn't exist.
Source:System.Data

[ I Use MsSQL 2008, ASP.NET 3.5, Windows Server, MojoPortal Version 2.3.4.2 ]

Best,

Volkan PEKGOZEGU

www.abapspecialist.com

5/17/2010 5:41:25 AM
Gravatar
Total Posts 18439

Re: Database core schema needs upgrade

Hi Volkan,

It is difficult to help because your database is in an unknown condition. Did you manage to restore it when you moved hosting? It must be done using a real restore database action it cannot be done just by importing tables. If you tried importing tables instead of doing a restore it will not work.

The way the setup system decides whether it is a new installation or an upgrade is by detecting the existence of the mp_Sites table. If the table already exists then it knows it is not a new installation, it must be an upgrade. Then it checks the mp_SchemaVersion table using stored procedures which should already be installed to find out what version it is at already so it will only run newer scripts. This is apparently where a problem is happening it cannot determine the current version so it tries running the lowest version of upgrade script that exists on disk. So my guess is that either you are missing stored procedures or missing the mp_SchemaVersion table or the user is not dbo and doesn't have permissions on the tables and procs. The first 2 issues can only happen if you did not restore it correctly. If the user (connection string user) is not dbo (database owner of the database) but he was dbo on your previous host (which he probably was) then I do not know a solution that could be prescribed in steps, it would require an expert with admin access to solve it.

When your host gives you a database and user, then you restore a database over it what happens is that the user issued by the host no longer works, he gets orphaned from the database by the restoration process and only your host can restore him. So after a restore you need your host to fix the user again.

Hope it helps,

Joe

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