Hello,

I have moved my Web Site(mojoPortal) and MSSQL database from one server to another, but now I get installation screen when I try to open my web site. Why MojoPortal ask for installation? I have moved the whole database all all files intact. 

Regards,
Tomas

I have adjusted User permissions in MSSQL but now MojoPortal tries to run queries, why MojoPortal tries to update database? I use the same database which is used on another server and MojoPortal all files also copied from that server.

 

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:01.7968750

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

Source:System.Data

Stack Trace at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at mojoPortal.Data.SqlHelperParameterCache.DiscoverSPParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at mojoPortal.Data.SqlParameterHelper.InitializeArray() at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt) at mojoPortal.Data.DBPortal.SchemaVersionGetSchemaVersion(Guid applicationId) at mojoPortal.Data.DBPortal.SchemaVersionExists(Guid applicationId) at mojoPortal.Business.DatabaseHelper.UpdateSchemaVersion(Guid applicationId, String applicationName, Int32 major, Int32 minor, Int32 build, Int32 revision) at mojoPortal.Web.UI.Pages.SetupHome.RunUpgradeScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



I have selected "export" option in MSSQL server, entered new MSSQL server address and login information, clicked finish and MSSQL server moved database to new location.

Hi, Could you please bring me a light: is there a way to move the sites in a same way for MySQL DB servers? I have the similar situation with MySQL 4.1.22. Is that means what my DB Backup/Restore have lost some data/indexes? Thanks a lot in advance, Igor

Thanks a lot! I am not sure what I will be able to implement the import at the remote commerce hosting, but, anyway, you've point me the way. BTW: Is phpMyAdmin used the mysqlimport functionality for the Import option? I will try anyway.. Thanx a lot, again. Igor.