SqlException thrown at script "2.2.7.9 - 00:00:02.9062500" during the installation...

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/15/2009 8:41:49 AM
Gravatar
Total Posts 2

SqlException thrown at script "2.2.7.9 - 00:00:02.9062500" during the installation...

I've sucessfully installed MojoPortal 2.3.1.3 on by localmachine (Windows XP, SQL Server 2005).

However, when I try to install the application at my hosted server running Windows Server 2003 and SQL Server 2008 I get the following SQL error when I access the Setup/Default.aspx page:

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.7.8 - 00:00:00.0937500
Running script mojoportal-core - 2.2.7.9 - 00:00:02.9062500
System.Data.SqlClient.SqlException: Incorrect syntax near ','. 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:02.9218750

 

Any clues why? I tried to delete the entire database and create a brand new, and then reload the page again, same story...


 

 

 

8/15/2009 8:53:28 AM
Gravatar
Total Posts 18439

Re: SqlException thrown at script "2.2.7.9 - 00:00:02.9062500" during the installation...

Only thing I can guess is that the file got corrupted somehow during ftp. I would re-upload the /Setup folder and see if that solves it. 

Hope it helps,

Joe

8/15/2009 10:36:08 AM
Gravatar
Total Posts 2

Re: SqlException thrown at script "2.2.7.9 - 00:00:02.9062500" during the installation...

Good guess Joe - I re-uploaded the /Setup folder using a different FTP client (FileZilla this time), and that solved the problem.

Thanks for the advise, and thanks for a great application!

One beer coming up!

/Fred

 

 

 

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