edit published date bug ?

[giant]

I change image date, in admin panel , image list ...like this..

[edit] #29, Title: 111, file-name:20050627002014_showimg-close2.jpg
dimensions: 633 x 480, 99.972 Kb
to be published: 2005-01-26 18:18:14
[delete] categories: [222] [edit] #4, Title: hohohohi, file-name:20050626153117_showimg-basketball.jpg
dimensions: 633 x 480, 93.086 Kb
to be published: 2005-01-26 15:29:17
[delete] categories: [222] [edit] #36, Title: hohoho-2, file-name:20050627003442_showimg-sunset.jpg
dimensions: 635 x 480, 37.877 Kb
to be published: 2004-08-21 14:32:42
[delete] categories: [222] [edit] #1, Title: hohoho!, file-name:20050626124256_showimg-sunset2.jpg
dimensions: 635 x 480, 38.858 Kb
to be published: 2004-08-21 12:38:56
[delete] categories: [222]

and when I C the image, the IMAGE_PREVIOUS_ID alaways wrong....
is this a BUG ?

thanks..

[Connie]

I am quite sure, I can read your mind.

You tell us "it is wrong" but you do not say what is it.
But I can imagine what you mean:

again, again, again: the Image-ID is not the number of the image as you think...

it's a technical ID, it could be AAA or LSKFOI or something else

if you store an image in the database it get's an unique ID to identify this special image
if you delete this special image the ID is not used anymore

there is no need to have all IDs in consecutive numbers because that would mean that you have to change the IDs of all images because you delete one image...

so, please, accept it. It is database technique.

ok?


8)

[raminia]

sorry this may seem rude but I think it's right of the others:

@Connie
Please do not answer these posts about ID number! If they think it is wrong an nobody answer them they might feel that they are wrong. Then they would try to search an learn.

I respect the forum community and we are here for help but not to be a tutor.

[giant]

sorry．．．I not mean The ID is wrong...

I mean, when I change the Image publish date.

when I goto my browser image webpage,

my the template , I use..

[A]
<div style="text-align:center"><a href="index.php?showimage=<IMAGE_PREVIOUS_ID>"><img id="image" src="images/<IMAGE_NAME>" alt="<IMAGE_TITLE>" title="previous: <IMAGE_PREVIOUS_TITLE>" /></a></div>

but, in the <IMAGE_THUMBNAIL_ROW> sort by publish date..
when I use up html and template TAG ,I'll get

[B]
1(id:33) 2(id:34) 3(id:12) 4(id:55) 5(id:10)


if now [A] display 4(id:55) image,
when I click [A] the previous to show, it'll show 2(id:34).

I think it must show 3(id:12) not to show 2(id:34).

maybe have a TAG is <IMAGE_PREVIOUS_DATE_ID>
to show with publish date by sort row thumbs.

sorry, MY pool english...　:(

[giant]

I don't know how to use mysql language to

sort by publish date, and renew ID by publish date..


so , I do this Stupid way to fix my problem.

I sort by datetime, then export my sql data, then I renew ID by 1,2,3,.... with new sort, save it.

then re import to my sql data.

ok, it's fix.

[raminia]

I don't underestand the bug here.

You mean that if you change the publish date the thumbnail row does not show up correctly? Or it has some contractions with shown image?

[raminia]

what did you changed? where? in index.php?
in your db?