******** ERROR api_reporte.onopen(1)
java.lang.Exception: ERROR reportes4/api_reporte:api_reporte.onopen(1) i2: java.sql.SQLException: SELECT dias.dia,
(select sum(total) from events where etype = 'updatemessage'
and date(moment) = dias.dia
and ('$idenvio' = '' or id1 = '$idenvio')
) as cantidad FROM dias WHERE dias.dia between date_add(current_date(), interval -14 day) and current_date() AND () ORDER BY dias.dia LIMIT 2000
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 ') ORDER BY dias.dia LIMIT 2000' at line 5

java.sql.SQLException: SELECT dias.dia,
(select sum(total) from events where etype = 'updatemessage'
and date(moment) = dias.dia
and ('$idenvio' = '' or id1 = '$idenvio')
) as cantidad FROM dias WHERE dias.dia between date_add(current_date(), interval -14 day) and current_date() AND () ORDER BY dias.dia LIMIT 2000
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 ') ORDER BY dias.dia LIMIT 2000' at line 5

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:193)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:128)
	at flexa.fb.LibDb.sqltoarray(LibDb.java:205)
	at flexa.fb.LibDb.executeReport(LibDb.java:272)
	at flexa.fb.LibDb.call(LibDb.java:63)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:884)
	at flexa.fb.EFI.runBytecode(EFI.java:731)
	at flexa.fb.FComponent.event(FComponent.java:691)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:716)
	at flexa.fb.CompManager.processAction(CompManager.java:757)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:476)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:167)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:676)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:829)

	at flexa.fb.EFI.runBytecode(EFI.java:1139)
	at flexa.fb.EFI.runBytecode(EFI.java:731)
	at flexa.fb.FComponent.event(FComponent.java:691)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:716)
	at flexa.fb.CompManager.processAction(CompManager.java:757)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:476)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:167)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:676)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:829)


CONTEXT:
_module=reportes4  <i><small>String</small></i>
<b>component</b>


<b>request_</b>
     _c=reportes4/api_reporte  <i><small>String</small></i>
     _ip=127.0.0.1  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _sessionid=e5c76ofLpqK8rn5SlR1P  <i><small>String</small></i>
     _servername=66.97.46.32  <i><small>String</small></i>
     id=490  <i><small>String</small></i>
     _url=http://66.97.46.32/app/  <i><small>String</small></i>
     idenvio=10.005.177  <i><small>String</small></i>


<b><red>u_</red></b>


<b><red>s_</red></b>


<b><red>g_</red></b>
     g_base=http://66.97.46.32  <i><small>String</small></i>
     g_sidebarbgcolor=#ccc  <i><small>String</small></i>
     g_estilosadicionales=null
     _e=uv1066_quartier  <i><small>String</small></i>
     g_sidebarcolor=#fff  <i><small>String</small></i>
     g_sidebarposition=Nuevo  <i><small>String</small></i>