Member
Member
dingsbums   2006-05-16, 01:32
#1

hello,

I just found some orphaned id's in my database. I think that happend when I deleted the pics via ftp. Is there a way to delete the old id's? Yes I could do it maually but there are lots!

tia

Developer
Developer
trisweb   2006-05-16, 06:17
#2

It doesn't hurt anything at all. Zenphoto has a pruning function you can run, but it's broken in 1.0.2 (fixed in 1.0.3 coming soon). Until then, just leave it alone, it's not hurting anything.

Member
Member
DarrellD   2006-05-17, 05:19
#3

Actually, sometimes id DOES hurt because at times it would show the thumbnail of a picture i had, then when the user clicks on it, it would say file not found.

At least that's what happened to me before. To fix it, I went into the db and deleted the orphaned id's, cleared the thumbnail cache, then reloaded the albums and all was fine.

Member
Member
Mania   2006-05-17, 06:13
#4

I think they were showing just because the pictures were still in the cache folder.

Developer
Developer
trisweb   2006-05-17, 20:51
#5

It should [b]not[/b] affect the way images are displayed -- all of that is pulled straight from the hard disk, and the database is only secondary.

Trust me, the extra rows in the DB don't have any effect.

As far as what Mania said, that's not possible either... it's probably some other bug (ugh). Well, as long as it's working for now...

Member
Member
DarrellD   2006-06-07, 17:07
#6

Tristan, this is what I was talking about. This is how I found out about the orphaned ID.
http://www.zenphoto.org/support/topic.php?id=577#post-3183

Member
Member
Chilifrei64   2006-06-07, 17:29
#7

little more insight
This will only affect plugins which read directly from the database and not zenphoto itself. When you view his/her gallery, it works fine.. you get a zenphoto error because you are linking from something externally which is generating a link based upon the database information. This does not apply to Zenphoto itself because it looks at the file system first.

Member
Member
DarrellD   2006-06-07, 20:13
#8

Then this leads to the question, why even have the database then?

Member
Member
Chilifrei64   2006-06-07, 20:35
#9

you would use the database for comments, descriptions, timestamps, special image names. Basically, the way I see it.. the image table is really only used to reference either a special name (changed name) of the image and linking it to comments and storing the descriptions... reading filesystem stuff for that is what makes it really slow.

PS. you are driving my RSS reader wild with all your WIKI stuff. Great idea though. I will prolly contribute later tonight.. That will make things much easier.. Good idea..

Member
Member
DarrellD   2006-06-07, 21:24
#10

Oh, sorry. I didn't know that someone was subscribed to it. LoL. =P

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.