******** ERROR mascotadesktop.onopen(-1)
SQL Error: select id as idmascota,tipo,nombre,raza,sexomascota,color,unidad,alquiler,estado from icmascota where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icmascota' doesn't exist
 SQLSTATE 42S02

******** ERROR alquileresproximosmobile0.visiblecondition(2)
java.lang.Exception: ERROR unidades4/verunidad:alquileresproximosmobile0.visiblecondition(2) i5: java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Pendiente' and contratodesde > current_date()
Table 'uv1066_quartier.icalquileres' doesn't exist

java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Pendiente' and contratodesde > current_date()
Table 'uv1066_quartier.icalquileres' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR datoscontactos22.onopen(-1)
SQL Error: select id as idautorizacion,
    tipodoc as tipodocaut,
    numerodoc as numdocaut,
    nombre as nombreaut,
    apellido as apellidoaut,
    unidad as unidadaut,
    desde as desdeaut,
    hasta as hastaaut,
    tipovisita as tipoaut,
    mail as mailaut,
    telefono as telefonoaut
    from icingreso
    where unidad = '' 
    and hasta >= CURRENT_DATE()
Table 'uv1066_quartier.icingreso' doesn't exist
 SQLSTATE 42S02

******** ERROR panelvehiculosdesktop.badge(1)
java.lang.Exception: ERROR unidades4/verunidad:panelvehiculosdesktop.badge(1) i6: java.sql.SQLException: select count(*) from icrelveh where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icrelveh' doesn't exist

java.sql.SQLException: select count(*) from icrelveh where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icrelveh' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR datosresidente4.onopen(-1)
SQL Error: select 
    cmcont.id as idcontacto, 
    cmcont.tipodoc, 
    cmcont.numdoc, 
    cmcont.nombre, 
    cmcont.apellido, 
    icrel.id as idrel,
    
    icrel.perfil, 
    cmcont.mail, 
    cmcont.mail2, 
    cmcont.telefono, 
    cmcont.telefono2, 
    cmcont.fechanac,
   
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella, 
    cmcont.facephoto, 
    cmcont.ultimoingreso,   
   CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad,  
    icrel.estado as icestado,
    icrel.tipo as ictipo,
    (select id from icalquileres where estado = 'Activo' and unidad = '')as alquiler
    
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and (icrel.tipo = 'Residente' or icrel.tipo = 'habitante')
    and icrel.estado = 'Activo'
    /**
    and (icrel.alquiler is Null or icrel.alquiler = 0 or icrel.alquiler in (select id from icalquileres where estado = 'Activo' and unidad = ''))
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro') 
    **/
order by 
    icrel.id
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR cuentacorrientetabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = ''
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL  DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = '',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    '' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = ''
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = ''
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
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 ')
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dia' at line 34
 SQLSTATE 42000

******** ERROR alquilerpendientemobile0.visiblecondition(2)
java.lang.Exception: ERROR unidades4/verunidad:alquilerpendientemobile0.visiblecondition(2) i5: java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Pendiente' and current_date() between contratodesde and contratohasta
Table 'uv1066_quartier.icalquileres' doesn't exist

java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Pendiente' and current_date() between contratodesde and contratohasta
Table 'uv1066_quartier.icalquileres' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR mascotasdesktop.badge(1)
java.lang.Exception: ERROR unidades4/verunidad:mascotasdesktop.badge(1) i6: java.sql.SQLException: select count(*) from icmascota where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icmascota' doesn't exist

java.sql.SQLException: select count(*) from icmascota where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icmascota' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR vehiculosninguno.visiblecondition(2)
java.lang.Exception: ERROR unidades4/verunidad:vehiculosninguno.visiblecondition(2) i5: java.sql.SQLException: select count(*) from icrelveh where unidad = '' and estado = 'Activo' 
Table 'uv1066_quartier.icrelveh' doesn't exist

