Announcement

#1 2011-04-06 21:42:17

lisaviolet
Member
san diego, california
2011-01-03
334

Is this a bug? How do I undo the time stamp for the metadata?

I've been playing with the config code for hours each day and it's not presenting the way I want.

Code:

$conf['order_by'] = ' ORDER BY date_creation DESC, file ASC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

It works nicely when there is only one day's worth of images in the category, but if there are more, it doesn't work. This only started when I batch synched the metadata to get the time stamp to show.

I'd rather have the pictures in order than show the time they were taken.

Last edited by lisaviolet (2011-04-07 17:21:50)

Offline

 

#2 2011-04-07 17:22:31

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

I took a screenshot of one of the galleries with this problem.

The photo names as uploaded are as follows:

110303004.jpg
110303003.jpg
110303002.jpg
110303001.jpg
110227002.jpg

Last edited by lisaviolet (2011-04-11 20:44:09)

Offline

 

#3 2011-04-11 14:31:30

Gotcha
Former Piwigo Team
Pourrières (83) [FR]
2007-03-14
604

Re: Is this a bug? How do I undo the time stamp for the metadata?

Hi lisaviolet,

I do not see where is the problem. The sorting is done on the creation date on your screenshot...

The creation date is unique to a second loan.
If a number of photos have the same creation date, it will (depending on your exmple) the file name to be taken into account.

Nota : [Forum, topic 17382] How do I set the default sort order?

Offline

 

#4 2011-04-11 15:45:18

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

And it didn't.  I'd like all photos taken on March 1 to be first in the listing.  Then I'd like them to be sorted by file name, ascending.  So, March 1 would be picture 1 (taken before picture 2), picture 2 (taken before picture 3), picture 3 (taken before picture 4), picture 4....I think you get the idea.

How they're being presented is all photos taken on March 1, picture 4, picture 3, picture 2, picture 1.

So, when I upload pictures of my husband working on a project, they're showing the finished project first, then going backwards to when he started. 

The code: date_creation DESC, file ASC

Look again at the picture and the time stamp. And the names of the images. "file ASC" is being ignored.

But I found out yesterday if I REupload all of the images using the pLoader and overwrite all the pictures I've posted, they show in the correct order. The problem occurred when I did the batch synch of the metadata after the upgrade.  I did that to get the time stamp on them, now I wish I'd not bothered.  Because I'm going to have to reinput all of the information I have on them.

Last edited by lisaviolet (2011-04-11 15:46:50)

Offline

 

#5 2011-04-11 15:52:56

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

Code:

$conf['order_by'] = ' ORDER BY date_creation ASC, file ASC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

try ASC rather than DESC
the order here will bo go step by step like say the followin
ORDER BY DATE ASC THEN IF TWO OR MORE HAVE THE SAME ORDER , THEN ORDER (THOSE WHO HAVE SAME ORDER) BY FILE ASC,
IF TWO OR MORE FILE HAVE THE SAME ORDER THEN ORDER (THOSE WHO HAVE SAME ORDER) THEM BY ID;

i hope u get it now

Offline

 

#6 2011-04-11 16:36:31

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

But I want the newest days to post first. (DESC)

3-21-2011, 3-11-2011, 3-01-2011.

Then the pictures oldest to newest (ASC)

pic 1
pic 2
pic 3

Wouldn't doing it ASC make the oldest days first? 

3-01, 3-11, 3-21

Offline

 

#7 2011-04-11 16:39:37

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

lisaviolet wrote:

But I want the newest days to post first. (DESC)

3-21-2011, 3-11-2011, 3-01-2011.

Then the pictures oldest to newest (ASC)

pic 1
pic 2
pic 3

Wouldn't doing it ASC make the oldest days first? 

3-01, 3-11, 3-21

you know what even u dont understand me o i dont understand u xD
plz give full details with example , maybe even i think i m good in english but cant get ya wat do u mean

wait for ya xD

Offline

 

#8 2011-04-11 17:20:16

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

Okay, here's a link to one of the problem categories.

