How do we find orphaned stories in the database?
URL to your eFiction: http://www.libraryofmoria.com/a
Version of eFiction: 3.4.3
Have you bridged eFiction, if so with what?: Nope
Version of PHP: 4
Version of MySQL:
Have you searched for your problem: Yes
If so, what terms did you try: Orphan, orphaned story, find orphaned story
State the nature of your problem: when I went to the most recent page, right after submitting a story, I got an orphaned story notice - I saw something that I thought was the title, but later turned out to be the name of the first author in the database. I can't find the story, though. I tried searching the archive and the database.
Do you have a test account for us? The one that comes with the archive
I'd be grateful for any info that helps me find and tidy up this thing. Thanks!
Do a search in the stories table for a story with an empty categories field or one set to 0.
Ooh, okay - thanks!
In the same vein, recently I deleted an author when I meant to delete the story first. The story is now orphaned ( http://www.libraryofmoria.com/a/viewstory.php?sid=1011&ageconsent=ok&warning=4) but I can't see it in the database when searching by title or sid.
How do I get rid of that 'ghost'?