Developer forum

Forum » Development » Sql error when trying to activate modules

Sql error when trying to activate modules

Jais Edelmann
Reply
 Hey i keept gettin sql error when trying to active various modules in the backend.

Incorrect syntax near ')'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near ')'.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[SqlException (0x80131904): Incorrect syntax near ')'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073486
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064444
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +228
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +326
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Dynamicweb.Database.ExecuteNonQuery(String sql, Int32 commandTimeout, Boolean useTransaction, String database, IDbConnection connection) +731
   Dynamicweb.Modules.Module.UpdateModuleAccess(String[] modules, Boolean access) +178
   Dynamicweb.Admin.Moduletree.Module_Save.SaveSelectedSolution() +620
   Dynamicweb.Admin.Moduletree.Module_Save.Page_Load(Object sender, EventArgs e) +41
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

I dont get any errors in the sql server log, and im running version 
8.1.1.5


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Hi Jai,

Which version of SQL Server are you running?

 

Imar

 
Jais Edelmann
Reply
 Microsoft SQL Server Express Edition (64-bit) 2008 (10.0.2531)
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Hmmm, then I am not sure what's going on. There are issues with SQL Server 2012 that result in similar issues.

Cheers,

Imar

 
Jais Edelmann
Reply
 Could there also be an issues with 2008 R2 perhaps?
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Not that I know; I run all my sites on R2.

Have you updated the database schema by resetting the version numbers? Take a look at step 10 at the bottom of this article.

Imar

 
Jais Edelmann
Reply
 Jup done that and i also triede removing everything regarding 2008 sql server and R2 and installed R2 complete without any affect.
 
Jais Edelmann
Reply
This post has been marked as an answer
 Seems to be working now after i made a new sql database and then restored on top off that instead of just restoring directly
Votes for this answer: 0

 

You must be logged in to post in the forum