Error installation script SQL?

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.
9/25/2009 12:38:15 PM
graffitoweb
Gravatar
Total Posts 3
View Posts

Error installation script SQL?

Hi, and sorry for my bad english! In a server with:

OS: Windows Server 2003 SP2 (Italian language)

DB: SQL Server Standard Edition (Italian language)

MojoPortal: mojoportal-2-3-1-7-mssql-deploymentfiles

i have always this error at SetUp:

****

Verifica del sistema...

Privilegi del File system ok.

MSSQL connessione al database ok.

i privilegi per il database sono sufficienti per modificare lo schema.

lo schema iniziale del database deve essere creato.

Esecuzione script mojoportal-core - 2.2.7.8 - 00:00:00.3750264

System.Data.SqlClient.SqlException: Il nome di colonna 'PathId' non è valido. Il nome di colonna 'PathId' non è valido. in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) in System.Data.SqlClient.SqlCommand.ExecuteNonQuery() in mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.8438094

****

I think some problems whit QUOTED_IDENTIFIER in the script.

have any idea to resolve this error? 

Thanks! Alberto.

9/25/2009 12:42:13 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error installation script SQL?

Hi,

Please make sure you have all the service packs installed for your SQL Server.

Hope it helps,

Joe

9/25/2009 12:53:11 PM
graffitoweb
Gravatar
Total Posts 3
View Posts

Re: Error installation script SQL?

Hi Joe, you are very fast!

The version of SQL is 9.00.4035.00 (SP3)

 

9/25/2009 1:05:55 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error installation script SQL?

Hi,

I'm not sure what the problem is, no-one else has reported this issue and we have many installations all around the world including Italy.

I suspect possibly some collation issue using the Italian version of SQL Server.

I would try making a new db with unicode charset and unicode collation.

Hope it helps,

Joe

9/26/2009 4:10:10 AM
graffitoweb
Gravatar
Total Posts 3
View Posts

Re: Error installation script SQL?

Hi,

the SQL server that it does not work has collation "Latin1_General_BIN" and the DB  has "Latin1_General_CI_AS".

In a pc client with Visual Web Developer i try launch setup and create the DB on a local SQL Express with collation "Latin1_General_CI_AS" and DB with "Latin1_General_CI_AS".

In this case setup script work fine.

Then i backup the default DB from SQL Express and restore into SQL 2005 SE, and copy the folder 1 (...\data\sites\1) in the server folder.

With this workaround now work fine!

I think the problem is in the collation "Latin1_General_BIN" that have SQL 2005 SE.

A beer for you. Thanks

9/26/2009 6:54:32 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error installation script SQL?

Hi,

Glad its working!

And many thanks for the beer!

Cheers,

Joe

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