java.sql.SQLException: select count(*) from icrelveh where unidad = '' and estado = 'Activo' 
Table 'uv1066_quartier.icrelveh' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR datosservicios5.onopen(-1)
SQL Error: select 
    cmcont.id as idcontacto, 
    cmcont.tipodoc, 
    cmcont.numdoc, 
    cmcont.nombre, 
    cmcont.apellido, 
    icrel.id as idrel,
    
    icrel.perfil, 
    cmcont.mail, 
    cmcont.mail2, 
    cmcont.telefono, 
    cmcont.telefono2, 
    cmcont.fechanac,
   
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella, 
    cmcont.facephoto, 
    cmcont.ultimoingreso,   
    CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad, 
    icrel.estado as icestado,
    icrel.tipo as ictipo,
    (select id from icalquileres where estado = 'Activo' and unidad = '' and current_date() between icrel.desde and icrel.hasta) as alquiler
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and icrel.tipo = 'Servicio' 
    and icrel.estado = 'Activo'
    /**
    and ((icrel.alquiler is Null) OR icrel.alquiler = 0 OR icrel.alquiler in (select id from icalquileres where estado = 'Activo' and unidad = '')) 
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro') 
    **/
order by 
    icrel.id
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR datostitular3.onopen(-1)
SQL Error: select 
  cmcont.id as idcontacto, 
  cmcont.tipodoc, 
  cmcont.numdoc, 
  cmcont.nombre, 
  cmcont.apellido, 
  icrel.id as idrel,
    
 
    icrel.perfil, 
  cmcont.mail, 
  cmcont.mail2, 
  cmcont.telefono, 
  cmcont.telefono2, 
  cmcont.fechanac,

  
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella as huella, 
    cmcont.facephoto as desbfacial, 
    cmcont.ultimoingreso as ultimoing,    
   CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad, 
    icrel.estado as icestado,
    icrel.tipo as ictipo
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and icrel.Tipo = 'Titular' 
    and icrel.estado = 'Activo'
order by 
    icrel.id
Unknown column 'cmcont.huella' in 'field list'
 SQLSTATE 42S22

******** ERROR unnamed44.visiblecondition(2)
java.lang.Exception: ERROR unidades4/verunidad:unnamed44.visiblecondition(2) i5: java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icalquileres' doesn't exist

java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado = 'Activo'
Table 'uv1066_quartier.icalquileres' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR alquileractivomobile.onopen(-1)
SQL Error: select 
    id idalq, 
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino')) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id) cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion
from 
    icalquileres 
where 
    unidad = ''
    and estado = 'Activo'
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR unnamed162.onopen(-1)
SQL Error: select 
    id as idalq,
    tipoalquiler,
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino')) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id) cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion
from 
    icalquileres 
where 
    unidad = ''
    and estado = 'Pendiente'
    and contratodesde > current_date()
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR detallescontmobile223.onopen(-1)
SQL Error: select id as idvehiculo, tipo, marca, modelo, patente, color, cochera, poliza from icrelveh where unidad = '' and estado = 'Activo';
Table 'uv1066_quartier.icrelveh' doesn't exist
 SQLSTATE 42S02

******** ERROR datoscontactos2.onopen(-1)
SQL Error: select 
    cmcont.id as idcontacto, 
    cmcont.tipodoc, 
    cmcont.numdoc, 
    cmcont.nombre, 
    cmcont.apellido, 
    icrel.id as idrel,
   
    icrel.perfil, 
    cmcont.mail, 
    cmcont.mail2, 
    cmcont.telefono, 
    cmcont.telefono2, 
    cmcont.fechanac,
   
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella as huella, 
    cmcont.facephoto as desbfacial, 
    cmcont.ultimoingreso as ultimoing,
    CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad, 
    icrel.estado as icestado,
    icrel.tipo as ictipo
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and icrel.Tipo = 'Contacto principal' 
    and icrel.estado = 'Activo'
  
order by 
    icrel.id
Unknown column 'cmcont.huella' in 'field list'
 SQLSTATE 42S22

******** ERROR alquileresmobile.badge(1)
java.lang.Exception: ERROR unidades4/verunidad:alquileresmobile.badge(1) i6: java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado in ('Pendiente', 'Activo')
Table 'uv1066_quartier.icalquileres' doesn't exist

java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado in ('Pendiente', 'Activo')
Table 'uv1066_quartier.icalquileres' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR detallestabla.onopen(-1)
SQL Error: select 
    distinct u.denominacion as unidad, 
u.notas as notasunidad,
if(t.descripcion like '%cesion%', '', t.descripcion) as concepto, 
    t.importe * -1 as importe,
    t.saldo * -1 as saldo,
    t.moneda as moneda
    
from emdocobra d 
join emtransobra t on d.id = t.documento 
join ocomobra as o on d.ocom = o.id
join rcomobra as r on d.ocom = r.operacioncomercial
join Unidadesobra as u on r.unidadId = u.id
where
    o.estado not in ('Anulada', 'Inactiva')
