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

******** 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 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 = '11823' 
    and hasta >= CURRENT_DATE()
Table 'uv1066_quartier.icingreso' 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 = '11823')as alquiler
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '11823' 
    and icrel.Tipo = 'Inquilino' 
    and icrel.estado = 'Activo'
    /**
    and icrel.alquiler in (select id from icalquileres where estado = 'Activo' and unidad = '11823')
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro','Pendiente') 
    **/
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

******** 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 = '11823')as alquiler
    
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '11823' 
    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 = '11823'))
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro') 
    **/
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

******** 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 mascotasdesktop.badge(1)
java.lang.Exception: ERROR unidades4/verunidad:mascotasdesktop.badge(1) i6: java.sql.SQLException: select count(*) from icmascota where unidad = '11823' and estado = 'Activo'
Table 'uv1066_quartier.icmascota' doesn't exist

java.sql.SQLException: select count(*) from icmascota where unidad = '11823' 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 verunidad.onopen(106)
java.lang.Exception: ERROR unidades4/verunidad:verunidad.onopen(106) i312: java.sql.SQLSyntaxErrorException: Table 'uv1066_quartier.icautorizacion' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'uv1066_quartier.icautorizacion' doesn't exist
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
	at flexa.fb.LibDb.sqlexec(LibDb.java:212)
	at flexa.fb.LibDb.call(LibDb.java:36)
	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.event(FComponent.java:692)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:717)
	at flexa.fb.CompManager.processAction(CompManager.java:693)
	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.event(FComponent.java:692)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:717)
	at flexa.fb.CompManager.processAction(CompManager.java:693)
	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 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 = '11823' and current_date() between icrel.desde and icrel.hasta) as alquiler
from 
    icrel 
    cross join cmcont on icrel.contacto = cmcont.id 
where 
    icrel.unidad = '11823' 
    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 = '11823')) 
    and icrel.estado not in ('Anulado', 'Viejo', 'Inactivo','Futuro') 
    **/
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

******** 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 = '11823' 
    and icrel.tipo = 'Emergencia' 
    and icrel.estado = 'Activo'
    
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

******** 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 = '11823' 
    and icrel.Tipo = 'Titular' 
    and icrel.estado = 'Activo'
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

******** 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 = '11823' 
    and icrel.Tipo = 'Contacto principal' 
    and icrel.estado = 'Activo'
  
order by 
    icrel.id
Unknown column 'cmcont.facephoto' in 'field list'
 SQLSTATE 42S22

CONTEXT:
textores=Habilitar Reservas  <i><small>String</small></i>
ultimoingresoinquilino=null
estadounidad=  <i><small>panel</small></i>
texttitular=Cuando la unidad esté habitada podrá solicitar cambio de titular  <i><small>String</small></i>
textalquileres=Cuando la unidad esté habitada podrá agregar alquileres a su unidad  <i><small>String</small></i>
textotros=Cuando la unidad esté habitada podrá registrar autorizados  <i><small>String</small></i>
textresi=Cuando la unidad esté habitada podrá registrar residentes  <i><small>String</small></i>
textemg=Cuando la unidad esté habitada podrá registrar contactos de emergencia  <i><small>String</small></i>
inhreserva=btn-flat-success  <i><small>String</small></i>
temppiso=2  <i><small>String</small></i>
inhabilitareserva=null
visual=none  <i><small>String</small></i>
id=11823  <i><small>String</small></i>
ultimoingreso=null
alquilerespendientesnoconfirmados=0  <i><small>Long</small></i>
textinq=Cuando la unidad esté habitada podrá registrar inquilinos  <i><small>String</small></i>
temptorre=1 CIUDAD  <i><small>String</small></i>
tempdenominacion=1 CIUDAD 2 6  <i><small>String</small></i>
textmasc=Cuando la unidad esté habitada podrá registrar mascotas  <i><small>String</small></i>
saldo=null
disablecambiarestado=  <i><small>String</small></i>
textcont=Cuando la unidad esté habitada podrá registrar contactos principales  <i><small>String</small></i>
_module=unidades4  <i><small>String</small></i>
tempdepartamento=6  <i><small>String</small></i>
tempcodigo=  <i><small>String</small></i>
textveh=Cuando la unidad esté habitada podrá registrar sus vehiculos  <i><small>String</small></i>
completadoinquilino=N  <i><small>String</small></i>
disable=disable  <i><small>String</small></i>
alquiler=null
textserv=Cuando la unidad esté habitada podrá registrar personal de servicio  <i><small>String</small></i>
idalquiler=null
cantidad=0  <i><small>Long</small></i>
completado=S  <i><small>String</small></i>
<b>component</b>


<b>request_</b>
     idunidad=11823  <i><small>String</small></i>
     _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=U2lmRpNx3sQx0go3cLXK  <i><small>String</small></i>
     _sessionid=U2lmRpNx3sQx0go3cLXK  <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@emprendimientos4.emprendimiento]
     u_totalproyectos=2  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[101677@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=Superusuario  <i><small>String</small></i>
     s_verreservaamenitie=S  <i><small>String</small></i>
     s_idcontacto=  <i><small>String</small></i>
     s_phpurl=https://qbajo.flexaconsorcios.com/consorcios3/  <i><small>String</small></i>
     s_unidadrel=  <i><small>String</small></i>
     proyecto=qbajo  <i><small>String</small></i>
     s_estadoperfil=Activo  <i><small>String</small></i>
     s_idunidad=null
     s_mudanza=157177  <i><small>Integer</small></i>
     s_unidad=null
     s_idusuario=101677  <i><small>Integer</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>