Help with new installation

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/8/2008 5:41:18 PM
mazeman
Gravatar
Total Posts 3
View Posts

Help with new installation

Hi,

I was installing mojo on a windows 2003/MSSQL 2000 server and I got the The namespace 'Resources' already contains a definition for 'Resource' , so I manually deleted the other Resource.* files ald left only the Resource.resx file. After that I started the install script and it gave me this message:

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.6.7 - 00:00:00.5781250
System.Data.SqlClient.SqlException: The text, ntext, and image data types are invalid in this subquery or aggregate expression. 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:12.6875000
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.
 

Can some1 help, Thanks

 

 

 

 

 

9/8/2008 6:21:41 PM
mazeman
Gravatar
Total Posts 3
View Posts

Re: Help with new installation

I found a thread with the same problem:

http://www.mojoportal.com/ForumThreadView.aspx?thread=1906&mid=34&pageid=5&ItemID=3

Im going to test that solution.

9/8/2008 6:44:29 PM
mazeman
Gravatar
Total Posts 3
View Posts

Re: Help with new installation

I changed to an MSSQL 2005 server and it fixed the problem.

9/9/2008 7:55:54 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Help with new installation

Hi,

Glad you were able to get it working. It would have been ok to chop out that part of the script and use SQL 2000, the only side affect would be if we updated a default validation expression for an existing feature, it would not get the update. Its very rare that we change one anyway so its a minor issue. What I need to do to really fix this for SQL 2000 is to re-write that sql fragment in a way that is compatible with SQL 2000. It will require some ugly business like using a cursor, but I think it can be fixed so its still compatible. When I get a chance I will look into this.

Best,

Joe

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