Lucee 6.0.1.83 Error (database) |
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 '[news] where id_arg IN ('1153')' at line 1 |
SQL |
SELECT * FROM [news] where id_arg IN ('1153') |
DatabaseName |
MySQL |
DatabaseVersion |
5.6.51 |
DriverName |
MySQL Connector/J |
DriverVersion |
mysql-connector-j-8.1.0 (Revision: 7b6f9a337afe6ccb41823df485bf848ca7952b09) |
Datasource |
new_confcommerciosicilia.it |
Stacktrace |
The Error Occurred in
/var/www/vhosts/confcommercio.cl.it/httpdocs/template/cl/riqrelated.cfm: line 3
1: <cfparam name=qryorigineR default="qrynews"><cfoutput><cfif evaluate('#qryorigineR#.doccorrelati') neq "">
2: <CFQUERY NAME="related" DATASOURCE="#nomedatasource#">SELECT * FROM [news] where id_arg IN (#ListQualify(evaluate(qryorigineR&'.doccorrelati'), "'")#)
3: </CFQUERY>
4: <cfif related.recordcount gt 0>
5: <span class="menudx">Documenti Correlati</span>
called from /var/www/vhosts/confcommercio.cl.it/httpdocs/template/cl/ita_news.cfm: line 21
19: <cfif qrynews.immagine neq ""><img src="#base_URL#foto/big/#qrynews.immagine#" hspace="7" vspace="3" align="#lato#" border=0></cfif><span class=corpobold><cfif qrynews.citta neq"">#qrynews.citta#, </cfif>#right(qrynews.data,2)#/#mid(qrynews.data,5,2)#/#left(qrynews.data,4)#</span> - #qrynews.descrizione#<br>
20: </p>
21: <cfif qrynews.doccorrelati neq ""><cfinclude template="riqrelated.cfm"><br></cfif>
22: <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign=middle width=20 align=left><a href="#livello#printpdf.cfm?idnews=#qrynews.id_arg#" onMouseOver="window.status='Apri Pdf'; return true;" class=corpo target="_new"><img src="#livello#pics/01/printpdf.gif" border=0 alt="visualizza la news stampabile in PDF" width=16 height=16></a></td><td align=left valign=middle><a href="#livello#printpdf.cfm?idnews=#qrynews.id_arg#" onMouseOver="window.status='Apri Pdf'; return true;" class=corpo target="_new">Versione PDF stampabile</a></td><td align=right><a href="javascript:history.back()" class=corpobold>Indietro</td></tr></table>
23: </td>
called from /var/www/vhosts/confcommercio.cl.it/httpdocs/template/mastercl.cfm: line 157
155:
156: <tr>
157: <td><cftry><cfinclude template="#w3azienda#/#lang#_#nometemplate#"><cfcatch type="missingInclude"><table width="100%" border="0" cellspacing="40" cellpadding="0">
158: <tr>
159: <td><p class="titolo"><cfif headtitolo neq ""><h1 class=titoloh1>#Headtitolo#</h1></cfif><br><div align=justify class=corpo><cfif isdefined('pagecontents') and pagecontents.recordcount is 1><cfif pagecontents.descrizione neq "">#pagecontents.descrizione#<cfelse>#headdescription#</cfif><cfelse>#headdescription#</cfif></p>
called from /var/www/vhosts/confcommercio.cl.it/httpdocs/news/index.cfm: line 29
27:
28: <cfset nometemplate="news.cfm">
29: <cfinclude template="#livello#template/master#w3azienda#.cfm">
30:
31:
|
Java Stacktrace |
lucee.runtime.exp.DatabaseException: 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 '[news] where id_arg IN ('1153')' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:297) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1130) at lucee.runtime.tag.Query._doEndTag(Query.java:697) at lucee.runtime.tag.Query.doEndTag(Query.java:562) at template.cl.riqrelated_cfm$cf.call(/template/cl/riqrelated.cfm:3) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:932) at template.cl.ita_news_cfm$cf.call(/template/cl/ita_news.cfm:21) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:932) at template.mastercl_cfm$cf.call(/template/mastercl.cfm:157) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:932) at news.index_cfm$cf.call(/news/index.cfm:29) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:65) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2715) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2701) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2672) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1259) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1205) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) |
Timestamp |
29/03/24 10:16:10 CET
|