******** ERROR statusfilter.onopen(-1)
SQL Error: SELECT '' AS status, CONCAT('Todos (', COUNT(*), ')') AS statusfilter
FROM contact
UNION ALL
SELECT status, CONCAT(status, ' (', COUNT(*), ')') AS statusfilter
FROM contact
where status != "" and status is not null
GROUP BY status;
Table 'uv1066_quartier.contact' doesn't exist
SQLSTATE 42S02
******** ERROR sourcefilter.onopen(-1)
SQL Error: SELECT '' AS source, CONCAT('Todos (', COUNT(*), ')') AS sourcefilter
FROM contact
UNION ALL
SELECT source, CONCAT(source, ' (', COUNT(*), ')') AS sourcefilter
FROM contact
where source != "" and source is not null
GROUP BY source;
Table 'uv1066_quartier.contact' doesn't exist
SQLSTATE 42S02
******** ERROR listcontactos.onopen(-1)
SQL Error: SELECT
id AS idcontact,
name AS nombrecompleto,
email,
phone AS telefono,
source,
is_lead AS lead,
proyecto,
status AS estado,
interes,
detalles,
resumen,
accion,
campana,
DATE_FORMAT(alta, '%d/%m/%y %H:%i:%s') AS alta,
DATE_FORMAT(actualizacion, '%d/%m/%y %H:%i:%s') AS actualizacion
FROM contact
WHERE
(IFNULL('Todos', '') = ''
OR 'Todos' = 'Todos'
OR source = 'Todos' )
AND
(IFNULL('Todos', '') = ''
OR 'Todos' = 'Todos'
OR status = 'Todos' )
AND
(IFNULL('Todos', '') = ''
OR 'Todos' = 'Todos'
OR campana = 'Todos' )
ORDER BY id DESC
limit 50;
Table 'uv1066_quartier.contact' doesn't exist
SQLSTATE 42S02
******** ERROR campanafilter.onopen(-1)
SQL Error: SELECT '' AS campana, CONCAT('Todos (', COUNT(*), ')') AS campanafilter
FROM contact
UNION ALL
SELECT campana, CONCAT(campana, ' (', COUNT(*), ')') AS campanafilter
FROM contact
where campana != '' and campana is not null
GROUP BY campana;
Table 'uv1066_quartier.contact' doesn't exist
SQLSTATE 42S02
CONTEXT:
_module=crm4 String
component
request_
_c=crm4/contactos String
_v=163 String
_ip=127.0.0.1 String
_x=onopen String
_mv=1470 String
_h=aLvXe9qHMvSgM07LS3qf String
_sessionid=aLvXe9qHMvSgM07LS3qf String
_servername=66.97.46.32 String
_url=http://66.97.46.32/app/ String
u_
u_expensa=null String
u_posesiones=0 Long
u_proyecto=[3@emprendimientos4.emprendimiento]
u_abierta=null String
u_totalproyectos=6 Long
s_
s_usuario=[101677@consorcios4.persona]
s_loggedin=yes String
s_perfil=Superusuario String
s_idcontacto= String
s_cerradohasta=2025-03-31 Date
s_unidadrel= String
proyecto=3 String
s_idunidad=null
s_cerradodesde=2025-03-01 Date
s_mescerrado=2025-03 String
s_unidad=null
s_idusuario=101677 Integer
s_unidadestado= String
g_
g_base=http://66.97.46.32 String
g_sidebarbgcolor=#ccc String
g_estilosadicionales=null
_e=uv1066_quartier String
g_sidebarcolor=#fff String
g_sidebarposition=Nuevo String