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.
1/16/2013 9:33:19 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

In your screen shot what is [mojodb] in the select * from [mojodb].[dbo].mp_SchemaVersion?

I cannot imagine that is the database name hosted at godaddy.

Are you sure that [mojodb].[dbo] is not the owner prefix?

Are you sure there is not another copy of the same table with a different owner prefix and different data?

1/16/2013 9:45:16 AM
Gravatar
Total Posts 37

Re: database core schema needs upgrade.

Actually mojodb is the database name. Is that bad?

Q. Are you sure that [mojodb].[dbo] is not the owner prefix?
A. How do i determine if it is?

Q. Are you sure there is not another copy of the same table with a different owner prefix and different data?
A. I have scrolled through the list of tables and I am 100% certian that there are no duplicates.

 

1/16/2013 9:58:42 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

Out of all the mojoPortal installations on godaddy it is very unlikely that yours has the database named mojodb. I think godaddy has changed something about your database user after your initial installation and I think there does exist another table named mp_SchemaVersion but your user no longer sees this table so it created a new one with its new prefix and therefore it cannot coorectly determine what version it is upgrading from so it tries really old scripts.

I would get a backup of your db and restore it on a local machine, then inspect it as  admin aka sa user to see if it does have multiple copies of one or more tables with different owner prefixes.

When you view a tables using SQL Server Management tools the own prefix is visible as shown below:

sql owner screenshot

I suspect you have some tables duplicated with different owner prefixes and the db user cannot see the ones with the other/older owner.

1/16/2013 9:59:24 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

the real database name would be in the connection string in user.config

1/16/2013 10:11:17 AM
Gravatar
Total Posts 37

Re: database core schema needs upgrade.

Here is the user.config file:

<?xml version="1.0" encoding="utf-8"?>
<appSettings>
  
  <!-- 
  IMPORTANT:
  Note that changes made to this file are not automatically detected by the ASP.NET runtime
  It does detect changes to Web.config, so when you make a change in this file you need to touch Web.config (ie type a space in it and save it)
  to make it reload settings
  -->

  <add key="MSSQLConnectionString" value="server=mojodb.db.2243892.hostedresource.com;UID=mojodb;PWD=**********;database=mojodb" />

  <add key="MySqlConnectionString" value="Server=localhost;Database=mojoprod;Uid=root;Pwd=Charset=utf8;" />

  <add key="PostgreSQLConnectionString" value="Server=localhost;Port=5432;User Id=postgres;Password=;Database=mojo;Encoding=UNICODE;" />
  
  <add key="FirebirdConnectionString" value="Data Source=localhost;Server Type=0;Port Number=3050;Database=C:\mojoportal\mojoportal.fdb;Dialect=3;Charset=UTF8;Pooling=True;Min Pool Size=0;Max Pool Size=200;Connection Timeout=10;Connection Lifetime=60;Fetch Size=200;User Id=SYSDBA;Password=masterkey" />

  <!--
            you can use a fully qualified file path as shown below
            or if you are using the default db at /Data/sqlitedb/mojoportal.db
            just leave this set to "defaultdblocation"
        <add key="SqliteConnectionString" value="version=3,URI=file:C:\\Projects\mojoportal\Web\Data\sqlitedb\mojoportal.db" />
        -->

  <add key="SqliteConnectionString" value="defaultdblocation" />


  <!-- if running in medium trust uncomment this
    <add key="RunningInMediumTrust" value="true" />
    -->

  <add key="ImageGalleryUseMediaFolder" value="true" />
  <add key="GreyBoxCssIsLoadedFromSkin" value="true" />
  
  
  <add key="DisableSearchFeatureFilters" value="false" />
  <add key="SearchUseBackwardCompatibilityMode" value="false" />
  <add key="EnableSearchResultsHighlighting" value="true" />
  <add key="SearchIncludeModuleRoleFilters" value="true" />
  <add key="Forum:AggregateSearchIndexPerThread" value="true" />
  
  <add key="UseLegacyCryptoHelper" value="false" />
  
<add key="DisableDotNetOpenMail" value="true" />
<add key="SMTPServer" value="relay-hosting.secureserver.net" />
<add key="SMTPRequiresAuthentication" value="false" />
<add key="SMTPUseSsl" value="false" />
<add key="SMTPPort" value="25" />
<add key="SMTPUser" value="" />
<add key="SMTPPassword" value="" />
  

</appSettings>

1/16/2013 10:13:57 AM
Gravatar
Total Posts 37

Re: database core schema needs upgrade.

Here is screen shot of name.

www.eriemultimedia.com/dbase_name.jpg

1/16/2013 10:18:03 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

ok, forget about the name. Get a backup as mentioned and restore it locally and look very carefully for duplicate tables with different owner prefixes.

1/16/2013 10:41:24 AM
Gravatar
Total Posts 37

Re: database core schema needs upgrade.

Joe -

Thanks again for sticking with me!

Can you please point me to a resource that explains it or tell me how to restore the backup database locally?

I have never done this before.

1/16/2013 10:48:53 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

Create a new db in sql managment tools, it doesn't have to be named the same.

Then right the new db click and choose  Tasks > Restore > Database

from there you browse to the backup file, in settings choose to overwrite the existing db

Hope that helps,

Joe

1/16/2013 11:03:03 AM
Gravatar
Total Posts 37

Re: database core schema needs upgrade.

Joe -

what is "sql managment tools"? Can I donwload it some where? A google search isn't returning anything definitive.

G

1/16/2013 11:17:06 AM
Gravatar
Total Posts 18439

Re: database core schema needs upgrade.

It is usually installed at the same time when you install sql server or sql server express, so if that is already installed you should find it in the programs menu. If you have not yet installed sql express, the easiest way to install it is using the MS Platform Installer.

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