Notifications
Clear all

Matching Story ID To Text File

5 Posts
3 Users
0 Reactions
2,241 Views
(@morgandawn)
Posts: 6
Active Member
Topic starter
 

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.


 
Posted : 16/04/2016 5:52 pm
(@banshee)
Posts: 92
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

 
Posted : 16/04/2016 6:45 pm
(@lyndsie)
Posts: 1263
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.


 
Posted : 20/04/2016 12:16 am
(@lyndsie)
Posts: 1263
Member Moderator
 

Hah! Found it.

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


 
Posted : 20/04/2016 12:28 am
(@morgandawn)
Posts: 6
Active Member
Topic starter
 

Thank you. I'll let the author know.


 
Posted : 20/04/2016 11:43 am
Share: