mojoportal setup

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.
9/3/2010 5:24:42 AM
ilasuper
Gravatar
Total Posts 55
View Posts

mojoportal setup

Welcome to mojoPortal Setup

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.3.4.8 - 00:00:00.0937500
System.Data.SqlClient.SqlException: Must declare the scalar variable "@PathId". 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.8906250
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

 

Hi all,

 

It's stops here... what is wrong?

 

Thanks

9/3/2010 5:26:53 AM
ilasuper
Gravatar
Total Posts 55
View Posts

Re: mojoportal setup

Running script mojoportal-core - 2.3.4.8 but I uploaded mojoportal-2-3-5-1-mssql-net35- version

9/3/2010 6:59:38 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: mojoportal setup

Hi,

It is supposed to start with script 2.3.4.8, it will run other scripts after that.

The problem seems to be that you have a case sensitive collation on the database and the script has 2 places where a variable is not declared with consistent casing.

If you edit the file /Setup/applications/mojoportal-core/SchemaInstallScripts/mssql/2.3.4.8.config

do a find and replace, to find @PathId and replace it with @PathID.

Hopefully that is the only place where there is a case difference. I've updated my copy.

You might also consider not using a case sensitive collation.

Hope it helps,

Joe

9/3/2010 8:02:50 AM
ilasuper
Gravatar
Total Posts 55
View Posts

Re: mojoportal setup

Thank you Joe, I have changed following names:

SiteId to SiteID

ApplicationId to ApplicationId

ModuleDefId to ModuleDefId

DefaultPageKeywords to DefaultPageKeyWords
siteID to SiteID it gave error but installed anyway do i have to continue working or i have to reinstall ?

Welcome to mojoPortal Setup

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.3.4.8 - 00:00:00.0312500
Running script mojoportal-core - 2.3.4.9 - 00:00:01.9218750
Running script mojoportal-core - 2.3.5.0 - 00:00:02.0468750
Running script mojoportal-core - 2.3.5.1 - 00:00:02.0781250
Creating site with default settings... - 00:00:02.0937500
Creating roles and admin user... - 00:00:20.4062500
Configuring feature Html Content - 00:00:21.2343750
Configuring feature Site Statistics - 00:00:21.3750000
Configuring feature Web Part - 00:00:21.3906250
Configuring feature Newsletter Sign Up Form - 00:00:21.3906250
Configuring feature Bing Map - 00:00:21.4375000
Running script blog - 0.0.1.8 - 00:00:21.4687500
Running script blog - 0.0.1.9 - 00:00:22.0312500
Configuring feature Blog - 00:00:22.0937500
Running script contactform - 0.0.0.5 - 00:00:22.1875000
Configuring feature Contact Form - 00:00:22.2500000
Running script eventcalendar - 0.0.0.5 - 00:00:22.2812500
Configuring feature Event Calendar - 00:00:22.3593750
Running script feed-manager - 0.0.0.9 - 00:00:22.3750000
System.Data.SqlClient.SqlException: Invalid column name 'FeedID'. 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:22.4062500
Running script feed-manager - 0.0.0.2 - 00:00:22.4218750
Running script feed-manager - 0.0.0.3 - 00:00:22.4375000
Running script feed-manager - 0.0.0.4 - 00:00:22.4375000
System.Data.SqlClient.SqlException: Invalid object name 'dbo.mp_RssFeeds_Select'. 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:22.4531250
Configuring feature Feed Manager - 00:00:22.4843750
Configuring feature Flickr Slide Show - 00:00:22.5468750
Configuring feature Image Gallery (Simple Folder Version) - 00:00:22.5625000
Running script forums - 0.0.1.6 - 00:00:22.6093750
Running script forums - 0.0.1.7 - 00:00:22.7656250
Configuring feature Forums - 00:00:23.0468750
Configuring feature Google Map - 00:00:23.1093750
Configuring feature Google Translate - 00:00:23.1562500
Configuring feature Html Fragment Include - 00:00:23.1875000
Configuring feature IFrame - 00:00:23.2187500
Running script imagegallery - 0.0.0.7 - 00:00:23.2500000
Configuring feature Image Gallery - 00:00:23.3437500
Running script linksmodule - 0.0.0.7 - 00:00:23.3750000
Configuring feature Simple List/Links - 00:00:23.4375000
Configuring feature Live Messenger Chat - 00:00:23.6562500
Running script pollfeature-byChristianFredh - 0.0.0.5 - 00:00:24.0156250
Configuring feature Poll - 00:00:24.2187500
Running script sharedfiles - 0.0.0.9 - 00:00:24.2343750
Configuring feature Shared Files - 00:00:24.3125000
Running script surveyfeature - 0.0.1.7 - 00:00:24.3281250
System.Data.SqlClient.SqlException: Invalid column name 'surveyGuid'. 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:24.3750000
Running script surveyfeature - 0.0.0.2 - 00:00:24.3906250
Running script surveyfeature - 0.0.0.3 - 00:00:24.4375000
Running script surveyfeature - 0.0.0.4 - 00:00:24.4687500
Running script surveyfeature - 0.0.0.5 - 00:00:24.5937500
System.Data.SqlClient.SqlException: Invalid object name 'dbo.mp_Survey_Insert'. 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:24.6093750
Configuring feature Survey - 00:00:24.6562500
Configuring feature Twitter Profile Widget - 00:00:24.6718750
Configuring feature Twitter Search Widget - 00:00:24.6875000
Running script webstore - 0.0.6.9 - 00:00:24.7031250
Configuring feature Web Store - 00:00:25.6875000
Configuring feature Xml/Xsl - 00:00:25.7031250
Ensuring all features are installed in server admin sites... - 00:00:25.7031250
No pages found so creating default content...
Setup is complete, click the link below to go to the home page.
Site Home Page

Database PlatformMSSQL
Version2.3.5.1
StatusYour installation is up to date.

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

9/3/2010 8:37:23 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: mojoportal setup

I recommend start over and create a new database using a non case sensitive collation.

Best,

Joe

9/3/2010 8:40:56 AM
ilasuper
Gravatar
Total Posts 55
View Posts

Re: mojoportal setup

Thank you very much Joe

9/3/2010 1:00:53 PM
ilasuper
Gravatar
Total Posts 55
View Posts

Re: mojoportal setup

Joe I have on the server sql 2005 and I set collation to SQL_Latin1_General_CP1_CI_AI but anyway it gives me same error

 

what do I have to do?

 

Thanks

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