Database Stored Procedure Does not exist

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
11/20/2009 3:04:59 AM
Princesse
Gravatar
Total Posts 70
View Posts

Database Stored Procedure Does not exist

 

I  copy my Local Database to Server successfully using MS SQL Server Import and Export Wizard but when I run my Site ...

I have this 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.

This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

Running script mojoportal-core - 2.2.1.5 - 00:00:00.0468744

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).

 

Please help on this matter.

 

Thank you.

11/20/2009 3:37:55 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: Database Stored Procedure Does not exist

Hi,

It seems that stored procedures don't exported to new database on your Server. See stored procedures in new database. I recommend you that move your database by Backup/Restore .

Hope Helps,

Asad

 

11/20/2009 6:43:01 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Database Stored Procedure Does not exist

As Asad said,

You cannot move a database from on server to another using export/import.

There are only 2 ways it can work.

1. Create a database backup on the original server and restore it on the new server.

2. You "may" also be able to use this tool to script off all the objects and data into a script that can be run on the new machine.

Hope it helps,

Joe

11/22/2009 9:22:49 PM
Princesse
Gravatar
Total Posts 70
View Posts

Re: Database Stored Procedure Does not exist

Hello,

It works!

The Final solution.

1. Save my Database as .Bak file.

2. Zip the .bak file( I done this since my DB is almost 20mb to make the file size smaller)

3. Use the Restore option.

Thank you very much.

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