Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Last updated albums vs last added albums  (Read 4863 times)

0 Members and 1 Guest are viewing this topic.

Passionate

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Last updated albums vs last added albums
« on: January 26, 2005, 12:21:00 pm »

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!  :-*
Logged

Passionate

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Last updated albums vs last added albums
« Reply #1 on: January 27, 2005, 02:47:09 pm »

Anybody? Pretty please?  :-\\
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Last updated albums vs last added albums
« Reply #2 on: January 27, 2005, 06:53:24 pm »

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

Joachim
Logged

Michael-CGC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Last updated albums vs last added albums
« Reply #3 on: January 27, 2005, 09:51:48 pm »

I need to know this to  :)
Logged

Passionate

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Last updated albums vs last added albums
« Reply #4 on: January 28, 2005, 12:37:16 pm »

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.
Logged

Nibbler

  • Guest
Re: Last updated albums vs last added albums
« Reply #5 on: January 28, 2005, 02:24:00 pm »

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

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Last updated albums vs last added albums
« Reply #6 on: January 28, 2005, 08:38:24 pm »

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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

Passionate

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Last updated albums vs last added albums
« Reply #7 on: January 30, 2005, 12:10:36 pm »

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!
Logged

otsorp

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Last updated albums vs last added albums
« Reply #8 on: March 10, 2005, 05:49:37 pm »

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.
Logged

otsorp

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Last updated albums vs last added albums
« Reply #9 on: March 14, 2005, 03:55:02 pm »

Can anyone answer my question?

Tnahx.
Logged

yoshikiwei

  • Contributor
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Posts: 68
Re: Last updated albums vs last added albums
« Reply #10 on: April 01, 2005, 11:57:10 am »

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]
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
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.