and t.descripcion not like 'FR %' 
    and t.descripcion not like '%FR' 
    and t.descripcion != 'SALDO'
    /**and (t.descripcion in ('Gastos funcionamiento', 'Gastos de equipamiento', 'Ingresos Brutos') or t.descripcion like '%Posesi%')**/
    and if(t.contabilidad is null,t.contabilidad is null,t.contabilidad != 'G')
and d.tipo = 'ov'
and t.tipo = 'M'
    /**and t.moneda = 'ARS'**/
    /** mostrar todos los saldos
    and     
        if(''= 1, 
            t.vencimiento < date_add('', interval '' day),
            t.vencimiento < date_add(current_date(), interval '' day)
         )
    and (
        (abs(t.saldo) > 10 and t.moneda = 'ARS') 
        or (abs(t.saldo) > 1 and t.moneda = 'UVA') 
        or (abs(t.saldo) > 1 and t.moneda = 'USD')
        )
    **/
    and d.estado = '+Emitida'
    and d.empresa = (select empresa from uv1066_quartier.Emprendimientos where id = 'qbajo') 
    and t.estado != "ANULADA" 
    and t.estado != "Anulada" 
    and d.ocom in (select id from uv1066_quartier.ocom where estado !="ANULADA" and estado not like 'Reserva%' and estado not like 'Oferta%' /** and clase = 'Fiduciante A' **/)
    and u.tipou = 'D'    
    and u.denominacion = '1 RIO 5 6'
    
/** group by 2, t.vencimiento **/
order by 2,t.vencimiento,t.id
Table 'uv1066_quartier.emdocobra' doesn't exist
 SQLSTATE 42S02

******** ERROR unnamed16.onopen(-1)
SQL Error: select 
    id as idalq,
    tipoalquiler,
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino')) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id) cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion
from 
    icalquileres 
where 
    unidad = ''
    and estado = 'Pendiente'
    and current_date() between contratodesde and contratohasta
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR datosinquilino.onopen(-1)
SQL Error: select 
    cmcont.id as idcontacto, 
    cmcont.tipodoc, 
    cmcont.numdoc, 
    cmcont.nombre, 
    cmcont.apellido, 
    icrel.id as idrel,
   
    icrel.perfil, 
    cmcont.mail, 
    cmcont.mail2, 
    cmcont.telefono, 
    cmcont.telefono2, 
    cmcont.fechanac,
   
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella, 
    cmcont.facephoto, 
    cmcont.ultimoingreso,   
    CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad,  
    icrel.estado as icestado,
    icrel.tipo as ictipo,
    (select id from icalquileres where estado = 'Activo' and unidad = '')as alquiler
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and icrel.Tipo = 'Inquilino' 
    and icrel.estado = 'Activo'
    /**
    and icrel.alquiler in (select id from icalquileres where estado = 'Activo' and unidad = '')
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro','Pendiente') 
    **/
order by 
    icrel.id
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR alquileresproximosmobile2.onopen(-1)
SQL Error: select 
    id as idalq, 
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino')) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id) cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion
from 
    icalquileres 
where 
    unidad = ''
    and estado = 'Pendiente'
    and current_date() between contratodesde and contratohasta
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR tablaalquileresactivos2.onopen(-1)
SQL Error: select 
    id as idalq,
    tipoalquiler,
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino') and estado != "Anulado" ) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id and estado != "Anulado") cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion,
    if( estado = 'Pendiente',
        if(contratodesde > current_date(),'Próximos','Pendientes')
    ,estado)
    as estadoalquiler,
    if(
        estado = 'Activo' and contratohasta < current_date(),
        'Vencido',
        estado
    ) as estadocontrato
from 
    icalquileres 
where 
    unidad = ''
    and estado != 'Inactivo'
    and estado != 'Anulado'
    /**    and estado = 'Activo' **/
    /** and current_date() between contratodesde and contratohasta **/
order by contratodesde, estado
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

******** ERROR alquileresmobile.badgeclass(1)
java.lang.Exception: ERROR unidades4/verunidad:alquileresmobile.badgeclass(1) i6: java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado ='Activo'
Table 'uv1066_quartier.icalquileres' doesn't exist

java.sql.SQLException: select count(*) from icalquileres where unidad = '' and estado ='Activo'
Table 'uv1066_quartier.icalquileres' doesn't exist

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125)
	at flexa.fb.LibDb.sqlget(LibDb.java:245)
	at flexa.fb.LibDb.call(LibDb.java:41)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:871)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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:1083)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:839)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.FComponent.calcExpressions(FComponent.java:872)
	at flexa.fb.CompManager.processAction(CompManager.java:711)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159)
	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)


