[Chuck S]

UPDATE photos set approved='1' WHERE approved='0'

Now you try under scan database Check here to recalculate photos/posts numbers and check children.

I am assuming this is all you dropped.