System.Data.SqlClient.SqlException (0x80131904): Incorrect

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

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

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.

4/25/2013 12:18:00 PM

Techgeeksquared

Total Posts 13

View Posts

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

I am trying to produce a Minimal Build Without Features however, when I run the setup script I continue to get the following error.

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) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) in ...\mojoPortal.Data.MSSQL\SqlHelper.cs:line 154 at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in ...\mojoPortal.Data.MSSQL\SqlHelper.cs:line 113 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in ...\mojoPortal.Data.MSSQL\dbPortal.cs:line 751 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in ...\mojoPortal.Data.MSSQL\dbPortal.cs:line 684 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in ...\mojoPortal.Business\DatabaseHelper.cs:line 327 ClientConnectionId:0a38ebe6-ba10-465d-9952-02a49a70ce3c - 00:00:03.3190000

What am I doing wrong here.

Thank you so much for your help.

4/25/2013 12:38:33 PM

Joe Audette

Total Posts 18439

View Posts

Re: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

You only posted part of the error so I can't really tell what is causing it.

To produce a minimal build you must start with a clean checkout of the code from the source code repository and only open, compile, and publish the mojoportal-core.sln. If you ever compiled the main mojoportal.sln solution then the post build events of the other features already copied all of their files into the main web project so there is no way to get a clean copy without them at that point.

Hope that helps,

Joe

4/25/2013 1:57:07 PM

Techgeeksquared

Total Posts 13

View Posts

Re: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

Joe,

Thank you so much for your reply. I have tried to follow your instructions explicitly both in the readme.visualstudio and the producing-a-minimal-build-without-features.aspx page. Here is the top portion of what I am getting when I try to run the setup. I got the clean build by following the instructions on the getting-the-code-with-tortoisehg.aspx everything seems to work fine until I run the setup.aspx. I even deleted the db, file structure, everything and tried again but, I continue to get the error. I also tried on a clean machine and got the same error.

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.0530000
Running script mojoportal-core - 2.3.4.9 - 00:00:02.5770000
Running script mojoportal-core - 2.3.5.0 - 00:00:02.6080000
Running script mojoportal-core - 2.3.5.1 - 00:00:02.6260000
Running script mojoportal-core - 2.3.5.2 - 00:00:02.6330000
Running script mojoportal-core - 2.3.5.3 - 00:00:02.6370000
Running script mojoportal-core - 2.3.5.4 - 00:00:02.6400000
Running script mojoportal-core - 2.3.5.5 - 00:00:02.6440000
Running script mojoportal-core - 2.3.5.6 - 00:00:02.6590000
Running script mojoportal-core - 2.3.5.7 - 00:00:02.6720000
Running script mojoportal-core - 2.3.5.8 - 00:00:02.6810000
Running script mojoportal-core - 2.3.5.9 - 00:00:02.6840000
Running script mojoportal-core - 2.3.6.0 - 00:00:02.7060000
Running script mojoportal-core - 2.3.6.1 - 00:00:02.7300000
Running script mojoportal-core - 2.3.6.2 - 00:00:02.7420000
Running script mojoportal-core - 2.3.6.3 - 00:00:02.7530000
Running script mojoportal-core - 2.3.6.4 - 00:00:02.7690000
Running script mojoportal-core - 2.3.6.5 - 00:00:02.7870000
Running script mojoportal-core - 2.3.6.6 - 00:00:02.8030000
Running script mojoportal-core - 2.3.6.7 - 00:00:02.8180000
Running script mojoportal-core - 2.3.6.8 - 00:00:02.8430000
Running script mojoportal-core - 2.3.6.9 - 00:00:02.8570000
Running script mojoportal-core - 2.3.7.0 - 00:00:02.8640000
Running script mojoportal-core - 2.3.7.1 - 00:00:02.8700000
Running script mojoportal-core - 2.3.7.2 - 00:00:02.8740000
Running script mojoportal-core - 2.3.7.3 - 00:00:02.9530000
Running script mojoportal-core - 2.3.7.4 - 00:00:02.9610000
Running script mojoportal-core - 2.3.7.5 - 00:00:02.9720000
Running script mojoportal-core - 2.3.7.6 - 00:00:02.9780000
Running script mojoportal-core - 2.3.7.7 - 00:00:02.9860000
Running script mojoportal-core - 2.3.7.8 - 00:00:03.0010000
Running script mojoportal-core - 2.3.7.9 - 00:00:03.0080000
Running script mojoportal-core - 2.3.8.0 - 00:00:03.0340000
Running script mojoportal-core - 2.3.8.1 - 00:00:03.0420000
Running script mojoportal-core - 2.3.8.2 - 00:00:03.0480000
Running script mojoportal-core - 2.3.8.3 - 00:00:03.0610000
Running script mojoportal-core - 2.3.8.4 - 00:00:03.0710000
Running script mojoportal-core - 2.3.8.5 - 00:00:03.0790000
Running script mojoportal-core - 2.3.8.6 - 00:00:03.0870000
Running script mojoportal-core - 2.3.8.7 - 00:00:03.1240000
Running script mojoportal-core - 2.3.8.8 - 00:00:03.1350000
Running script mojoportal-core - 2.3.8.9 - 00:00:03.1430000
Running script mojoportal-core - 2.3.9.0 - 00:00:03.1480000
Running script mojoportal-core - 2.3.9.1 - 00:00:03.1590000
Running script mojoportal-core - 2.3.9.2 - 00:00:03.1960000
Running script mojoportal-core - 2.3.9.3 - 00:00:03.2070000
Running script mojoportal-core - 2.3.9.4 - 00:00:03.2320000
Running script mojoportal-core - 2.3.9.5 - 00:00:03.2640000
Running script mojoportal-core - 2.3.9.6 - 00:00:03.3030000
Running script mojoportal-core - 2.3.9.7 - 00:00:03.3070000
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

4/25/2013 2:07:44 PM

Joe Audette

Total Posts 18439

View Posts

Re: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

That was a typo in the newest script. Just now encountered it myself while upgrading the demo site, and fixed it, so if you pull the latest code again it should be fine.

4/25/2013 2:49:23 PM

Techgeeksquared

Total Posts 13

View Posts

Re: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'mp_SiteSettingsExDef'. at

Great, thank you.

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