PDOException {#111 ▼
#message: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE a.activado=1 GROUP BY m.id, m.nombre ORDER BY m.nombre' at line 1 ◀SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version f ▶"
#code: "42000"
#file: "/usr/home/hispanoracing.com/web/modelo/mysqlPHP7PDO.php"
#line: 63
+errorInfo: array:3 [▶
0 => "42000"
1 => 1064
2 => "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE a.activado=1 GROUP BY m.id, m.nombre ORDER BY m.nombre' at line 1 ◀You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE a.activado=1 GRO ▶"
]
trace: {▶
/usr/home/hispanoracing.com/web/modelo/mysqlPHP7PDO.php:63 {▼
› $this->sentencia = $this->enlace->prepare($consulta);
› $estado = $this->sentencia->execute();
› //if ($estado)
}
/usr/home/hispanoracing.com/web/modelo/coleccionMarcas.php:89 {▶
›
› $resultados = $conexion->getArray($sql);
› $this->rellenar($resultados, 'marca');
arguments: {▶
$consulta: "SELECT m.id id, m.nombre nombre, m.nombreUrl nombreUrl FROM marca m inner join articulo a on a.idMarca = m.id inner join categoria c on a.idCategoria = c.id AND c.id = WHERE a.activado=1 GROUP BY m.id, m.nombre ORDER BY m.nombre ◀SELECT m.id id, m.nombre nombre, m.nombreUrl nombreUrl FROM marca m inner join articulo a on a.idMarca = m.id inner join categoria c on a.idCategoria = c.id ▶"
}
}
/usr/home/hispanoracing.com/web/controlador/principalControlador.php:349 {▶
› $marcas = new coleccionMarcas($condiciones);
› $marcas->getMarcasCategoria($categoria->id);
›
arguments: {▶
$idCategoria: null
}
}
/usr/home/hispanoracing.com/web/modelo/controlador.php:357 {▶
›
› $invocar = call_user_func(array($obj, $this->elemento[1]));
› $this->respuesta = $obj->getRespuesta();
}
/usr/home/hispanoracing.com/web/index.php:73 {▶
› $vista = new vista();
› libreria::getElemento('controlador')->reproducir();
› $contenido = $vista->finalizar();
}
}
}
AKI 2