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

Crash on adding pictures to non-existing album #2092

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

On selecting a bunch of photos in the Basket, add action 'Associate to album', click on 'Select an album' and type in a non-existing album name. Then click on 'Apply actions'.

The following error message gets displayed in the next web page:
Fatal error: Uncaught mysqli_sql_exception: 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 ') AND (storage_category_id IS NULL OR storage_category_id != category_id)' at line 6 in /var/www/html/xxxxxxxxx/functions_mysqli.inc.php:132 Stack trace: #0 /var/www/html/xxxxxxxxx/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /var/www/html/xxxxxxxxx/admin/include/functions.php(2176): pwg_query() #2 /var/www/html/xxxxxxxxx/admin/batch_manager_global.php(199): move_images_to_categories() #3 /var/www/html/xxxxxxxxx/admin/batch_manager.php(812): include('...') #4 /var/www/html/xxxxxxxxx/admin.php(406): include('...') #5 {main} thrown in /var/www/html/xxxxxxxxx/include/dblayer/functions_mysqli.inc.php on line 132

Note: The path to the file system has been edited to hide the true value.

On selecting a bunch of photos in the Basket, add action 'Associate to album', click on 'Select an album' and type in a non-existing album name. Then click on 'Apply actions'. The following error message gets displayed in the next web page: Fatal error: Uncaught mysqli_sql_exception: 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 ') AND (storage_category_id IS NULL OR storage_category_id != category_id)' at line 6 in /var/www/html/xxxxxxxxx/functions_mysqli.inc.php:132 Stack trace: #0 /var/www/html/xxxxxxxxx/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /var/www/html/xxxxxxxxx/admin/include/functions.php(2176): pwg_query() #2 /var/www/html/xxxxxxxxx/admin/batch_manager_global.php(199): move_images_to_categories() #3 /var/www/html/xxxxxxxxx/admin/batch_manager.php(812): include('...') #4 /var/www/html/xxxxxxxxx/admin.php(406): include('...') #5 {main} thrown in /var/www/html/xxxxxxxxx/include/dblayer/functions_mysqli.inc.php on line 132 Note: The path to the file system has been edited to hide the true value. <!-- github-sync-id:3419821400 -->
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#2092