I'm a mod over @ twilightarchives.com and I've been having problems. There are three stories in the submissions that simply won't go away, even after deleting or validating. How can I get rid of these stories?
When I try to edit them, it says error because these stories basically don't exist.
http://twilightarchives.com/admin.php?action=validate&chapid=15027
And these codes show up when I open the stories:
Warning: fopen(stories//.txt) [function.fopen]: failed to open stream: No such file or directory in /home/runepeac/public_html/twilightarchives/admin/validate.php on line 59
Warning: filesize() [function.filesize]: stat failed for stories//.txt in /home/runepeac/public_html/twilightarchives/admin/validate.php on line 60
Warning: fread(): supplied argument is not a valid stream resource in /home/runepeac/public_html/twilightarchives/admin/validate.php on line 60
Warning: fclose(): supplied argument is not a valid stream resource in /home/runepeac/public_html/twilightarchives/admin/validate.php on line 62
Could you fill out the Support Request Template? (It's stickied at the top of each board.) It would really help, particularly to know your version of eFiction because of the line numbers in those messages.
Anyway, going with 3.5.1, the most recent, here's the section it seems to be mentioning.
if($store == "files")
{
$file = STORIESPATH."/$stories[uid]/$stories[chapid].txt";
$log_file = fopen($file, "r");
$file_contents = fread($log_file, filesize($file));
$storytext = $file_contents;
fclose($log_file);
}
In other words, it's failing to open the files for those stories, most likely because they don't exist. Couple of things to verify.
1. In your settings, you have it set to store the story text in files, right? And this is actually set properly, with the path and all? (perhaps mysql got switched to files, but if this is so then the answer to #3 will be definitely NO.)
2. Does the story text appear in these phantom stories? (I'm guessing no.)
3. Are members able to upload stories and have them validated without any trouble?
If the answer to #s 1 and 3 is yes and 2 is no, then what I would suggest you do is this. You need to create the story text and then try to delete the story. You may simply be able to edit the story and add some, but I find that unlikely. For each of these chapters, find the author's uid and the story's chapid. This can be done as simply as hovering or clicking the links for the authors name, and the chapter title in story index; or you can look in the database. Then, create a .txt file with the chapid. for instance, if the chapid is 89, the file should be called 89.txt. The contents can be anything you want, but probably should meet your minimum word count limit for the site. Then, put this file in the directory that is numbered to match the author's uid. So if the author's uid is 8, then put 89.txt into the folder inside your stories folder that is labeled with the number 8.
You should now see story text for these stories and be able to delete them.
If that doesn't work, or your answers were different to the questions, then something else is going on. The stories can be deleted from the database manually, but as the information goes across multiple tables (and varies based on your version of eFic) it's much better to try to do it through the web interface.
The easiest solution will be to use phpmyadmin to delete them directly from the database.
