| struct |
|---|
| Browser |
Archive Team
|
| DateTime |
{ts '2020-12-30 15:07:50'}
|
| Diagnostics |
Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48 <br>The error occurred on line 43.
|
| GeneratedContent |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN" "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="http://rdf.data-vocabulary.org/#">
<head>
<!-- Hotjar Tracking Code for www.evoluzioniweb.it -->
<script>
(function(h,o,t,j,a,r){
h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};
h._hjSettings={hjid:1226680,hjsv:6};
a=o.getElementsByTagName('head')[0];
r=o.createElement('script');r.async=1;
r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;
a.appendChild(r);
})(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');
</script>
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, minimum-scale=0, maximum-scale=1.0">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8" />
<title></title>
<meta name="description" content="" />
<meta name="keywords" content="" />
<meta property="og:title" content="" />
<meta property="og:type" content="website" />
<meta property="og:site_name" content="www.compracomodo.it" />
<meta property="og:description" content="" />
<meta property="og:url" content="http://www.compracomodo.it/Inside.cfm?lingua=IT&url_rew=I_nostri_Prodotti&codcatoggetto=Elettronica_informatica&cat2=accessori_donna&cat3=Cinture&mod=elenco" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<link rel="stylesheet" type="text/css" href="http://www.gecosra.eu/Assets/Styles/Style31.css" media="screen" />
<link rel="stylesheet" type="text/css" href="http://www.gecosra.eu/Assets/Styles/Style31_print.css" media="print" />
<link rel="stylesheet" href="http://www.gecosra.eu/Assets/JS/EGSharePage.css" />
<link rel="alternate" type="application/rss+xml" title="RSS" href="http://www.gecosra.eu/Assets/Rss/rss.xml" />
<link href='http://fonts.googleapis.com/css?family=Lato' rel='stylesheet' type='text/css'>
<link rel="shortcut icon" type="images/x-icon" href="http://www.gecosra.eu/Assets/Images31/favicon.ico" />
<script type="text/javascript">
function Popup(urlpagina,nomepagina,parametripagina)
{
window.open(urlpagina,nomepagina,parametripagina);
}
</script>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id="></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', '');
ga('require', 'ec');
</script>
<script data-cfasync="false" type="text/javascript">
var gtm4wp_datalayer_name = "dataLayer";
var dataLayer = dataLayer || [];
</script>
<script type="text/javascript">
window.onbeforeunload = function(){
document.cookie='accettato_uso_cookie=1;expires=never;path=/' ;
document.getElementById('htmlbox_div1').style.display='none';
}
</script>
<!-- Facebook Pixel Code -->
<script>
!function(f,b,e,v,n,t,s)
{if(f.fbq)return;n=f.fbq=function(){n.callMethod?
n.callMethod.apply(n,arguments):n.queue.push(arguments)};
if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';
n.queue=[];t=b.createElement(e);t.async=!0;
t.src=v;s=b.getElementsByTagName(e)[0];
s.parentNode.insertBefore(t,s)}(window, document,'script',
'https://connect.facebook.net/en_US/fbevents.js');
fbq('init', '416218792255538');
fbq('track', 'PageView');
</script>
<noscript><img height="1" width="1" style="display:none"
src="https://www.facebook.com/tr?id=416218792255538&ev=PageView&noscript=1"
/></noscript>
<!-- End Facebook Pixel Code -->
</head> <body >
<!-- Google Tag Manager (noscript) -->
<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-KHXX44N"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<!-- End Google Tag Manager (noscript) -->
<div id="htmlboxBG" class="htmlboxBG" style="display: none;"></div>
<script type="text/javascript">
function AccettaCookie() {
document.cookie='accettato_uso_cookie=1;expires=never;path=/' ;
document.getElementById('htmlbox_div1').style.display='none';
if (document.getElementById('adsense1') != null)
{
document.getElementById('adsense1').style.display='block';
}
if (document.getElementById('adsense2') != null)
{
document.getElementById('adsense2').style.display='block';
}
if (document.getElementById('adsense3') != null)
{
document.getElementById('adsense3').style.display='block';
}
if (document.getElementById('adsense4') != null)
{
document.getElementById('adsense4').style.display='block';
}
if (document.getElementById('adsense5') != null)
{
document.getElementById('adsense5').style.display='block';
}
if (document.getElementById('adsense6') != null)
{
document.getElementById('adsense6').style.display='block';
}
if (document.getElementById('adsense7') != null)
{
document.getElementById('adsense7').style.display='block';
}
if (document.getElementById('adsense8') != null)
{
document.getElementById('adsense8').style.display='block';
}
};
</script>
<div id="htmlbox_div1" class="htmlbox_content2" style="display: block;">
QUESTO SITO UTILIZZA ALCUNI 'COOKIE': <a href="/IT/Cookies"
style="text-decoration:underline">VUOI SAPERNE DI PIU'?</a> <button
type="button" class="boxlogin_b" onclick="AccettaCookie();" style="margin-top:
8px;">Accetta</button>
</div>
<div id="container">
<div id="header">
<div id="blocco_top_bg">
<div id="menutopborder2">
<div id="w_menutop2">
<div id="menutop">
<ul style=" " class="topnav" id="myTopnav">
<li class="menu_home">
<a href="http://www.gecosra.eu" class="a1-mt">Home</a></td>
</li>
<li>
<div id="menuprinc1">
<a href="/IT/chi_siamo" class="a1-mt" title="CHI SIAMO">
CHI SIAMO
</a>
</div>
</li>
<li>
<div id="menuprinc2">
<a href="/IT/NOVITA" class="a1-mt" title="NOVITA">
NOVITA
</a>
</div>
</li>
<li>
<div id="menuprinc3">
<a href="/IT/I_nostri_Prodotti" class="a1-mt-sel" title="PRODOTTI">
Prodotti
</a>
</div>
</li>
<li>
<div id="menuprinc4">
<a href="/IT/Promozioni" class="a1-mt" title="PROMOZIONI">
Promozioni
</a>
</div>
</li>
<li>
<div id="menuprinc5">
<a href="/IT/Outlet" class="a1-mt" title="OUTLET">
Outlet
</a>
</div>
</li>
<li class="icon">
<a href="javascript:void(0);" style="font-size:15px;" onclick="myFunction()">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
</li>
</ul>
</div>
</div>
</div>
<div id="blocco_top">
<div id="top_menu">
<a href="/Inside.cfm?url_rew=Registrazione"><img src="http://www.gecosra.eu/Assets/Images31/Registrati.jpg" style="float:left; display:none" alt="Registrati" title="Registrati" /></a>
<div id="top_box_menu_icone"><img src="http://www.gecosra.eu/Assets/Images31/icone_top.png" alt="Pagamento Sicuro - Reso Facile - Spedizione Gratuita" title="Pagamento Sicuro - Reso Facile - Spedizione Gratuita" /></div>
<div id="top_box_menu_icone_mobile"><img src="http://www.gecosra.eu/Assets/Images31/icone_top_size.png" alt="Pagamento Sicuro - Reso Facile - Spedizione Gratuita" title="Pagamento Sicuro - Reso Facile - Spedizione Gratuita" /></div>
<div id= "Box_icone_accesso">
<div id="top_box_menu_login">
<div id="boxloginpopup" style="display: none; margin-top:0px; z-index:100; margin-left: 0px" onClick="document.getElementById('boxloginpopup').style.display='block';" onMouseOver="document.getElementById('boxloginpopup').style.display='block';" onMouseOut="document.getElementById('boxloginpopup').style.display='none';">
<div id="boxlogin">
<!--<div class="tb-ml-tit">Accedi</div> --> <form action="http://www.gecosra.eu/Default.cfm" method="post" id="login">
<div>
<span style="float:left">Email </span>
<input name="user" type="text" value="" style=" " /><br /> <span style="float:left">Password </span>
<input name="pwd" type="password" value="" style=""/><br />
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<div style="text-align:left; font-size:10px; width:100px;">
<a href="http://www.gecosra.eu/Inside.cfm?url_rew=Registrazione&step=persopwd" title="Perso password?" class="boxlogin_t1">Perso password?</a><br />
<a href="http://www.gecosra.eu/Inside.cfm?url_rew=Registrazione" title="Registrati" class="boxlogin_t1">Registrati</a>
</div></td>
<td>
<button type="submit" value="Accedi" name="login" title="Accedi" style="margin-top:5px; float:right">Accedi</button>
</td>
</tr>
</table>
</div>
</form>
</div>
</div>
<a onClick="document.getElementById('boxloginpopup').style.display='block';" onMouseOver="document.getElementById('boxloginpopup').style.display='block';" onMouseOut="document.getElementById('boxloginpopup').style.display='none';">
<img src="http://www.gecosra.eu/Assets/Images31/Registrati.jpg" alt="Login" title="Login" /><span class="displayNo"><p style="margin:0px;">Accedi</p></span>
</a>
</div>
<div id="top_box_menu_carrello">
<div style="margin-top:0px; z-index:100; margin-left: 0px" onClick="document.getElementById('boxcarrellopopup').style.display='block';" onMouseOver="document.getElementById('boxcarrellopopup').style.display='block';" onMouseOut="document.getElementById('boxcarrellopopup').style.display='none';">
<a href="http://test-compracomodo.evoluzioniweb.it//IT/Carrello" onMouseOver="document.getElementById('boxcarrellopopup').style.display='block';" onMouseOut="document.getElementById('boxcarrellopopup').style.display='none';" >
<img src="http://www.gecosra.eu/Assets/Images31/carrello_2.jpg" style="border:0" alt="Carrello" title="Carrello" /><span class="displayNo"><p style="margin:0px;">Carrello</p></span>
</a>
<div id="boxcarrellopopup" onClick="document.location.href='http://test-compracomodo.evoluzioniweb.it//IT/Carrello';" onMouseOver="document.getElementById('boxcarrellopopup').style.display='block';" onMouseOut="document.getElementById('boxcarrellopopup').style.display='none';">
<div id="boxcarrello">
<span style="float:left">Il tuo carrello contiene</span><br /><br />
<div class="t_carrello">
<!--Contiene <br /> -->
<strong>
<div style="width:120px; float:left">Articoli</div><div style="float:right">0</div></strong>
<strong><div style="width:120px; float:left">Totale carrello</div><div style="float:right">0,00</div> </strong><br />
</div>
<div class="bottone_carrello">
<a href="http://test-compracomodo.evoluzioniweb.it//IT/Carrello" style="color:#FFF" >vai al carrello</a>
</div>
</div>
</div>
</div>
</div>
<a href="/IT/Condizioni_Vendita"><img src="http://www.gecosra.eu/Assets/Images31/CondizionidiVendita2.jpg" /><span class="displayNo" style="float:left ; margin-right: 20px;"><p style="margin:0px;">Condizioni di vendita</p></span></a>
<a href="/IT/Contatti"><img src="http://www.gecosra.eu/Assets/Images31/Contatti.jpg"style="position: relative; margin-right: 10px;" /><span class="displayNo" style="float:left"><p style="margin:0px;">Contatti</p></span></a>
</div>
</div>
</div>
</div>
</div>
<div id="max-width">
<div id="logo">
<a href="http://www.gecosra.eu">
<img src="http://www.gecosra.eu/Assets/Public/18/logo/Logo_EvoluzioniWeb.jpg" alt="Evoluzioni Web" title="Evoluzioni Web" style="max-height: 230px; margin-top:15px;" />
</a>
</div>
<div id="boxsocial">
<div class="torna_voucher"><a href="http://test-compracomodo.evoluzioniweb.it/" title="Torna al COMPRA COMODO"><img src="http://www.gecosra.eu/Assets/Images31/TornaCompracomodo.jpg" style="border:0px; width:100%" alt="Torna al COMPRA COMODO" title="Torna al COMPRA COMODO" /></a></div>
<script type="text/Javascript">
function pulisciboxric()
{
document.getElementById('searchdesc').testo.value='';
}
</script>
<div id="boxsearch">
<form id="searchdesc" method="get" action="/Inside.cfm" style="float:right; width:100%">
<div>
<input type="hidden" value="RICERCA" name="area" />
<input type="hidden" value="RICERCA" name="sezione" />
<input type="hidden" value="RICERCA" name="URL_REW" />
<!--Cerca -->
<div id="Box_search_top">
<select name="categorie">
<option value="">Categorie:</option>
<optgroup label="Elettronica e Informatica">
<option value="27" >Audio</option>
</optgroup>
<optgroup label="Moda">
<option value="295" >Accessori Donna</option>
</optgroup>
</select>
<input type="text" value="" placeholder="Cosa stai cercando?" name="testo" onclick="javascript:pulisciboxric(testo);" style="border:0px" />
<a href="javascript://" onclick="document.getElementById('searchdesc').submit();"><img src="http://www.gecosra.eu/Assets/Images31/lente.jpg" style="border:0px;" alt="cerca" title="cerca" /></a>
</div>
</div>
</form>
</div>
</div>
</div>
<div id="menutopborder">
<div id="w_menutop">
<div id="menutop">
<ul style=" " class="topnav" id="myTopnav">
<li class="menu_home">
<a href="http://www.gecosra.eu" class="a1-mt">Home</a></td>
</li>
<li>
<div id="menuprinc1">
<a href="/IT/chi_siamo" class="a1-mt" title="CHI SIAMO">
CHI SIAMO
</a>
</div>
</li>
<li>
<div id="menuprinc2">
<a href="/IT/NOVITA" class="a1-mt" title="NOVITA">
NOVITA
</a>
</div>
</li>
<li>
<div id="menuprinc3">
<a href="/IT/I_nostri_Prodotti" class="a1-mt-sel" title="PRODOTTI">
Prodotti
</a>
</div>
</li>
<li>
<div id="menuprinc4">
<a href="/IT/Promozioni" class="a1-mt" title="PROMOZIONI">
Promozioni
</a>
</div>
</li>
<li>
<div id="menuprinc5">
<a href="/IT/Outlet" class="a1-mt" title="OUTLET">
Outlet
</a>
</div>
</li>
<li class="icon">
<a href="javascript:void(0);" style="font-size:15px;" onclick="myFunction()">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
</li>
</ul>
</div>
</div>
</div>
<div id="boxmain">
<div id="boxmain2">
<div id="categorie2">
<div id="menuleftcategorie">
<div id="categorie_border">
<style>
.credits_text span {display:none;margin-top: -24px; background-color: #ebebeb;}
.credits_text:hover span {display:block; background-color: #f6f3d2; position:absolute; z-index:1; width:215px;}
</style>
<div style="text-transform:uppercase; line-height:35px">
<div style="display:none;">
<script type="text/javascript">
function aprichiudi(item,descrizione) {
elem=document.getElementById(item);
visibile=(elem.style.display!="none")
prefisso=document.getElementById("menu" + item);
if (visibile) {
elem.style.display="none";
prefisso.innerHTML=descrizione;
} else {
elem.style.display="";
prefisso.innerHTML=descrizione;
}
}
</script>
</div>
<div id="desktop-cat" style="padding:20px;">
<a id="menucat2" href="/IT/I_nostri_Prodotti/Elettronica_informatica" onclick="aprichiudi('cat2','Elettronica e Informatica');" class="cat-t1-on">Elettronica e Informatica</a>
<br />
<div style="margin-left:10px;">
<a href="/IT/I_nostri_Prodotti/Elettronica_informatica/Audio" onclick="aprichiudi('cat27','v Audio');" class="cat-t2"><span> Audio</span></a>
</div>
<a id="menucat1" href="/IT/I_nostri_Prodotti/Moda" onclick="aprichiudi('cat1','Moda');" class="cat-t1">Moda</a>
<br />
</div>
<div id="mobile-cat" style="display:none;padding:0px;">
<strong>Categoria</strong><br />
<select name="catpadre" onchange="document.location.href='/IT/I_nostri_Prodotti/'+this.value;" style="width:100%;">
<option value="Elettronica_informatica/Audio">Audio</option>
</optgroup>
<option value="Moda">Moda</option>
</select>
</div>
</div>
<div id="filtro_colore">
|
| HTTPReferer |
https://www.gecosra.eu/IT/I_nostri_Prodotti/Elettronica_informatica/accessori_donna/Cinture/sito
|
| Mailto |
[empty string]
|
| Message |
Error Executing Database Query.
|
| QueryString |
lingua=IT&url_rew=I_nostri_Prodotti&codcatoggetto=Elettronica_informatica&cat2=accessori_donna&cat3=Cinture&mod=elenco
|
| RemoteAddress |
135.181.107.81
|
| RootCause |
| struct |
|---|
| Cause |
| struct |
|---|
| ErrorCode |
1064
|
| Message |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
|
| SQLState |
42000
|
| StackTrace |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
at sun.reflect.GeneratedConstructorAccessor1110.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
43
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SELOGGETTI
|
| LINE |
1
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
372
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SUBMENUCATEGORIE
|
| LINE |
1
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
59
|
| RAW_TRACE |
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Inside.cfm
|
| TYPE |
CFML
|
|
|
| Type |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
|
|
| DataSource |
compracomodo_TEST
|
| Detail |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
|
| ErrorCode |
42000
|
| Exceptions |
| array
|
|---|
| 1 |
| struct |
|---|
| class |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
|
| message |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
|
|
|
| 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 MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
|
| SQLState |
42000
|
| StackTrace |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
at sun.reflect.GeneratedConstructorAccessor1110.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
43
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SELOGGETTI
|
| LINE |
1
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
372
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SUBMENUCATEGORIE
|
| LINE |
1
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
59
|
| RAW_TRACE |
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Inside.cfm
|
| TYPE |
CFML
|
|
|
| Type |
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
|
|
| SQLState |
42000
|
| Sql |
SELECT
min(prodotti.prezzo) as prezzomin, max(prodotti.prezzo) as prezzomax,
min(prodotti.prezzo_offerta) as prezzooffmin, max(prodotti.prezzo_offerta) as prezzooffmax,
((prodotti.prezzo-(prodotti.prezzo*sconto_perc/100))+((prodotti.prezzo-(prodotti.prezzo*sconto_perc/100)))) as prezzoscontivagen
,((prodotti.prezzo-(prodotti.prezzo*sconto_perc/100))+((prodotti.prezzo-(prodotti.prezzo*sconto_perc/100)))) as prezzoscontivadet
,prodotti.*, aziende.titolo as titpartner,aziende.ecommerce,aziende.via,aziende.cap,aziende.citta,aziende.provincia,
aziende.dominio,aziende.telefono,aziende.latitudine,aziende.longitudine,aziende.latitudine2,aziende.longitudine2,aziende.latitudine3,aziende.longitudine3,aziende.latitudine4,aziende.longitudine4,aziende.latitudine5,aziende.longitudine5,titololatlong1,titololatlong2,titololatlong3,titololatlong4,titololatlong5,zoom
, a.url_rew as url1,b.url_rew as url2,c.url_rew as url3
, a.titolo as tit1,b.titolo as tit2,c.titolo as tit3
,parametri_aziende.prodotti_senza_prezzo
FROM prodotti
inner join aziende on
prodotti.cod_azienda = aziende.cod and aziende.visualizza = 1
left outer join parametri_aziende on
prodotti.cod_azienda = parametri_aziende.cod_azienda
and parametri_aziende.cod_azienda = 18
left outer join categorie a on
prodotti.cat1 = a.cod
and prodotti.lingua = a.lingua
and a.oggetto = 'Prodotti'
left outer join categorie b on
prodotti.cat2 = b.cod
and prodotti.lingua = b.lingua
and b.oggetto = 'Prodotti'
left outer join categorie c on
prodotti.cat3 = c.cod
and prodotti.lingua = c.lingua
and c.oggetto = 'Prodotti'
left outer join disponibilita on
prodotti.cod = disponibilita.cod_prodotto
left outer join
colori on
disponibilita.cod_colore = colori.cod
left outer join
taglie on
disponibilita.cod_taglia = taglie.cod
WHERE
prodotti.VISUALIZZA = 1 and prodotti.lingua = 'IT'
AND cancellato = '0'
AND prodotti.cod in (select cod_oggetto from categorie_oggetti where cod_categoria in ())
and prodotti.cod_azienda = 18
and prodotti.outlet = 0
and( data_scadenza_attiva = '0' or (data_scadenza_attiva = '1' and data_scadenza >= now()))
and acquistabile = '1' and prodotti.prezzo > 0.00
group by prodotti.cod
ORDER BY
ordine,rand()
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
at sun.reflect.GeneratedConstructorAccessor1110.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
... 53 more
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
43
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SELOGGETTI
|
| LINE |
1
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
372
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SUBMENUCATEGORIE
|
| LINE |
1
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
59
|
| RAW_TRACE |
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Inside.cfm
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
|
| where |
[empty string]
|
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
and prodotti.cod_azienda = 18
and prodo' at line 48
at sun.reflect.GeneratedConstructorAccessor1110.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
... 53 more
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
43
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516._factor19(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:43)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SELOGGETTI
|
| LINE |
1
|
| RAW_TRACE |
at cfSelOggetti2ecfm1580059516.runPage(/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Query/Prodotti/SelOggetti.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
372
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543._factor8(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:372)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_SUBMENUCATEGORIE
|
| LINE |
1
|
| RAW_TRACE |
at cfSubMenuCategorie2ecfm1243108543.runPage(/var/www/html/compracomodo/test/SubMenuCategorie.cfm:1)
|
| TEMPLATE |
/var/www/html/compracomodo/test/SubMenuCategorie.cfm
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
59
|
| RAW_TRACE |
at cfInside2ecfm96007452.runPage(/var/www/html/compracomodo/test/Inside.cfm:59)
|
| TEMPLATE |
/var/www/html/compracomodo/test/Inside.cfm
|
| TYPE |
CFML
|
|
|
| Template |
/Inside.cfm
|
| Type |
coldfusion.runtime.CfErrorWrapper
|
