help.axcms.netAxinom Logo
Save Save Chapter Send Feedback
KB10022: DbQueryException: Incorrect syntax near ','
If the values of the resource managers in web-configs are empty, an error may occur

SYMPTOMS

This exception is thrown:

Exception Details: Axinom.Framework.Data.DbQueryException: Incorrect syntax near ','.

SQL:
select .Text as , .Page as _PAGE, .Position as _POSITION from _ as
Connection:
SERVER=XXX;DATABASE=AxCMS_Sample;UID=AxinomCMS;PWD=XXXXXX

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:

[DbQueryException: Incorrect syntax near ','.

SQL:
select .Text as , .Page as _PAGE, .Position as _POSITION from _ as
Connection:
SERVER=XXX;DATABASE=AxCMS_Sample;UID=AxinomCMS;PWD=XXXXXX
]
Axinom.Framework.Data.DbQuery.ExecuteDataTable(DataSet ds, String srcTable) +239
Axinom.Framework.Data.DbQuery.ExecuteDataTable() +60
Axinom.Framework.Language.ResourceManager.a() +136
Axinom.Framework.Cache.CacheProvider.InitManager(ICachedManager manager, CacheDependency cacheDependency) +366
Axinom.Framework.Language.ResourceManagerFactory.GetManager(String name) +144
AxCMS.AxCMSweb.login.Render(HtmlTextWriter writer) +32
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4576

CAUSE

The values of the resource managers in web-configs are empty. In IIS7 under Vista it can happen when one changes the configuration of the website inside IIS7 manager, for example when setting the https handlers.

SOLUTION

To avoid the problem, make the changes to the configuration in the web-config files.

If the problem is already there, fill the resource manager sections again, for example download the package again and overwrite these sections from the original web.configs.

MORE INFORMATION

Read here more about configuring IIS: http://en.help.axinom.de/en_help_cms_inst_iis.AxCMS

APPLIES TO

AxCMS.net versions: All versions´

IIS versions: 7.x