database initial schema needs to be created

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.
4/16/2014 3:20:18 PM
Gravatar
Total Posts 13

database initial schema needs to be created

I followed these instructions: https://www.mojoportal.com/packaging-and-deployment.aspx

However, I am still receiving the error for mssql.

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.

My setup file is there.

I have followed the Readme.txt in the solution from TortoiseSVN.

I have tried deleting everything and recreating it.

I'm not sure what I am missing.

Please help.

4/16/2014 3:33:33 PM
Gravatar
Total Posts 18444

Re: database initial schema needs to be created

"database initial schema needs to be created"

That message is shown when it does not detect the existence of the mp_Sites table in the database.

You may think you have packaged things correctly but it does not seem so. If it shows no database scripts being executed on the setup page it seems likely that you did not upload the database scripts.

I suggest download the official release package that I made for mojoPortal 2.4.0.3, ie mojoportal-2-4-0-3-mssql-net40-deploymentfiles.zip

and compare the contents below the  /Setup/applications folders and sub folders below there to understand what is missing in your package

See also the article Setup and Upgrade for Custom features, note that mojoPortal core and our included features use the same system to run database scripts.

ie the sql scripts for mojoPortal core are in sub folders under

/Setup/applications/mojoportal-core

4/17/2014 8:33:49 AM
Gravatar
Total Posts 13

Re: database initial schema needs to be created

Thank you Joe very much. I was missing this:

/Setup/applications/mojoportal-core

Everything is good now. I appreciate you taking the time.

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