Hi All -

I have tried twice now to upgrade to the latest version. I seem to have all the files required but I continue to get the error below. Any help is greatly appreciated.

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.
Running script mojoportal-core - 2.2.1.9 - 00:00:00.8112260
System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:01.4976480
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.

Hi Joe -

Thank you so much for the response!

I did not copy the database or change to a different database or database server. The new installation is running on the exact same hosting account as the old one.

I installed the new version of mojoPortal (mojoportal-2-3-9-4-mssql-net40-deploymentfiles.zip) over top of the old one. I did make a backup of the database per the install instructions.

I also did not change anything in the connection string.

Any more ideas are greatly appreciated.

Greg

Q = Do all the tables and procedures in your database have the dbo. prefix or not?
A = Yes

Q = Is the table mp_SchemaVersion populated or not?
A = Yes. it has 12 entries

Q = What version does it say for mojoportal-core?
A = 8

Q = What version did you install originally?
A = I dont have this info - we created the site late 2011. 

Q = Have you ever upgraded this installation before?
A = No.

Q = Who is your host?
A = GoDaddy

Q = Is it possible they made some change after the original installation like it was installed with the db user as a dbo but they later changed it so your db user is no longer dbo?
A = I don't think so. It has "dbo" in the owner field of all tables.

Thanks again for sticking with me, Joe.

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>