A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: Principal/HomeAvaluacio.php

Line Number: 49

Backtrace:

File: /var/www/html/application/controllers/Principal/HomeAvaluacio.php
Line: 49
Function: _error_handler

File: /var/www/html/index.php
Line: 315
Function: require_once

Database Error

A Database Error Occurred

Error Number: 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 'OR `aval_registre_fase_rol`.`id_usuari_rol2` = OR `aval_registre_fase_rol`.`id_u' at line 8

SELECT `aval_perfil`.`descripcio`, `rols`.`descripcio` as `descripcio_rol`, CONCAT(usuaris.nomUsuari, ' ', usuaris.cognomsUsuari) as nom_avaluat, `aval_registre`.`nany`, `aval_registre_fase_rol`.`fase`, `aval_registre_fase_rol`.`estat`, `aval_registre`.`data_inici`, `aval_registre`.`data_fi`, `aval_registre_fase_rol`.`id` as `id_registre_fase_rol`, `aval_registre_fase_rol`.`consens`, `aval_registre_fase_rol`.`estat_signatura`, `aval_registre_resultats`.`valor`, `aval_registre_fase_rol`.`id_usuari`, `aval_registre_fase_rol`.`id_usuari_rol2`, `aval_registre_fase_rol`.`id_usuari_rol3`, `aval_registre_fase_rol`.`id_usuari_rol4`, `aval_registre_fase_rol`.`rol2`, `aval_registre_fase_rol`.`rol3`, `aval_registre_fase_rol`.`rol4`, `aval_registre_fase_rol`.`rol`, `aval_registre`.`id_perfil`, `aval_registre`.`estat` as `estat_registre`, `aval_registre_fase_rol`.`id_registre` FROM `aval_registre_fase_rol` JOIN `aval_registre` ON `aval_registre`.`id`=`aval_registre_fase_rol`.`id_registre` JOIN `aval_perfil` ON `aval_perfil`.`id`=`aval_registre`.`id_perfil` JOIN `rols` ON `rols`.`idRol`=`aval_registre_fase_rol`.`rol` JOIN `usuaris` ON `usuaris`.`idUsuari`=`aval_registre`.`id_usuari` LEFT JOIN `aval_registre_resultats` ON `aval_registre_resultats`.`id_registre_fase_rol`=`aval_registre_fase_rol`.`id` AND `aval_registre_resultats`.`id_resultat`=1 WHERE (`aval_registre_fase_rol`.`id_usuari` = OR `aval_registre_fase_rol`.`id_usuari_rol2` = OR `aval_registre_fase_rol`.`id_usuari_rol3` = OR `aval_registre_fase_rol`.`id_usuari_rol4` =) AND `data_inici` >= '2022-01-01' AND `data_inici` <= '2024-12-31' AND `aval_registre_fase_rol`.`estat` = 'C' ORDER BY `data_inici`, CONCAT(usuaris.nomUsuari, ' ', usuaris.cognomsUsuari)

Filename: models/Comu/Avaluacions_model.php

Line Number: 265