******** ERROR novedades.onopen(-1) SQL Error: select id as idnovedad, fecha, titulo as title, detalles as text, if(archivo1 !='', concat('../consorcios/imagenes/Qlacroze/novedades/',archivo1), '../include/sinimagen.jpg') as image, /* if(iconoarc !='',concat('../files/consorcios3/iconos/',iconoarc), concat(tipo, '.jpg')) as imageicono, */ if(archivo1 !='', concat('../consorcios/imagenes/Qlacroze/novedades/',archivo1), concat(tipo, '.jpg')) as icono, tipo as tiponov, '_popup' as target, (select color from ictnov where emprendimiento = nov.emprendimiento and descripcion = nov.tipo limit 1) as color, concat('#consorcios4/vernovedad?id=', nov.id) as link, /* concat('',tipo,'',' - ',date_format(fecha,'%d/%m/%y')) as comments,*/ substr(detalles, 1, 120) as other /** , (select CONCAT_WS(' ','Enviado por mail el', date_format(fecha, '%d/%m/%Y')) from nsjobs where idobjeto=nov.id order by id DESC limit 1) as cantmails **/ from nov where emprendimiento = 'Qlacroze' and tipo != 'Expensas' /* and activo ='S' */ and ( ('' = '' and tipo != 'Consejo') or (tipo = '' and '' != '') ) and ( ('' = '' and activo != 'N') or (activo = '' and '' != '') ) order by fecha desc, id limit 8; Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQLSTATE HY000 ******** ERROR evento.onopen(-1) SQL Error: SELECT id AS idnovedad, '' as denominacion, fecha, titulo AS comments, '' AS text, /* CONCAT('../consorcios/imagenes/Qlacroze/novedades/', IF(archivo1 = '', CONCAT(tipo, '.jpg'), archivo1)) AS image,*/ '' AS tiponov, (SELECT color FROM ictnov WHERE emprendimiento = nov.emprendimiento AND descripcion = nov.tipo LIMIT 1) AS color, CONCAT('#consorcios4/vernovedad?id=', id) AS link, '' as horario, '' as codigo FROM nov WHERE emprendimiento = 'Qlacroze' AND tipo != 'Expensas' AND activo = 'S' AND fecha >= CURDATE() UNION ALL SELECT id, (SELECT denominacion FROM Unidades WHERE id = idunidad) AS denominacion, fecha, (SELECT nombre FROM pcomunes WHERE id = rpcomun.partecomun) as comments, '' AS text, '' AS tiponov, '' AS color, CONCAT('#turnos4/reservado?id=',id) AS link, rpcomun.horario as horario, partecomun as codigo FROM rpcomun WHERE emprendimiento = 'Qlacroze' AND fecha >= CURDATE() AND estado != 'Cancelada' AND if('Superusuario' in ('Propietario','Titular','Contacto Principal','Habitante','Inquilino'), idunidad in (select unidad from icrel where contacto = '' and tipo in ('Titular','Contacto principal','Habitante','Inquilino') and estado = 'Activo'), if('Superusuario' in ('Administrador', 'Intendente','Superusuario','Seguridad','Escribania','Arquitecto'),1=1,'')) order by fecha limit 20; Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQLSTATE HY000 ******** ERROR home.onopen(29) java.lang.Exception: ERROR consorcios4/home:home.onopen(29) i105: java.sql.SQLException: select ultimotalon,ifnull(adhesiondebautomatico,'N') from Unidades where id = ''; Unknown column 'adhesiondebautomatico' in 'field list' java.sql.SQLException: select ultimotalon,ifnull(adhesiondebautomatico,'N') from Unidades where id = ''; Unknown column 'adhesiondebautomatico' in 'field list' at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190) at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125) at flexa.fb.LibDb.sqltoarray(LibDb.java:202) at flexa.fb.LibDb.call(LibDb.java:45) 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) CONTEXT: _module=consorcios4 String datosBancarios=null cantunidades=0 Long saldomoneda1=0E-30 BigDecimal component request_ _c=consorcios4/home String _v=979 String _x=onopen String _mv=939 String _h=U2lmRpNx3sQx0go3cLXK String _sessionid=U2lmRpNx3sQx0go3cLXK String _servername=miquartier.com.ar String _url=https://miquartier.com.ar/miquartier/index.html String u_ u_posesiones=0 Long u_proyecto=[Qlacroze@null.emprendimiento] u_totalproyectos=2 Long s_ s_usuario=[101677@consorcios4.persona] s_loggedin=yes String s_perfil=Superusuario String s_idcontacto= String s_phpurl=https://Qlacroze.flexaconsorcios.com/consorcios3/ String s_unidadrel= String proyecto=Qlacroze String s_estadoperfil=Activo String s_idunidad=null s_unidad=null s_idusuario=101677 Integer s_unidadestado= String g_ g_base=.. String _e=uv1066_quartier String