Last updated albums vs last added albums

[Passionate]

When I add new pictures to existing (old) albums in my gallery, they don't show up in the "Last updated Albums" list. Only the last ADDED albums show up. Help? Check the "Last uploads" page and then look at the "Last updated albums". Doesn't match. What am I doing wrong? I tried checking old threads for this, but I just don't get it..  

http://www.aboutjulia.com/juliaimages/

Thanks!  

[Passionate]

Anybody? Pretty please?  :-\\

[Joachim Müller]

http://coppermine.sourceforge.net/faq.php#lamesupport
This issue appears to be a matter of life-or-death for you :-\\

Joachim

[Michael-CGC]

I need to know this to 

[Passionate]

http://coppermine.sourceforge.net/faq.php#lamesupport
This issue appears to be a matter of life-or-death for you :-\\

Joachim

Pretty much..

I'm not trying to be rude, I was just trying to bump the question. I've looked all over for the answer and everything I find says that lastalb SHOULD show the last UPDATED albums and not last ADDED, but that's not the case. I'm just wondering if it's something on my end I'm doing wrong or if it actually shows the last added albums, not updated.

[Nibbler]

It's a known issue I think. (If that isn't a contradiction in terms)

[Casper]

I don't know why this happens, but on 2 of my 3 hosted sites (the first 2 where all my testing used to be) it would be as on your sites, it would be last added, not last updated.
On my latest test site, it works as intended.  This seems to me to be a server setup thing.

[Passionate]

I don't know why this happens, but on 2 of my 3 hosted sites (the first 2 where all my testing used to be) it would be as on your sites, it would be last added, not last updated.
On my latest test site, it works as intended.  This seems to me to be a server setup thing.

Thanks for your answer Casper, then it might be something I will have to direct to my host. Thanks anyway!

[otsorp]

Hi.

First of all, thank you for your nice product! 

I have the same problem as the one described in this thread.
I would like to find out if there's any solution for this?
What exactly do I have to address to my host provider if you say it's on their end?

Regards.

[otsorp]

Can anyone answer my question?

Tnahx.

[yoshikiwei]

This is indeed a bug in the sql (as far as my version is concerned... dated back to 1+ year ago)

Below is the sql I currently used. To truely display last updated album
One problem though, the thumbnail displayed is not a last uploaded picture

Code Select Expand

SELECT *,max({$CONFIG['TABLE_PICTURES']}.ctime) as maxctime,{$CONFIG['TABLE_ALBUMS']}.title AS title,{$CONFIG['TABLE_ALBUMS']}.aid AS aid  FROM {$CONFIG['TABLE_PICTURES']},{$CONFIG['TABLE_ALBUMS']} WHERE {$CONFIG['TABLE_PICTURES']}.aid = {$CONFIG['TABLE_ALBUMS']}.aid AND approved = 'YES' $ALBUM_SET GROUP  BY {$CONFIG['TABLE_PICTURES']}.aid ORDER BY maxctime DESC $limit