Hay un error en su setencia SQL. SELECT
noti.idNoticias AS ID,
ROW_NUMBER() OVER (ORDER BY noti.idNoticias DESC) AS numero,
COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo) AS titulo,
noti.Fecha AS fecha,
noti.fecha_publicar AS fecha_publicacion,
COALESCE(NOTIRANS.Volanta, NOTIDEF.Volanta) AS VOLANTA,
noti.Contenido AS conteBIG,
COALESCE(TRANSLA.seccion, TRANSDEF.seccion) AS categoria,
CONCAT(LOWER(COALESCE(TRANSLA.seccion, TRANSDEF.seccion)), "/IDNO") AS LINK_SEC,
CONCAT(LOWER(COALESCE(TRANSLA.seccion, TRANSDEF.seccion)), "/IDNO", noti.idNoticias, "/", COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo)) AS LINK,
CONCAT(noti.idNoticias, "/", COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo)) AS LINK_PAG,
IF(LENGTH(noti.fotoDefault) > 0, "block", "none") AS CSS,
CONCAT(noti.ruta, noti.fotoDefault) AS foto,
noti.Orden,
noti.i2m_api_categorianoticias_idCategoriaNoticias AS catenoticias,
noti.Destacado AS destacado,
noti.fotoDefault AS FOTODEF,
noti.ruta AS RUTA,
noti.i2m_core_estados_idEstados AS IDESTADO,
noti.VaAlHome AS VAALHOME,
ESTA.color AS BG_ESTADOS,
cate.idi2m_api_noticias_secciones AS IDSECCION,
noti.i2m_core_template_pagina_idi2m_core_template_pagina AS IDPAGINA,
LNG.setDefault AS ISDEFAULT,
noti.fecha_publicar AS FECHA_PUBLICAR,
GROUP_CONCAT(CATENOTI.Categoria SEPARATOR " | ") AS CATEGORIAS
FROM i2m_api_noticias noti
-- Traducción en idioma actual
LEFT JOIN i2m_core_noticias_translation NOTIRANS
ON NOTIRANS.i2m_api_noticias_idNoticias = noti.idNoticias
AND NOTIRANS.i2m_core_language_idi2m_core_language = 1 -- idioma actual
-- Traducción en idioma por defecto
LEFT JOIN i2m_core_noticias_translation NOTIDEF
ON NOTIDEF.i2m_api_noticias_idNoticias = noti.idNoticias
AND NOTIDEF.i2m_core_language_idi2m_core_language IN (
SELECT idi2m_core_language FROM i2m_core_language WHERE setDefault = "Y"
)
-- Secciones y traducciones de secciones (actual y fallback)
INNER JOIN i2m_api_noticias_secciones cate
ON cate.idi2m_api_noticias_secciones = noti.i2m_api_noticias_secciones_idi2m_api_noticias_secciones
LEFT JOIN i2m_api_noticias_secciones_translations AS TRANSLA
ON TRANSLA.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSLA.i2m_core_language_idi2m_core_language = 1
LEFT JOIN i2m_api_noticias_secciones_translations AS TRANSDEF
ON TRANSDEF.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSDEF.i2m_core_language_idi2m_core_language IN (
SELECT idi2m_core_language FROM i2m_core_language WHERE setDefault = "Y"
)
-- Otros joins
INNER JOIN i2m_core_language LNG ON LNG.idi2m_core_language = 1
INNER JOIN i2m_core_estados ESTA ON ESTA.idEstados = noti.i2m_core_estados_idEstados
LEFT JOIN i2m_api_noticias_has_i2m_api_noticias_categorias RELA
ON RELA.i2m_api_noticias_idNoticias = noti.idNoticias
LEFT JOIN i2m_api_noticias_categorias CATENOTI
ON CATENOTI.idi2m_api_noticias_categorias = RELA.i2m_api_noticias_categorias_idi2m_api_noticias_categorias
WHERE
noti.fecha_publicar <= CURDATE()
AND noti.i2m_core_estados_idEstados = 1
AND CATENOTI.idi2m_api_noticias_categorias IN()
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_template_pagina = 14
GROUP BY noti.idNoticias
ORDER BY noti.idNoticias DESC
LIMIT 0, 10; mysqli_sql_exception: 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 ')
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_co' at line 73 in /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php:79
Stack trace:
#0 /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php(79): mysqli->prepare('SELECT\r\n not...')
#1 /home/drfernan/public_html/php/clases/I2m/i2m_DB/i2m_db.php(65): I2m\DB\i2m_MySQLI->ejecutarQuery('SELECT\r\n not...', true)
#2 /home/drfernan/public_html/php/clases/I2m/i2m_Noticias/i2m_Noticias.php(1188): I2m\DB\i2m_Base_de_Datos->consultar('SELECT\r\n not...')
#3 /home/drfernan/public_html/themes/I2M_OPTICAS/modulos/i2m_noticias_optica/i2m_theme_noticias_optica.php(833): I2m\NOTICIAS\i2m_Noticias->showRelationArticles(NULL, '59', '/home/drfernan/...', 0, 10)
#4 /home/drfernan/public_html/themes/I2M_OPTICAS/layout/config_vars.php(442): I2m\NOTICIAS\i2m_theme_noticias_optica->ampliarNota('59')
#5 /home/drfernan/public_html/php/index.php(24): I2m\i2m_theme_I2M_MAPA_CDP_config_vars->newsGetTheme()
#6 {main}
Hay un error en su setencia SQL. SELECT
noti.idNoticias AS ID,
ROW_NUMBER() OVER (ORDER BY noti.idNoticias DESC) AS numero,
COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo) AS titulo,
noti.Fecha AS fecha,
noti.fecha_publicar AS fecha_publicacion,
COALESCE(NOTIRANS.Volanta, NOTIDEF.Volanta) AS VOLANTA,
noti.Contenido AS conteBIG,
COALESCE(TRANSLA.seccion, TRANSDEF.seccion) AS categoria,
CONCAT(LOWER(COALESCE(TRANSLA.seccion, TRANSDEF.seccion)), "/IDNO") AS LINK_SEC,
CONCAT(LOWER(COALESCE(TRANSLA.seccion, TRANSDEF.seccion)), "/IDNO", noti.idNoticias, "/", COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo)) AS LINK,
CONCAT(noti.idNoticias, "/", COALESCE(NOTIRANS.Titulo, NOTIDEF.Titulo)) AS LINK_PAG,
IF(LENGTH(noti.fotoDefault) > 0, "block", "none") AS CSS,
CONCAT(noti.ruta, noti.fotoDefault) AS foto,
noti.Orden,
noti.i2m_api_categorianoticias_idCategoriaNoticias AS catenoticias,
noti.Destacado AS destacado,
noti.fotoDefault AS FOTODEF,
noti.ruta AS RUTA,
noti.i2m_core_estados_idEstados AS IDESTADO,
noti.VaAlHome AS VAALHOME,
ESTA.color AS BG_ESTADOS,
cate.idi2m_api_noticias_secciones AS IDSECCION,
noti.i2m_core_template_pagina_idi2m_core_template_pagina AS IDPAGINA,
LNG.setDefault AS ISDEFAULT,
noti.fecha_publicar AS FECHA_PUBLICAR,
GROUP_CONCAT(CATENOTI.Categoria SEPARATOR " | ") AS CATEGORIAS
FROM i2m_api_noticias noti
-- Traducción en idioma actual
LEFT JOIN i2m_core_noticias_translation NOTIRANS
ON NOTIRANS.i2m_api_noticias_idNoticias = noti.idNoticias
AND NOTIRANS.i2m_core_language_idi2m_core_language = 1 -- idioma actual
-- Traducción en idioma por defecto
LEFT JOIN i2m_core_noticias_translation NOTIDEF
ON NOTIDEF.i2m_api_noticias_idNoticias = noti.idNoticias
AND NOTIDEF.i2m_core_language_idi2m_core_language IN (
SELECT idi2m_core_language FROM i2m_core_language WHERE setDefault = "Y"
)
-- Secciones y traducciones de secciones (actual y fallback)
INNER JOIN i2m_api_noticias_secciones cate
ON cate.idi2m_api_noticias_secciones = noti.i2m_api_noticias_secciones_idi2m_api_noticias_secciones
LEFT JOIN i2m_api_noticias_secciones_translations AS TRANSLA
ON TRANSLA.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSLA.i2m_core_language_idi2m_core_language = 1
LEFT JOIN i2m_api_noticias_secciones_translations AS TRANSDEF
ON TRANSDEF.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSDEF.i2m_core_language_idi2m_core_language IN (
SELECT idi2m_core_language FROM i2m_core_language WHERE setDefault = "Y"
)
-- Otros joins
INNER JOIN i2m_core_language LNG ON LNG.idi2m_core_language = 1
INNER JOIN i2m_core_estados ESTA ON ESTA.idEstados = noti.i2m_core_estados_idEstados
LEFT JOIN i2m_api_noticias_has_i2m_api_noticias_categorias RELA
ON RELA.i2m_api_noticias_idNoticias = noti.idNoticias
LEFT JOIN i2m_api_noticias_categorias CATENOTI
ON CATENOTI.idi2m_api_noticias_categorias = RELA.i2m_api_noticias_categorias_idi2m_api_noticias_categorias
WHERE
noti.fecha_publicar <= CURDATE()
AND noti.i2m_core_estados_idEstados = 1
AND CATENOTI.idi2m_api_noticias_categorias IN()
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_template_pagina = 14
GROUP BY noti.idNoticias
ORDER BY noti.idNoticias DESC
LIMIT 0, 10; mysqli_sql_exception: 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 ')
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_co' at line 73 in /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php:79
Stack trace:
#0 /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php(79): mysqli->prepare('SELECT\r\n not...')
#1 /home/drfernan/public_html/php/clases/I2m/i2m_DB/i2m_db.php(65): I2m\DB\i2m_MySQLI->ejecutarQuery('SELECT\r\n not...', true)
#2 /home/drfernan/public_html/php/clases/I2m/i2m_Noticias/i2m_Noticias.php(1188): I2m\DB\i2m_Base_de_Datos->consultar('SELECT\r\n not...')
#3 /home/drfernan/public_html/themes/I2M_OPTICAS/modulos/i2m_noticias_optica/i2m_theme_noticias_optica.php(833): I2m\NOTICIAS\i2m_Noticias->showRelationArticles(NULL, '59', '/home/drfernan/...', 0, 10)
#4 /home/drfernan/public_html/themes/I2M_OPTICAS/layout/config_vars.php(449): I2m\NOTICIAS\i2m_theme_noticias_optica->ampliarNota('59')
#5 /home/drfernan/public_html/php/index.php(24): I2m\i2m_theme_I2M_MAPA_CDP_config_vars->newsGetTheme()
#6 {main}
Noticias - Dr. Fernando Mayorga - Expert in Medical Care -
