Incorrect syntax near '-' on existing site - Sitefinity - Bugs & Issues

All Replies

Posted by Community Admin on 09-Apr-2012 00:00

I have a Sitefinity 5.0 site that has been upgraded to every major sitefinity revision within the last year. My database naming convention has been SF-sitename. Starting last week I have been receiving the error 'Incorrect syntax near '1'' error on two of my sites. I know my schema has the correct permission but I'm not sure what else could be causing this error?

Here's the full error, any ideas?:

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: Telerik.OpenAccess.RT.sql.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: Incorrect syntax near '-'.]

Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +298

Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +9

OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +459

[OpenAccessException: SQL exception on 'CREATE DATABASE SF-KCSourceLink' : Incorrect syntax near '-'.]

OpenAccessRuntime.ExceptionWrapper.Throw() +13

OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +38

OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +639

OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1819

[OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATE DATABASE SF-KCSourceLink' : Incorrect syntax near '-'.]

DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_54a79b85165e4d00a9d6057c0fbeb3e7.Initialize(String providerName, NameValueCollection config, Type managerType) +405

Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1972

Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74

Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +526

[TargetInvocationException: Exception has been thrown by the target of an invocation.]

System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0

System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +117

System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +247

System.Activator.CreateInstance() +88

Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +120

Telerik.Sitefinity.Services.SystemManager.Initialize() +232

Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +307

Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +386

Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +116

System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +575

System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352

System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407

System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375

[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11700608

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141

System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4868805

This thread is closed