Announcement

#1 2017-11-24 22:21:59

TheDoc
Member
Munich / Germany
2015-10-18
173

piwigo_user_cache_categories corrupt?

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

Code:

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

 

#2 2017-11-25 13:26:26

TheDoc
Member
Munich / Germany
2015-10-18
173

Re: piwigo_user_cache_categories corrupt?

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

 

#3 2017-11-26 12:50:25

TheDoc
Member
Munich / Germany
2015-10-18
173

Re: piwigo_user_cache_categories corrupt?

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

 

#4 2017-11-29 01:02:43

flop25
Piwigo Team
2006-07-06
7037

Re: piwigo_user_cache_categories corrupt?

thank you for your report
please continue to report any issue like this and we will try to understand what's going there


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact