Problem migrating MojoPortal

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/25/2011 11:27:52 AM

andydkelly

Total Posts 16

View Posts

Problem migrating MojoPortal

Hi,

I have developed my site on my laptop and am now in the process of migrating the data to my hosted server. I have restored the database as per the instructions and have copied all the files/filders acorss in the order specified, however when i run the www.winkell.co.uk/default.aspx i get the following errors:

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.5625000
Running script mojoportal-core - 2.2.1.6 - 00:00:00.6093750
Running script mojoportal-core - 2.2.1.7 - 00:00:00.6093750
Running script mojoportal-core - 2.2.1.8 - 00:00:00.6093750
Running script mojoportal-core - 2.2.1.9 - 00:00:00.6406250
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:00.8281250
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.

Any ideas?

Cheers

Andy

3/27/2011 8:31:54 AM

Joe Audette

Total Posts 18439

View Posts

Re: Problem migrating MojoPortal

Hi Andy,

It seems like the restore process did not work correctly or your db user is not in the dbo role so it does not correctly see the tables and stored procedures in the database.

When you move a site it should not run any upgrade scripts (you should not try to do an upgrade at the same time as moving a site).

What apparently is happening is it does somehow see the mp_Sites table (this is how mojoportal detects if it should be doing a new installation or upgrade), so by seeing this table it knows it is not a new installation so it then tries to check what current version is installed by running a stored procedure against the mp_SchemaVersion table, this apparently fails (either the user does not see the proc or table or they don't exist) so it does not know the version and tries to run the oldest scripts up to the newest scripts. But that is not needed and only causes more errors.

Hope it helps,

Joe

3/28/2011 6:11:50 AM

andydkelly

Total Posts 16

View Posts

Re: Problem migrating MojoPortal

Thanks Joe! Got it sorted now. Created a new blank database. Imported all my files (not DB) and ran default.aspx. Then imported DB and now all is working.

Thanks!

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