adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Batch manager raises SQL errors #989

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

Environment

Piwigo 2.10.1
Operating system: Linux
PHP: 7.3.11-1~deb10u1
MySQL: 5.5.5-10.3.18-MariaDB-0+deb10u1
Graphics Library: ImageMagick 6.9.10-23

How to reproduce

Click the link "Batch Manager" from the sidebar of the admin panel.

Expected behavior

Load the Batch Manager.

Actual results

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 COUNT(*)
  FROM categories
  WHERE id = 
; in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 856

Fatal error: Uncaught Error: Call to a member function fetch_row() on bool in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php:225 Stack trace: #0 /var/www/piwigo/admin/batch_manager.php(476): pwg_db_fetch_row(false) #1 /var/www/piwigo/admin.php(309): include('/var/www/piwigo...') #2 {main} thrown in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 225
## Environment Piwigo 2.10.1 Operating system: Linux PHP: 7.3.11-1~deb10u1 MySQL: 5.5.5-10.3.18-MariaDB-0+deb10u1 Graphics Library: ImageMagick 6.9.10-23 ## How to reproduce Click the link "Batch Manager" from the sidebar of the admin panel. ## Expected behavior Load the Batch Manager. ## Actual results ``` 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 ``` ```sql SELECT COUNT(*) FROM categories WHERE id = ; in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 856 Fatal error: Uncaught Error: Call to a member function fetch_row() on bool in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php:225 Stack trace: #0 /var/www/piwigo/admin/batch_manager.php(476): pwg_db_fetch_row(false) #1 /var/www/piwigo/admin.php(309): include('/var/www/piwigo...') #2 {main} thrown in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 225 ``` <!-- github-sync-id:533915307 -->
adam closed this issue 2026-10-05 00:26:54 +02:00
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#989