Clean install with latest version fails with SP mp_UserRoles

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
8/21/2008 11:14:17 AM
Gravatar
Total Posts 5

Clean install with latest version fails with SP mp_UserRoles

 

Hey

Since my update failed and I couldent restore the DB I deleted the DB and created it again

But the clean install also fails

 

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.4.8 - 00:00:01.6406145
Running script mojoportal-core - 2.2.6.7 - 00:00:43.9059690
System.Data.SqlClient.SqlException: There is already an object named 'mp_UserRoles' 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:44.1247176
Running script mojoportal-core - 2.2.4.9 - 00:00:44.3278413

The rest of the installation scripts is with succes

/Ricky

8/21/2008 11:23:21 AM
Gravatar
Total Posts 18439

Re: Clean install with latest version fails with SP mp_UserRoles

Hi,

The problem is, it should start from script 2.2.6.7, but because you installed an older version previously, there is an extra script present from previous version installation.

To solve this, look in the /Setup/applications/mojoportal-core/SchemaInstallScripts/mssql folder

Most likely you have 2 scripts there, 2.2.6.7.config and 2.2.4.8.config, delete 2.2.4.8.config and start again with a clean db and it will work.

Hope it helps,

Joe

8/21/2008 1:37:35 PM
Gravatar
Total Posts 5

Re: Clean install with latest version fails with SP mp_UserRoles

 

It did help. The entire collections of install scripts completes with no exceptions

the first script "Running script mojoportal-core - 2.2.6.7 - 00:00:00.6406209" does though take nearly a minute to complete

But the result is the same:

We're sorry but a server error has occurred while trying to process your request.

The error has be...

How can that be? The site has been running version 2.2.5.4 since ~ april more or less

Any idea?

 

 

8/21/2008 1:44:00 PM
Gravatar
Total Posts 18439

Re: Clean install with latest version fails with SP mp_UserRoles

Well first we need to know what error is happening. Find this near the bottom of Web.config:

<customErrors mode="RemoteOnly" defaultRedirect="Error.htm" />

change it temporarily to:

<customErrors mode="Off" defaultRedirect="Error.htm" />

and it should show the error detail.

Hope it helps,

Joe

8/21/2008 1:59:29 PM
Gravatar
Total Posts 5

Re: Clean install with latest version fails with SP mp_UserRoles

 

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: The base class includes the field 'SiteMenu1', but its type (mojoPortal.Web.UI.SiteMenu) is not compatible with the type of control (ASP.controls_sitemenu_ascx).

Source Error:

Line 25: <portal:SiteTitle id="SiteTitle" runat="server"></portal:SiteTitle>
Line 26: <portal:SkipLink id="SkipLink1" runat="server" />
Line 27: <portal:SiteMenu id="SiteMenu1" runat="server"
Line 28: UseTreeView="false" UseSpanInLinks="true" HideMenuOnSiteMap="false"
Line 29: Direction="Horizontal" TopLevelOnly="true"></portal:SiteMenu>


Source File: /App_MasterPages/layout.Master Line: 27

8/21/2008 2:11:11 PM
Gravatar
Total Posts 18439

Re: Clean install with latest version fails with SP mp_UserRoles

Hi,

Thats very strange if you are using one of the built in skins. Can you look in the mp_Sites table and see what skin is assigned?

Can you verify that you have this in your Web.config, in the <pages><controls section?

<add tagPrefix="portal" tagName="SiteMenu" src="~/Controls/SiteMenu.ascx" />

Are you sure there were no errors uploading the files?

Did you upload ALL the files?

Has anything changed in your configuration? Are you sure its configured for 2.0 .NET?

Hope it helps,

Joe

 

8/21/2008 2:41:04 PM
Gravatar
Total Posts 5

Re: Clean install with latest version fails with SP mp_UserRoles

 

mp_Sites table = styleshout-techmania

this line is in the web.config:

<add tagPrefix="portal" tagName="SiteMenu" src="~/Controls/SiteMenu.ascx" />

Site is configures for 2.0 framework

Tomorrow( time.now is sleeping time in DK) I delete all files and upload folder by folder and try again.

I'll return with the results

/Ricky

8/22/2008 2:35:43 PM
Gravatar
Total Posts 5

Re: Clean install with latest version fails with SP mp_UserRoles

I have learned my lesson the hard way. Some files was not uploaded.

I changed FTP client - deleted all files and uploaded everything again And it worked

 

I can from now on only recommend to use a decent FTP client.

 

Once again thanks for your cool CMS and help - Ill by you a beer in the weekend

 

/Ricky

 

10/23/2008 9:39:24 AM
Val
Gravatar
Total Posts 4

Re: Clean install with latest version fails with SP mp_UserRoles

 Hi 

I'm usin SQLEXPRESS 

in config =    <add key="ASPNETDBConnectionString1" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDB.MDF;Integrated Security=True;User Instance=True" />

That the error i'm getting in setup run:

Exception Details: System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString

Source Error:

Line 77: private void Initialize(string pConnectionInfo, string pCommandText, CommandType pCmdType, int pParamCnt)
Line 78: {
Line 79: if (pConnectionInfo == null || pConnectionInfo.Length == 0) throw new ArgumentNullException("connectionString");
Line 80: if (pCommandText == null || pCommandText.Length == 0) throw new ArgumentNullException("commandText");
Line 81: connectionString = pConnectionInfo;

 

 

10/23/2008 9:50:38 AM
Gravatar
Total Posts 18439

Re: Clean install with latest version fails with SP mp_UserRoles

Why did you post this on this old unrelated thread instead of starting a new thread?

I'm using SQLExpress too and it works for me. You should configure your SQLExpress for Mixed Mode authentication (both integrated security and SQL authentication) then use SQL authentication. It may be possible to get it working with integrated auth but its much easier with sql auth. I don't know about all that attach db stuff either. With sql auth enabled my connection string is like this:

<add key="MSSQLConnectionString" value="server=localhost\SQLExpress;UID=user;PWD=password;database=mojodev" />

Hope it helps,

Joe

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