SuperFlexi script error

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.
10/9/2017 2:24:40 PM
kevin@kevography.com
Gravatar
Total Posts 2
View Posts

SuperFlexi script error

I am trying to install the latest version (2.6.0.0) and when I run setup I'm getting an error (below).  Can you point me in the right direction to fix this? 

Running script superflexi - 0.0.0.9 - 00:00:01.5562875
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'SET'. Incorrect syntax near the keyword 'SET'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) in C:\Web Sites\mojoportal\mojoPortal.Data.MSSQL\SqlHelper.cs:line 154 at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Web Sites\mojoportal\mojoPortal.Data.MSSQL\SqlHelper.cs:line 113 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in C:\Web Sites\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 759 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in C:\Web Sites\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 692 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in C:\Web Sites\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 327 ClientConnectionId:f7004721-4d55-460a-aaa5-0ac6fc373031 Error Number:156,State:1,Class:15 - 00:00:01.6583027

10/10/2017 5:48:29 AM
kevin@kevography.com
Gravatar
Total Posts 2
View Posts

Re: SuperFlexi script error

I finally figured this out...my database was MSSQL 2005, which doesn't recognize "SET (LOCK_ESCALATION = TABLE)".  I removed that and it works fine.  Sorry for the false alarm.  Guess I need to update my database!

3/5/2018 3:21:18 PM
CraigT
Gravatar
Total Posts 40
View Posts

Re: SuperFlexi script error

Thank you for posting your solution to this. I was getting the same error (also using MSSQL 2005) and this pointed me in the right direction for getting Superflexi to install properly. I'm just hoping that there aren't any other issues involved with running on an older version of MSSQL...

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