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

zombie album (category with NULL uppercats) #1209

New Issue
Closed
opened 2026-10-05 00:36:04 +02:00 by adam · 6 comments
adam commented 2026-10-05 00:36:04 +02:00
Owner
Copy link
Copy source

Somehow we got an undeletable (because can't open "edit page" where the delete button is) zombie album.
Any help how to get rid of it?
Piwigo 11.4.0

When I try to "Visit the gallery" from admin, I get:
URL: /index.php?/category/60460

<pre><br />
<b>Warning</b>:  [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 7

SELECT 
  id, name, permalink, nb_images, global_rank,
  date_last, max_date_last, count_images, count_categories
FROM categories INNER JOIN user_cache_categories
  ON id = cat_id and user_id = 51
WHERE 
(id_uppercat is NULL OR id_uppercat IN ())
; in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>864</b><br />
</pre><br />
<b>Fatal error</b>:  Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:228
Stack trace:
#0 /var/www/html/galerii/include/functions_category.inc.php(106): pwg_db_fetch_assoc(false)
#1 /var/www/html/galerii/include/menubar.inc.php(98): get_categories_menu()
#2 /var/www/html/galerii/include/menubar.inc.php(15): initialize_menu()
#3 /var/www/html/galerii/index.php(103): include('/var/www/html/g...')
#4 {main}
  thrown in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>228</b><br />

When I click edit on it in admin.php I get:
URL: /admin.php?page=album-60460

<pre><br />
<b>Warning</b>:  [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 4

SELECT
    DISTINCT(image_id)
  FROM image_category
  WHERE category_id IN ()
 ; in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>864</b><br />
</pre><br />
<b>Fatal error</b>:  Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:925
Stack trace:
#0 /var/www/html/galerii/admin/cat_modify.php(199): query2array('\nSELECT\n    DIS...', NULL, 'image_id')
#1 /var/www/html/galerii/admin/album.php(60): include('/var/www/html/g...')
#2 /var/www/html/galerii/admin.php(298): include('/var/www/html/g...')
#3 {main}
  thrown in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>925</b><br />
Somehow we got an undeletable (because can't open "edit page" where the delete button is) zombie album. Any help how to get rid of it? Piwigo 11.4.0 When I try to "Visit the gallery" from admin, I get: URL: /index.php?/category/60460 ``` <pre><br /> <b>Warning</b>: [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 7 SELECT id, name, permalink, nb_images, global_rank, date_last, max_date_last, count_images, count_categories FROM categories INNER JOIN user_cache_categories ON id = cat_id and user_id = 51 WHERE (id_uppercat is NULL OR id_uppercat IN ()) ; in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>864</b><br /> </pre><br /> <b>Fatal error</b>: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:228 Stack trace: #0 /var/www/html/galerii/include/functions_category.inc.php(106): pwg_db_fetch_assoc(false) #1 /var/www/html/galerii/include/menubar.inc.php(98): get_categories_menu() #2 /var/www/html/galerii/include/menubar.inc.php(15): initialize_menu() #3 /var/www/html/galerii/index.php(103): include('/var/www/html/g...') #4 {main} thrown in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>228</b><br /> ``` When I click edit on it in admin.php I get: URL: /admin.php?page=album-60460 ``` <pre><br /> <b>Warning</b>: [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 4 SELECT DISTINCT(image_id) FROM image_category WHERE category_id IN () ; in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>864</b><br /> </pre><br /> <b>Fatal error</b>: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:925 Stack trace: #0 /var/www/html/galerii/admin/cat_modify.php(199): query2array('\nSELECT\n DIS...', NULL, 'image_id') #1 /var/www/html/galerii/admin/album.php(60): include('/var/www/html/g...') #2 /var/www/html/galerii/admin.php(298): include('/var/www/html/g...') #3 {main} thrown in <b>/var/www/html/galerii/include/dblayer/functions_mysqli.inc.php</b> on line <b>925</b><br /> ``` <!-- github-sync-id:872950434 -->
adam closed this issue 2026-10-05 00:36:04 +02:00
adam commented 2026-10-05 00:36:05 +02:00
Author
Owner
Copy link
Copy source

nvm. for some reason in the SQL this category lacked value for "uppercats" (was NULL). added its own number and was able to edit and delete it. Dunno really how this could have happened. Any clues?

nvm. for some reason in the SQL this category lacked value for "uppercats" (was NULL). added its own number and was able to edit and delete it. Dunno really how this could have happened. Any clues? <!-- github-comment-id:830350268 -->
adam commented 2026-10-05 00:36:06 +02:00
Author
Owner
Copy link
Copy source

No clue how it happened, but there is a specific maintenance task for this on [Admin > Tools > Maintenance].

No clue how it happened, but there is a specific maintenance task for this on [Admin > Tools > Maintenance]. <!-- github-comment-id:831167791 -->
adam commented 2026-10-05 00:36:07 +02:00
Author
Owner
Copy link
Copy source

No clue how it happened, but there is a specific maintenance task for this on [Admin > Tools > Maintenance].

which one of them?

> No clue how it happened, but there is a specific maintenance task for this on [Admin > Tools > Maintenance]. which one of them? <!-- github-comment-id:831466508 -->
adam commented 2026-10-05 00:36:07 +02:00
Author
Owner
Copy link
Copy source

Update albums' information

> Update albums' information <!-- github-comment-id:831770877 -->
adam commented 2026-10-05 00:36:08 +02:00
Author
Owner
Copy link
Copy source

Since we don't know how the album became zombie (thus impossible to reproduce), I close this issue.

Since we don't know how the album became zombie (thus impossible to reproduce), I close this issue. <!-- github-comment-id:834345149 -->
adam commented 2026-10-05 00:36:09 +02:00
Author
Owner
Copy link
Copy source

Found another one of those undeletable albums. Your suggested [Admin > Tools > Maintenance > Update albums' information ] does not fix this! Maybe it's another issue...

Found another one of those undeletable albums. Your suggested [Admin > Tools > Maintenance > Update albums' information ] does not fix this! Maybe it's another issue... <!-- github-comment-id:838408592 -->
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#1209