installation error - installing mojoportal into an existing database

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/1/2010 9:59:45 AM
Gravatar
Total Posts 7

installation error - installing mojoportal into an existing database

Hello,

 

I'm hoping that someone can help me with this issue.  I am installing mojoportal on a site where the mojo portal database has already been created  - and two sites already exist.  What I would like to do, is remove the existing sites (is there a script for that?) as they were created during a previous test and I'm unsure of their configuration.  They will not be used for the live sites that I'm currently trying to install for.  But first, I need to get past the installation. 

I am getting the following errors when I try to run the setup/default.aspx page:

Probing system...
File system permissions ok.
MSSQL database connection ok.

mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

database initial schema already exists.
database core schema needs upgrade.
2 site(s) found.
This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.

 

After looking thru the site hosting help, the problem lies in the fact that the sql script references [dbo]. Their help advised me to change the [dbo] to my database name.  To test this, I took one of the install scripts (2.3.3.9.config) and ran it in query analyzer.  I received an error that I did not have permissions to update the schema.  When I replaced all [dbo] with my database name, as the site help advised, I was able to run the script in the query analyser with no errors.  So, I replaced the updated script on my install site (2.3.3.9.config), touched the web.config file and ran the setup again - same message.

Can someone advise me what to try next?

Also, any help in cleaning out the existing database would be greatly appreciated.  I cannot delete the database and start over, as that is not an option on the hosting site.  I need to find a way to clean out the existing mojoportal tables of the previous installation and repopulate the tables.

Thank you in advance for any help.

Donna

4/1/2010 10:06:50 AM
Gravatar
Total Posts 18444

Re: installation error - installing mojoportal into an existing database

Hi Donna,

Since you don't want any of the existing data I think the best thing at this point would be to either use a new clean db or delete all the procedures then all the tables and let it do a clean install.

Regarding the dbo issue, I would restore all the original scripts and then just put this in your user.config:

<add key="MSSQLOwnerPrefix" value="[dbo]." />

replacing "[dbo]." with "yourdbuser." or possibly just an empty string "" would work just as well or better.

The system will replace the [dbo]. with whatever you place there before it executes each script.

Hope it helps,

Joe

4/1/2010 10:39:34 AM
Gravatar
Total Posts 7

Re: installation error - installing mojoportal into an existing database

Joe,

 

Thank you for your advise.  I've now gotten further with the install.  Here is the current error message:

 

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.
2 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.3.3.9 - 00:00:00.1406295
System.Data.SqlClient.SqlException: There is already an object named 'mp_FriendlyUrls_GetSearchCount' in the database. 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(TdsParserStateObject stateObj) 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, 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.1562550
 

 

Donna

 

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