4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: edwin on April 21, 2005, 09:10:56 PM

Title: remove range of image_id's
Post by: edwin on April 21, 2005, 09:10:56 PM
I have noticed that i have a range of image-id that not contain a a picture or info
Now i want to remove them, how can i do this the best way, with PHPadmin?

there 41000 picture on my website but the image_id go from 0 until 104000

with regards Edwin

Title: Re: remove range of image_id's
Post by: ManniC on April 21, 2005, 09:35:47 PM
Hi Edwin,

the reason is: By deleting an image the ID remains reserved. There is no continuous range of unused ID's.
Title: Re: remove range of image_id's
Post by: edwin on April 21, 2005, 09:42:33 PM
oke, but if bye example Google or another searchmachine indexes my website, it still will see my reserved image_id?

And what if i still want to remove them, can i expect troubles and if no, how can you this the best
Title: Re: remove range of image_id's
Post by: Chris on April 22, 2005, 12:29:42 AM
oke, but if bye example Google or another searchmachine indexes my website, it still will see my reserved image_id?

No because the image page doesn't exist anymore.  Therefore Google can't index it.

And what if i still want to remove them, can i expect troubles and if no, how can you this the best

They are already removed!  You won't find them in your database.  The image id is an auto_increment data type. This means the number is incremented every time a new row (image) is added.  The number never repeats or gets used again.  Your image ids are not contiguous. http://dictionary.reference.com/search?q=contiguous
Title: Re: remove range of image_id's
Post by: V@no on April 22, 2005, 03:53:14 AM
also, if u would use deleted image ids then it might bring a chaos when search shows one image (the old cached) and in real there is something else...see what I mean?
Title: Re: remove range of image_id's
Post by: edwin on April 22, 2005, 01:59:05 PM
Yes, thank you very much, guys