Forum

How do we find orph...
 
Notifications
Clear all

How do we find orphaned stories in the database?

Talullah
(@talullah)
Trusted Member

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!

Quote
Topic starter Posted : 08/10/2008 8:26 pm
Tammy
(@tammy)
Member Moderator

Do a search in the stories table for a story with an empty categories field or one set to 0.

ReplyQuote
Posted : 11/10/2008 1:26 am
Talullah
(@talullah)
Trusted Member

Ooh, okay - thanks!

ReplyQuote
Topic starter Posted : 11/10/2008 6:27 am
Talullah
(@talullah)
Trusted Member

Hi,

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'?

Thank you.

ReplyQuote
Topic starter Posted : 04/01/2020 11:14 am
Share: