Hi,
I was trying to move on album (and its sub albums) to another location in the Album Manager. There things seem to look OK but when I go to my site the moved Album isn't shown in the menu.
I have narrowed it down to the selection of categories in functions_category.inc.php, in function get_categories_menu(). There a query
SELECT id, name, permalink, nb_images, global_rank, date_last, max_date_last, count_images, count_categories FROM piwigo_categories INNER JOIN piwigo_user_cache_categories ON id = cat_id and user_id = 1 WHERE 1 = 1 ;
is run to retrieve the categories. The moved category doesn't show up there because it doesn't have an entry in the piwigo_user_cache_categories!
Since it worked before I'm not sure what I have done and how to correct it? I already tried "Purge user cache" but that didn't help.
Any help highly appreciated!
Thomas
Piwigo 2.9.2
Operating system: Linux
PHP: 5.6.32 (Show info) [2017-11-24 22:20:45]
MySQL: 5.5.57-0+deb7u1-log [2017-11-24 22:20:45]
Graphics Library: External ImageMagick 6.8.9-9
Offline
As a test I have deleted all entries in piwigo_user_cache_categories et voila - no albums are shown.
Is that really the intended behavior? In that case the name "user_cache" for this table is really really wrong...
Is there any way to rebuild this cache? I was changing the album to "Lock" and back, hoping that this would somehow lead to updates in the table but that didn't help either.
Thanks,
Thomas
Offline
I have added missing entries manually and also needed to set all albums back to "public" - now they are visible again :-)
Today I tried movong some more albums and for some reason this time it worked without issues. Not sure what I have done differently this time, Will play around a bit more and post my results.
Offline
thank you for your report
please continue to report any issue like this and we will try to understand what's going there
Offline