Warning: [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 'ASC' at line 6
SELECT DISTINCT id FROM mlhgrx_images
INNER JOIN mlhgrx_image_category ON id = image_id
WHERE category_id IN (801)
AND date_creation BETWEEN '2022-06-01' AND '2022-06-30 23:59:59'
ORDER BY date_creation ASC, file ASC, rank ASC in /home/sportactab/piwigo/include/dblayer/functions_mysqli.inc.php on line 847
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/sportactab/piwigo/include/dblayer/functions_mysqli.inc.php:908
Stack trace:
#0 /home/sportactab/piwigo/include/functions.inc.php(1640): query2array('SELECT DISTINCT...', NULL, 'id')
#1 /home/sportactab/piwigo/include/functions_calendar.inc.php(296): array_from_query('SELECT DISTINCT...', 'id')
#2 /home/sportactab/piwigo/include/section_init.inc.php(576): initialize_calendar()
#3 /home/sportactab/piwigo/index.php(12): include('/home/sportacta...')
#4 {main}
thrown in /home/sportactab/piwigo/include/dblayer/functions_mysqli.inc.php on line 908