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)
Offline
Thank you for this report. See [Github] Piwigo issue #1068 and [Github] Piwigo commit 5b65fca3
Offline