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

Databse-Querry-Error #1651

New Issue
Open
opened 2026-10-05 00:51:37 +02:00 by adam · 2 comments
adam commented 2026-10-05 00:51:37 +02:00
Owner
Copy link
Copy source

When I edit an album and click the checkbox for "Apply settings for sub-albums", I get:

Fatal error: Uncaught mysqli_sql_exception: 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 'OR uppercats REGEXP '(^|,)23(,|$)'' at line 4 in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php(888): pwg_query() #2 /var/www/html/piwigo/include/functions_category.inc.php(323): query2array() #3 /var/www/html/piwigo/admin/cat_modify.php(122): get_subcat_ids() #4 /var/www/html/piwigo/admin/album.php(64): include('...') #5 /var/www/html/piwigo/admin.php(345): include('...') #6 {main} thrown in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 132

When I edit an album and click the checkbox for "Apply settings for sub-albums", I get: Fatal error: Uncaught mysqli_sql_exception: 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 'OR uppercats REGEXP '(^|,)23(,|$)'' at line 4 in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php(888): pwg_query() #2 /var/www/html/piwigo/include/functions_category.inc.php(323): query2array() #3 /var/www/html/piwigo/admin/cat_modify.php(122): get_subcat_ids() #4 /var/www/html/piwigo/admin/album.php(64): include('...') #5 /var/www/html/piwigo/admin.php(345): include('...') #6 {main} thrown in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 132 <!-- github-sync-id:1642392800 -->
adam commented 2026-10-05 00:51:38 +02:00
Author
Owner
Copy link
Copy source

screenshot_21

![screenshot_21](https://user-images.githubusercontent.com/4677678/227999557-d0fc4c86-1039-4aa5-9ea3-f12157b49f85.png) <!-- github-comment-id:1485419186 -->
adam commented 2026-10-05 00:51:39 +02:00
Author
Owner
Copy link
Copy source

hi
it is version piwigo 13.6.0 but have you test version master ?
thanks
la

hi it is version piwigo 13.6.0 but have you test version master ? thanks ![la](https://user-images.githubusercontent.com/36087587/228015086-c4a88e2c-fc05-4815-b04e-60252a0a8e41.jpg) <!-- github-comment-id:1485523727 -->
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#1651