Hi,
I have KoolPHP UI Professional 8.7
I hope someone have a idea, that my request, i have a sql request that give me some trouble :-)

SELECT log_admins.timestamp, 
   data_admins.cie,
   data_admins.firstname,
   data_admins.lastname,
   ref_action.text,
   CASE WHEN log_admins.action_id IN (4,5,6,7) 
           THEN data_ad.name
        WHEN log_admins.action_id IN (8,9,10,13)
           THEN data_medias.customer_filename
        WHEN log_admins.action_id IN (1,2,11,14,17)
           THEN ''
    END ref_id    
 FROM log_admins 
INNER JOIN data_admins 
   ON log_admins.user_id = data_admins.id 
INNER JOIN ref_action
   ON log_admins.action_id = ref_action.action_id 
  AND ref_action.language_id = 1033 
 LEFT JOIN data_medias
   ON data_medias.id= log_admins.ref_id 
   LEFT JOIN data_ad
   ON data_ad.id= log_admins.ref_id
WHERE (to_CHAR(timestamp, 'yyyy-mm-dd') BETWEEN '2024-10-11' AND '2024-10-22')
ORDER BY log_admins.timestamp DESC;

In the console of the MySql server that work very well, but in the KooGrid i got error' any idea where to look?
I have Kool

[24-Oct-2024 19:31:26 UTC] PHP Warning:  mysqli_fetch_row() expects parameter 1 to be mysqli_result, bool given in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 42
[24-Oct-2024 19:31:26 UTC] PHP Notice:  Trying to access array offset on value of type null in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 43
[24-Oct-2024 19:31:26 UTC] PHP Warning:  mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in /home/.../kool/KoolGrid/ext/datasources/MySQLiDataSource.php on line 112