|
|
|
An unexpected error occurred.
Please provide the following information to technical support:
Error Event:
Error details:
| struct |
|---|
| Cause |
| struct |
|---|
| ErrorCode |
1064
|
| Message |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
|
| SQLState |
42000
|
| StackTrace |
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:839)
at coldfusion.sql.Executive.executeQuery(Executive.java:1249)
at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
84
|
| RAW_TRACE |
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
42
|
| RAW_TRACE |
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
24
|
| RAW_TRACE |
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
19
|
| RAW_TRACE |
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm
|
| TYPE |
CFML
|
|
|
| Type |
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
|
|
| DataSource |
web
|
| Detail |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
|
| ErrorCode |
42000
|
| Message |
Error Executing Database Query.
|
| NativeErrorCode |
1064
|
| RootCause |
| struct |
|---|
| ErrorCode |
1064
|
| Message |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
|
| SQLState |
42000
|
| StackTrace |
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:839)
at coldfusion.sql.Executive.executeQuery(Executive.java:1249)
at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
84
|
| RAW_TRACE |
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
42
|
| RAW_TRACE |
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
24
|
| RAW_TRACE |
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
19
|
| RAW_TRACE |
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm
|
| TYPE |
CFML
|
|
|
| Type |
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
|
|
| SQLState |
42000
|
| Sql |
SELECT pk_gcs1_id as id,
CASE g.fk_site_id WHEN (param 1) THEN IFNULL(title_offe,(select title_offe from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) ELSE IFNULL(IFNULL(alt_title_offe,title_offe),(select title_offe from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) END as title,
IFNULL(abstract1,(select abstract1 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as abstract1,
IFNULL(abstract2,(select abstract2 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as abstract2,
IFNULL(text1,(select text1 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as text1,
IFNULL(text2,(select text2 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as text2,
IFNULL(text3,(select text3 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as text3,
IFNULL(text4,(select text4 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as text4,
IFNULL(text5,(select text5 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as text5,
IFNULL(alt_text1,(select alt_text1 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as alt_text1,
IFNULL(alt_text2,(select alt_text2 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as alt_text2,
IFNULL(booking_info,(select booking_info from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as booking_info,
IFNULL(place,(select place from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as place,
CASE g.fk_site_id WHEN (param 2) THEN IFNULL(dropdown,(select dropdown from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) ELSE IFNULL(IFNULL(alt_dropdown,dropdown),(select dropdown from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) END as dropdown,
IFNULL(address,(select address from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as address,
IFNULL(img_overal,(select img_overal from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as image1,
IFNULL(img_overal_legend,(select img_overal_legend from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as legend1,
IFNULL(img_detail,(select img_detail from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as image2,
IFNULL(img_detail_legend,(select img_detail_legend from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as legend2,
IFNULL(img_logo1,(select img_logo1 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as img_logo1,
IFNULL(img_logo2,(select img_logo2 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as img_logo2,
IFNULL(url_logo,(select url_logo from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as url1_logo,
IFNULL(url2_logo,(select url2_logo from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as url2_logo,
IFNULL(url,(select url from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) as url1,
IFNULL(url_text,(select url_text from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) url1_text,
IFNULL(url2,(select url2 from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) url2,
IFNULL(url2_text,(select url2_text from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) url2_text,
IFNULL(info_sdm,(select info_sdm from gcs_detail d where d.fk_lang_id = g.fk_dflt_lang_id and d.fk_gcs1_id = g.pk_gcs1_id and (d.deleted is null or d.deleted != 1))) info_sdm,
g.sortorder,
g.disable_dropdown,
g.nonbookable,
g.sdm_regions,
g.sdm_channels,
g.navcode as subcat,
g.fk_gcs_templates_id as templatesID,
(select gt.datei as template from gcs_templates gt where gt.pk_gcs_templates_id = g.fk_gcs_templates_id) as template,
g.orig_id as flashteaserID,
IFNULL(gd.meta_title, gd.title_offe) as meta_title,
gd.meta_keywords as meta_keywords,
IFNULL(gd.meta_description, gd.abstract2) as meta_description
FROM gcs_1 g
inner join gcs_detail gd on gd.fk_gcs1_id = g.pk_gcs1_id
inner join gcs_sites_gcs1_rel gs1r on gs1r.fk_gcs1_id = g.pk_gcs1_id
WHERE
AND gd.fk_lang_id = (param 3) AND g.fk_gcs_type_id = (param 4)
AND g.visible = 1
AND gd.visible = 1
AND (gd.deleted is null or gd.deleted != 1)
and gs1r.fk_site_id = (param 5)
and gs1r.visible=1
and (g.deleted is null or g.deleted != 1)
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583)
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:839)
at coldfusion.sql.Executive.executeQuery(Executive.java:1249)
at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
... 53 more
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
84
|
| RAW_TRACE |
at cfgcs_12ecfc573872848$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc:84)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_1.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
42
|
| RAW_TRACE |
at cfgcs_object2ecfc1943782466$funcINIT.runFunction(/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc:42)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/cfc/v1/core/gcs_object.cfc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
24
|
| RAW_TRACE |
at cfspecials_list2ecfm1100442788.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm:24)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials_list.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
19
|
| RAW_TRACE |
at cfspecials2ecfm750179610.runPage(/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm:19)
|
| TEMPLATE |
/var/www/web/myswitzerland.com/sites/graubuenden/html/specials.cfm
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gd.fk_lang_id = 2 AND g.fk_gcs_type_id = 4
AND g.visible = 1
AND' at line 43
|
| where |
(param 1) = [type='IN', class='java.lang.Integer', value='43', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='43', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='4', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='43', sqltype='cf_sql_integer']
|
|
