I had this up and working last week and as I recall you may need to go through some of the sql to ensure that enverything is loaded. But, as I recall the most crucial bug is that one of the needed .sql files isn't imported automaticly − importing this manually into you db should do the trick...
I committed the photo-album code on HEAD in the contrib
directory. It does not have the oracle support or any
other work other folks have done but since it's in CVS
I think that should be remedied shortly.