http://www.lisaviolet.net/gallery/index … ategory/15

I took 17 pictures on 2-23. 

The only one that's where it should be in that series of images is the pair of socks on the second page. 

The images I uploaded were numbered as following:

110223001walks.jpg  ---- wheelchair access to the dirt (stupid way government spends money)
110223002walks.jpg
110223003walks.jpg
110223004walks.jpg
110223005walks.jpg

through

110223017walks.jpg ---- socks

They show on my gallery as 110223016walks.jpg, 110223015walks.jpg, 110223014walks.jpg , 110223013walks.jpg up to 110223001walks.jpg , then you see 110223017walks.jpg. 

Pictures 1-16 are in reverse order (DESC), then there's picture 17 (the one with the socks)

I don't understand why they show the way they do and why only one of them is where it belongs.

Last edited by lisaviolet (2011-04-11 17:21:21)

Offline

 

#9 2011-04-11 17:33:21

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

ok let's see if that could work for ya use this (order asc)

Code:

$conf['order_by'] = ' ORDER BY file ASC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

or this for order desc

Code:

$conf['order_by'] = ' ORDER BY file DESC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

and tell me what happened
if this dont work we will go for complicated check

Last edited by bakir (2011-04-11 17:34:14)

Offline

 

#10 2011-04-11 17:49:18

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

Code:

$conf['order_by'] = ' ORDER BY file ASC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

Pictures go with oldest date first.  I want newest date first.

Code:

$conf['order_by'] = ' ORDER BY file DESC, id ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

All pictures are in descending order. 

*sigh*

Funny how I'd rather change code than re-upload the pictures and just redo the captions and descriptions, isn't it?

Offline

 

#11 2011-04-11 17:59:15

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

i think things going good PIWIGO side, just now it is ur side to work on
i think ur problem that ur photo's is not uploaded correctly (in naming) so u cant use the feature of ordering as possible as can untill u make new mechanism in naming the photo's

i do believe after checking ur site that order by date_available works perfectly, but ur camera tell ya that pic
00000111.jpg (as an example xD) is captured before pis : 00000112.jpg , but the mistake's is in ur side since u uploaded the second one before the first one .

PIWIGO will record the date and time that u uploaded the pic not u captured it,
so please to use such feature like order by date_creation or order by date_available (what ever it works for ya) u need just to be sure to upload the images in the order that captured via ur camera ,
so u can get date compatibility between ur capturing date and uploading date , otherwise pic's will mixed up and u will think this PIWIGO fault , but sorry for this ,it is ur fault .

any problem , we are on the line xD.

i hope u nice gallery and gl and dont forget to tell us about ur PIWIGO experience.
Best Regards

Offline

 

#12 2011-04-11 18:26:21

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

I've tried both the date_available and date_creation.  It was fine before I did the Photo > Batch Manager > Synchronize metadata.

When I number my images, I do number them using the time they were taken, so they'll be in order.

If you look at the photos in the disneyland category (http://www.lisaviolet.net/gallery/index.php?/category/3), they present perfectly, but each day is a sub-category by itself. It's when there's more than one day's worth of photos in the category that things go wrong.

I just HAD to get that time stamp to show up.  *lol*

Thanks for your help.

Last edited by lisaviolet (2011-04-11 18:26:51)

Offline

 

#13 2011-04-11 18:34:56

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

ok to get this solved
let's check ur db for image.

do u have access to ur database , somethin like phpMyAdmin?

Offline

 

#14 2011-04-11 18:36:56

lisaviolet
Member
san diego, california
2011-01-03
334

Re: Is this a bug? How do I undo the time stamp for the metadata?

I sure do.  I learned that when my upgrade didn't go nicely.

Offline

 

#15 2011-04-11 18:39:49

bakir
Translation Team
2011-01-15
89

Re: Is this a bug? How do I undo the time stamp for the metadata?

can we get  screenshot for ur piwigo image table? maybe the section contains the
images ur asking for that for *walk.jpg xD

Offline

 

Board footer

Powered by FluxBB

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