Forum

Notifications
Clear all

Matching Story ID To Text File

morgandawn
(@morgandawn)
Active Member

A user mistakenly deleted her fic.  She is looking for a specific story stored in the backup I have of her userid folder. the problem: the story  is multi chaptered and the storyid we had does not match up to any of the txt files.

Ex: Author User ID folder
Story ID: 5575 (for the first chapter. we don't have the IDs for the next ones)
All the text files in her folder are 16792

There are over 100 text files in the folder and many have no titles in the body of the text.

Quote
Topic starter Posted : 17/04/2016 12:52 am
banshee
(@banshee)
Member Admin

Hi there,

Do you have a backup of the MySQL database as well? The text files are given the name of the Chapter ID (chapid) in the _chapters table, and not the story.

Generally those text files should only contain the chapter itself, as the title of the chapter (as well as the description and stats) are saved in the database.

eFiction Archives: Tom Paris Dorm | Twice Bitten | Underground

ReplyQuote
Posted : 17/04/2016 1:45 am
Lyndsie
(@lyndsie)
Member Moderator

I had the same issue for an author who deleted a hundred plus chapter story. She had hundreds of chapters. I ended up uploading my database backup to my test server and running a query to pull all chapter IDs for that story.

I was able to restore it to the site and I did post about it so you could include my username in a search here of you want to find it.

ReplyQuote
Posted : 20/04/2016 7:16 am
Lyndsie
(@lyndsie)
Member Moderator

Hah! Found it.

http://efiction.org/forums/index.php?topic=5123.msg29109#msg29109

ReplyQuote
Posted : 20/04/2016 7:28 am
morgandawn
(@morgandawn)
Active Member

Thank you. I'll let the author know.

ReplyQuote
Topic starter Posted : 20/04/2016 6:43 pm
Share: