Number of images (weirdness)

[Glovebox]

Hi,

I'm not sure this is the right place to post this but... I've got 402 images in the Doodleblog Archive (http://www.doodleblog.co.uk/index.php?x=browse&pagenum=1) with each page set to display 50 images each, this should mean 8 full archive pages and 2 images on the 9th. What I'm getting is just 8 pages with the ninth empty. The last image on the 8th page is definitely the earliest so why doesn't everything add up?

Cheers,
Simon (Puzzled)

Doodleblog (http://www.doodleblog.co.uk)
Never more than two metres from a doodle...

[Connie]

you have 902 images or is that the highest id?

if 902 is the highest ID, and it shows only 900, so I am sure 2 photos have been deleted sometimes...

"Never more than two metres from a doodle.." ;=)

I always like that page!

[Glovebox]

Thanks for the reply Connie. It is possible that I deleted a couple of images a while back, some times I have to chop around with the sequence of pending images. Actually the highest ID is 415 but there are supposedly 404 images in the database (2 pending). Does this mean that if you delete an image it still stays in the database? Is there any way to reconcile actual images with the database records?

Cheers,
Simon

PS. Glad you like the site!

Doodleblog (http://www.doodleblog.co.uk)
Never more than two metres from a doodle...

[Connie]

this is the old song...

the id's are incremented, every image gets the next number

if you have 100 images and delete #34, the next image will get #101

the images are not kept in the database (they never are...), the dataset of that image is deleted, but the other images are not renumbered...

I think this is the most explained point here in the forum ;=)

if you have a car number:

HH-JW 1034 (that is our car)

and the car with the number HH-JW 560 is broken, not registered anymore, our carnumber stays the same ;=)

[GeoS]

Paged addon is based on MySQL table which stores image categories. It must mean that there are double, triple or even multiple same records with only different column ID.
Look in every cat and find this with incorrect number of images. Then list in phpMyAdmin all records for that category from table {prefix}_catassoc (or something like that) and del same records.