******** ERROR cuentacorrienteusdtabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = 'USD'
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL  DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = 'USD',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    'USD' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = 'USD'
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = 'USD'
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
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 ')
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dia' at line 34
 SQLSTATE 42000

******** ERROR datosemergencia32.onopen(-1)
SQL Error: select 
    cmcont.id as idcontacto, 
    cmcont.tipodoc, 
    cmcont.numdoc, 
    cmcont.nombre, 
    cmcont.apellido, 
    icrel.id as idrel,
    icrel.perfil, 
    cmcont.mail, 
    cmcont.mail2, 
    cmcont.telefono, 
    cmcont.telefono2, 
    cmcont.fechanac,
    icrel.desde, 
    icrel.hasta, 
    cmcont.huella, 
    cmcont.facephoto, 
    cmcont.ultimoingreso,   
    CAST(
    DATE_FORMAT(
        FROM_DAYS(
        DATEDIFF(NOW(), cmcont.fechanac)
        ), 
        '%Y'
    ) as UNSIGNED
    ) as edad,  
    icrel.estado as icestado,
    icrel.tipo as ictipo
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '' 
    and icrel.tipo = 'Emergencia' 
    and icrel.estado = 'Activo'
    
order by 
    icrel.id
Unknown column 'cmcont.huella' in 'field list'
 SQLSTATE 42S22

******** ERROR alquileresproximosmobile3.onopen(-1)
SQL Error: select 
    id idalq, 
    (select id from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as idicrel, 
    (select nombre from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as nombreinq, 
    (select apellido from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as apellidoinq, 
    (select tipodoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as tipodocinq, 
    (select numdoc from icrel where alquiler = icalquileres.id and tipo = 'Inquilino' limit 1) as numdocinq, 
    date_format(contratodesde, "%d/%m/%Y") as contratodesdeinq,
    date_format(contratohasta, "%d/%m/%Y") as contratohastainq,
    date_format(contratodesde, "%d/%m/%y") as contratodesdeinqc,
    date_format(contratohasta, "%d/%m/%y") as contratohastainqc,
    (select count(*) from icrel where alquiler = icalquileres.id and tipo in ('Habitante','Inquilino')) cantacompanantes,
    (select count(*) from icrelveh where alquiler = icalquileres.id) cantvehiculos,
    IF(
        DATEDIFF(contratohasta, contratodesde) > 365,
        CONCAT(FLOOR(DATEDIFF(contratohasta, contratodesde) / 365),' años'),
        CONCAT(DATEDIFF(contratohasta, contratodesde),' días')
    ) as duracion
from 
    icalquileres 
where 
    unidad = ''
    and estado = 'Pendiente'
    and contratodesde > current_date()
Table 'uv1066_quartier.icalquileres' doesn't exist
 SQLSTATE 42S02

CONTEXT:
_module=unidades4  <i><small>String</small></i>
alquiler=null
idalquiler=null
saldo=null
cantidad=null
<b>component</b>


<b>request_</b>
     _c=unidades4/verunidad  <i><small>String</small></i>
     _v=6140  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=939  <i><small>String</small></i>
     _h=Cz19hARxT5FipF72MKoM  <i><small>String</small></i>
     _sessionid=Cz19hARxT5FipF72MKoM  <i><small>String</small></i>
     _servername=miquartier.com.ar  <i><small>String</small></i>
     _url=https://miquartier.com.ar/miquartier/index.html  <i><small>String</small></i>


<b><red>u_</red></b>
     u_posesiones=0  <i><small>Long</small></i>
     u_proyecto=qbajo  <i><small>String</small></i>
     u_totalproyectos=0  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[168927@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=  <i><small>String</small></i>
     s_idcontacto=168927  <i><small>Integer</small></i>
     s_phpurl=https://.miquartier.com.ar/consorcios3/  <i><small>String</small></i>
     s_unidadrel=  <i><small>String</small></i>
     s_idunidad=null
     s_unidad=null
     s_idusuario=  <i><small>String</small></i>
     s_unidadestado=  <i><small>String</small></i>


<b><red>g_</red></b>
     g_expensa=null
     g_base=..  <i><small>String</small></i>
     g_proyecto=null
     _e=uv1066_quartier  <i><small>String</small></i>