adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-11-03 07:22:22 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Display only recent photos + Display all photos = MySQL Error #982

New Issue
Open
opened 2026-10-05 00:26:34 +02:00 by adam · 0 comments
adam commented 2026-10-05 00:26:34 +02:00
Owner
Copy link
Copy source

Enabling the filter function "Display only recently posted photos" and then selecting "Display all photos in all sub-albums", will display all photos with no filter applied.

Selecting one of the photos which should have been filtered out, result in the following error:

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3

SELECT id, name, permalink
FROM piwigo_categories
WHERE id IN () in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php on line 856

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php:909 Stack trace: #0 /-SNIP-/httpd.www/photoalbum2/include/functions.inc.php(1517): query2array('\nSELECT id, nam...', 'id') #1 /-SNIP-/httpd.www/photoalbum2/picture.php(965): hash_from_query('\nSELECT id, nam...', 'id') #2 {main}thrown in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php on line 909

Enabling the filter function "Display only recently posted photos" and then selecting "Display all photos in all sub-albums", will display all photos with no filter applied. Selecting one of the photos which should have been filtered out, result in the following error: Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 SELECT id, name, permalink FROM piwigo_categories WHERE id IN () in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php on line 856 Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php:909 Stack trace: #0 /-SNIP-/httpd.www/photoalbum2/include/functions.inc.php(1517): query2array('\nSELECT id, nam...', 'id') #1 /-SNIP-/httpd.www/photoalbum2/picture.php(965): hash_from_query('\nSELECT id, nam...', 'id') #2 {main}thrown in /-SNIP-/httpd.www/photoalbum2/include/dblayer/functions_mysqli.inc.php on line 909 <!-- github-sync-id:530404618 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#982