Hello
I have an error on aprrox. half my albums saying:
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 7
SELECT DISTINCT(image_id)
FROM piwigo_image_category
INNER JOIN piwigo_images ON id = image_id
WHERE
category_id = 81
AND (category_id NOT IN (25,26,27,28,29,30,39,40,41,42,47,48,49,72,77))
ORDER BY rank ASC
; in /home/gullach1/photos.gullach.org/include/dblayer/functions_mysqli.inc.php on line 847
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/gullach1/photos.gullach.org/include/dblayer/functions_mysqli.inc.php:908 Stack trace: #0 /home/gullach1/photos.gullach.org/include/section_init.inc.php(317): query2array('\nSELECT DISTINC...', NULL, 'image_id') #1 /home/gullach1/photos.gullach.org/index.php(12): include('/home/gullach1/...') #2 {main} thrown in /home/gullach1/photos.gullach.org/include/dblayer/functions_mysqli.inc.php on line 908
Could anyone with babysteps and very low tech wording explain to my why and what I should do?
Offline