******** ERROR unnamed162.onopen(-1)
SQL Error: select
icalquileres.id as idalq,
icalquileres.tipoalquiler,
icalquileres.contratodesde as contratodesdealq,
icalquileres.contratohasta as contratohastaalq,
icalquileres.estado as estadoalq,
icalquileres.unidad as unidadalq,
(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,
(select denominacion from Unidades where id = icalquileres.unidad) as unidad,
(select emprendimientoId from Unidades where id = icalquileres.unidad)
from
icalquileres join Unidades on icalquileres.unidad = Unidades.id
where
icalquileres.estado = 'Pendiente'
and icalquileres.contratodesde >= current_date()
and Unidades.emprendimientoId = 'qlacroze'
and (('' IS NULL OR '' = '') OR icalquileres.unidad = '')
Table 'uv1066_quartier.icalquileres' doesn't exist
SQLSTATE 42S02
******** ERROR unnamed16.onopen(-1)
SQL Error: select
icalquileres.id as idalq,
tipoalquiler,
icalquileres.contratodesde as contratodesdealq,
icalquileres.contratohasta as contratohastaalq,
icalquileres.estado as estadoalq,
icalquileres.unidad as unidadalq,
(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,
(select denominacion from Unidades where id = icalquileres.unidad) as unidad,
(select emprendimientoId from Unidades where id = icalquileres.unidad)
from
icalquileres join Unidades on icalquileres.unidad = Unidades.id
where
icalquileres.estado = 'Activo'
and current_date() between icalquileres.contratodesde and icalquileres.contratohasta
and Unidades.emprendimientoId = 'qlacroze'
and (('' IS NULL OR '' = '') OR icalquileres.unidad = '')
Table 'uv1066_quartier.icalquileres' doesn't exist
SQLSTATE 42S02
CONTEXT:
_module=unidades4 String
component
request_
_c=unidades4/alquileres String
_v=54 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@emprendimientos4.emprendimiento]
u_totalproyectos=2 Long
s_
s_usuario=[101677@consorcios4.persona]
s_loggedin=yes String
s_perfil=Superusuario String
s_verreservaamenitie=S 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_mudanza=157211 Integer
s_unidad=null
s_idusuario=101677 Integer
s_unidadestado= String
g_
g_expensa=null
g_base=.. String
g_proyecto=null
_e=uv1066_quartier String