[15.0.0] parent album deletion generates batch management errors #1958

New Issue

Closed

opened 2026-10-05 01:02:19 +02:00 by adam · 3 comments

adam commented 2026-10-05 01:02:19 +02:00

Owner

Copy link

Copy source

After installing and setting up Piwigo, I created a hierarchical album structure as follows:

• Parent album: "Art"

  • Sub-albums: "Art1", "Art2", "Art3"

I uploaded several photos into these sub-albums. When I deleted the parent album "Art," I selected the option to keep the photos. Following this deletion, I encountered the following unexpected behavior:

1. Photos remained as orphans, and accessing the Orphan Photos, Batch Manager, or Recent Photos sections resulted in the following error:

Warning: Array to string conversion in /app/www/public/include/functions_category.inc.php on line 159

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Array' in 'where clause' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132
Stack trace:
#0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query()
#1 /app/www/public/include/functions_category.inc.php(161): pwg_query()
#2 /app/www/public/include/functions_html.inc.php(186): get_cat_info()
#3 /app/www/public/admin/include/batch_manager_filters.inc.php(119): get_cat_display_name_from_id()
#4 /app/www/public/admin/batch_manager_global.php(434): include('...')
#5 /app/www/public/admin/batch_manager.php(812): include('...')
#6 /app/www/public/admin.php(346): include('...')
#7 {main} thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132

Steps to Reproduce:

Create a parent album and add sub-albums.
Upload photos to the sub-albums.
Delete the parent album and select the option to retain photos.
Access sections like Orphan Photos, Basket (I don't know if 'basket' is the correct word, my menu is in another language, sorry) , Batch Manager, or Recent Photos.

Edit: I dropped the database and started a new installation, and confirmed that this is indeed an error. I have inserted screenshots to better illustrate.

Expected Behavior: Parent and sub-albums should be deleted, the orphaned photos should not trigger an error in the Batch Manager or Orphan Photos sections.

After installing and setting up Piwigo, I created a hierarchical album structure as follows: - Parent album: "Art" - Sub-albums: "Art1", "Art2", "Art3" I uploaded several photos into these sub-albums. When I deleted the parent album "Art," I selected the option to keep the photos. Following this deletion, I encountered the following unexpected behavior: 1. Photos remained as orphans, and accessing the Orphan Photos, Batch Manager, or Recent Photos sections resulted in the following error: ``` Warning: Array to string conversion in /app/www/public/include/functions_category.inc.php on line 159 Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Array' in 'where clause' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /app/www/public/include/functions_category.inc.php(161): pwg_query() #2 /app/www/public/include/functions_html.inc.php(186): get_cat_info() #3 /app/www/public/admin/include/batch_manager_filters.inc.php(119): get_cat_display_name_from_id() #4 /app/www/public/admin/batch_manager_global.php(434): include('...') #5 /app/www/public/admin/batch_manager.php(812): include('...') #6 /app/www/public/admin.php(346): include('...') #7 {main} thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132 ``` **Steps to Reproduce:** Create a parent album and add sub-albums. Upload photos to the sub-albums. Delete the parent album and select the option to retain photos. Access sections like Orphan Photos, Basket (I don't know if 'basket' is the correct word, my menu is in another language, sorry) , Batch Manager, or Recent Photos. Edit: I dropped the database and started a new installation, and confirmed that this is indeed an error. I have inserted screenshots to better illustrate.   Expected Behavior: Parent and sub-albums should be deleted, the orphaned photos should not trigger an error in the Batch Manager or Orphan Photos sections. <!-- github-sync-id:2613955510 -->

adam closed this issue 2026-10-05 01:02:19 +02:00

adam commented 2026-10-05 01:02:20 +02:00

Author

Owner

Copy link

Copy source

Hello, do you have the error without deleting orphan photos?

As soon as you have the error, you can go to Ferramentas > Manutenção and perform the Atualizar as informações das fotos. This will perform an invalidate_user_cache which may solve your problem. We're still looking for a solution because in my case I can't reproduce your particular problem.

However, in Piwigo, when you delete a parent album that has sub-albums, all the albums are deleted and if you have photos they become orphaned.

Hello, do you have the error without deleting orphan photos? As soon as you have the error, you can go to `Ferramentas > Manutenção` and perform the `Atualizar as informações das fotos`. This will perform an `invalidate_user_cache` which may solve your problem. We're still looking for a solution because in my case I can't reproduce your particular problem. However, in Piwigo, when you delete a parent album that has sub-albums, all the albums are deleted and if you have photos they become orphaned. <!-- github-comment-id:2438389670 -->

adam commented 2026-10-05 01:02:20 +02:00

Author

Owner

Copy link

Copy source

I just confirmed on a new installation, with a new database, that creating the structure again, uploading the subdirectories, and deleting the parent album along with the orphan photos, the same problem occurs.

Warning: Array to string conversion in /app/www/public/include/functions_category.inc.php on line 159

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Array' in 'where clause' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132 
Stack trace:
 #0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() 
 #1 /app/www/public/include/functions_category.inc.php(161): pwg_query() #2 /app/www/public/include/functions_html.inc.php(186): get_cat_info()
 #3 /app/www/public/admin/include/batch_manager_filters.inc.php(119): get_cat_display_name_from_id()
 #4 /app/www/public/admin/batch_manager_global.php(434): include('...')
 #5 /app/www/public/admin/batch_manager.php(812): include('...')
 #6 /app/www/public/admin.php(346): include('...')
 #7 {main} thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132

Perfom Atualizar as informações das fotos does not work, when a go to " Batch Manager" for example, I still have problems.

Creating a new album and uploading a photo to it solves the problem. It seems to me that the problem is somewhere in this code snippet, but unfortunately, I am not a PHP dev, I don't know how to debug properly.

##https://github.com/Piwigo/Piwigo/blob/65dce73ef82b18e0cd8ff5359ce7624206c5bdbb/admin/include/batch_manager_filters.inc.php#L101-L121

Anyway, since I'm starting a clean install, I can avoid the problem by creating a new album and adding a photo to it, the goal was just to let the team know. If you think it's better, you can close the issue. Thanks for the help!

I just confirmed on a new installation, with a new database, that creating the structure again, uploading the subdirectories, and deleting the parent album along with the orphan photos, the same problem occurs. ``` Warning: Array to string conversion in /app/www/public/include/functions_category.inc.php on line 159 Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Array' in 'where clause' in /app/www/public/include/dblayer/functions_mysqli.inc.php:132 Stack trace: #0 /app/www/public/include/dblayer/functions_mysqli.inc.php(132): mysqli->query() #1 /app/www/public/include/functions_category.inc.php(161): pwg_query() #2 /app/www/public/include/functions_html.inc.php(186): get_cat_info() #3 /app/www/public/admin/include/batch_manager_filters.inc.php(119): get_cat_display_name_from_id() #4 /app/www/public/admin/batch_manager_global.php(434): include('...') #5 /app/www/public/admin/batch_manager.php(812): include('...') #6 /app/www/public/admin.php(346): include('...') #7 {main} thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 132 ``` Perfom `Atualizar as informações das fotos` does not work, when a go to " Batch Manager" for example, I still have problems.  **Creating a new album and uploading a photo to it solves the problem**. It seems to me that the problem is somewhere in this code snippet, but unfortunately, I am not a PHP dev, I don't know how to debug properly. ##https://github.com/Piwigo/Piwigo/blob/65dce73ef82b18e0cd8ff5359ce7624206c5bdbb/admin/include/batch_manager_filters.inc.php#L101-L121 Anyway, since I'm starting a clean install, I can avoid the problem by creating a new album and adding a photo to it, the goal was just to let the team know. If you think it's better, you can close the issue. Thanks for the help! <!-- github-comment-id:2438545584 -->

adam commented 2026-10-05 01:02:21 +02:00

Author

Owner

Copy link

Copy source

I was able to reproduce the problem, and we have a solution that will be in the next release (15.1.0)!

Thanks for your feedback! 😃

I was able to reproduce the problem, and we have a solution that will be in the next release (15.1.0)! Thanks for your feedback! 😃 <!-- github-comment-id:2446215745 -->

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

master

issue-2560-people

translation

16.x

feat/embedding-based-contextual-tagging

issue-2576-search-include-ai-in-search-results

feat/search-ocr-ai

issue-2391-update-menu-design

15.x

detect-container

issue-2386-update-filters-users-activity

issue-2362-add-filters-options-in-admin

issue-2367-imagemagick7

issue-2225-quicksearch-help

14.x

issue-2164-BatchManagerUnitMode-Redesign

13.x

12.x

issue-1657-SVG_Support

issue-1703-historySearchMethod

11.x

2.10

2.9

2.8

2.7

2.5

2.6

2.4

2.3

2.2

2.1

2.0

1.7

1.3

1.6

1.5

1.4

16.4.0

16.3.0

16.2.0

16.1.0

16.0.0

16.0.0RC3

16.0.0RC2

15.7.0

16.0.0RC1

16.0.0beta1

16.0.0beta2

15.6.0

15.5.0

15.4.0

15.3.0

15.2.0

15.1.0

15.0.0

15.0.0beta3

15.0.0beta2

15.0.0beta1

14.5.0

14.4.0

14.3.0

14.2.0

14.1.0

14.0.0

14.0.0RC2

14.0.0RC1

14.0.0beta3

14.0.0beta2

13.8.0

14.0.0beta1

13.7.0

13.6.0

13.5.0

13.4.0

13.3.0

13.2.0

13.1.0

13.0.0

13.0.0RC4

13.0.0RC3

13.0.0RC2

13.0.0RC1

12.3.0

13.0.0beta2

13.0.0beta1

12.2.0

12.1.0

12.0.0

12.0.0RC2

12.0.0RC1

12.0.0beta2

12.0.0beta1

11.5.0

11.4.0

11.3.0

11.2.0

11.1.0

11.0.0

11.0.0beta5

2.11.0beta4

2.11.0beta3

2.11.0beta2

2.11.0beta1

2.10.2

2.10.1

2.10.0

2.10.0RC1

2.10.0beta2

2.10.0beta1

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.9.0RC2

2.9.0RC1

2.9.0beta2

2.8.6

2.8.5

2.8.4

2.9.0beta1

2.8.3

2.8.2

2.8.1

2.8.0

2.8.0RC2

2.8.0RC1

2.7.4

2.7.3

2.6.5

2.5.6

2.5.5

2.6.4

2.7.2

2.7.1

2.7.0

2.7.0RC2

2.7.0RC1

2.7.0beta2

2.6.3

2.7.0beta1

2.6.2

2.5.4

2.6.1

2.6.0

2.6.0RC2

2.6.0RC1

2.6.0beta2

2.5.3

2.5.2

2.6.0beta1

2.5.1

2.5.0

2.5.0RC2

2.4.7

2.5.0RC1

2.4.6

2.5.0beta3

2.5.0beta2

2.5.0beta1

2.4.5

2.4.4

2.4.3

2.4.2

2.4.1

2.4.0

2.3.5

2.4.0RC3

2.3.4

2.4.0RC2

2.4.0RC1

2.3.3

2.4.0beta2

2.4.0beta1

2.3.2

2.3.1

2.3.0

2.3.0RC2

2.3.0RC1

2.2.5

2.3.0beta3

2.2.4

2.3.0beta2

2.2.3

2.2.2

2.3.0beta1

2.2.1

2.2.0

2.2.0RC4

2.2.0RC3

2.2.0RC2

2.1.6

2.2.0RC1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.1.0

2.0.10

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.9

2.0.8

2.0.7

2.0.6

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC4

1.7.3

2.0.0RC3

2.0.0RC2

2.0.0RC1

1.7.2

1.7.1

1.7.0

1.7.0RC2

1.7.0RC1

1.6.2

1.6.1

1.6.0

1.6.0RC2

1.6.0RC1

1.5.2

1.5.1

1.5.0

1.5.0RC2

1.5.0RC1

1.4.1

1.4.0

1.4.0RC3

1.4.0RC2

1.3.4

1.4.0RC1

1.3.3

1.3.2

1.3.1

1.3.0

1.3.0RC2

1.3.0RC1

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

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: adam/Piwigo#1958