Hi everyone,

I have updated my Piwigo installation on my Win2016 server (including MySQL 8).
Now I receive the following error on the frontend:

Piwigo encountered an irrecoverable error

[mysql error 1064] 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 '' at line 16

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    nb_categories,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc
    ON id = cat_id
    AND user_id = 1
  WHERE id_uppercat is NULL
     
  ORDER BY rank

#1    my_error D:\www\***\include\dblayer\functions_mysqli.inc.php(132)
#2    pwg_query D:\www\***\include\category_cats.inc.php(55)
#3    include D:\www\***\index.php(301)

Running this from MySQL CLI results in:
Error Code: 1064. 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 ', SELECT     c.*,     user_representative_picture_id,     nb_images,     date_la' at line 1

Piwigo version: 2.10 RC
PHP version: 7.3.5
MySQL version: 8.0.13

Last edited by Dan84 (2019-08-28 15:39:05)