Validate Stories Not Working Right Since 3.2 Update

As I said, I was Adding a story in the Admin menu because I was adding under someone else's name. At the bottom of the admin form there is a little pull down menu.

Yeah that's basically the same form as Add/Edit a story. 🙂 The pulldown menu only shows up in that one, it doens't show up in the actual submissions que you view from the Admin panel -> Submissions, where you then click on the validate links. 

In the future, you might want to include the url of the page of the problems are occuring (right before you validate, or submit). Here the editstory/validate url is different than the submissions/validate url, which is confusing.

So your bugs are: (to eliminate confusion)

- Validating chapter through submissions que does not validate, it disappears.

Purrsia, you might be able to validate the hidden chapter either the way that Dreamy did, or you can edit your database.

First you need to go to the fanfiction_chapters table and search for the chapter. uid is the author's profile number, validated is whether or not the chapter is validated - 1 means validated, 0 means it is not validated. Those two thing should help you find the chapter easily, if you are having problems, try searching fo rthe story id (sid) which is the last numbers listed in the url of the story table of contents.

To do it the way Dreamy did, find the chapter number (chapid) of the chapter and create the url location of it:
http://www. your fanfiction site url goes here/viewstory.php?chapid=#    (replace the # with the actual number)

With your admin powers, edit the story and change the validation from unvalidated or chapter, to story.

OR if that doesn't work

To validate the chapter manually and have it show up, use phpMyAdmin to browse your database. In the fanfiction_chapters table from before, edit the chapter's row and change validated: 0 to validated: 1. If you do it this way, the Favorite update e-mails will not be sent out, as far as I'm aware, so you may want to either personally e-mail the people who have the story listed as a favorite, or add a new chapter.

It should be easy for you to add a new chapter for her: edit the story, go to add new chapter. Copy the text from one of these places: the database if you have it stored there, the file on the server it was saved to, or the unvalidated chapter you found by trying to validate it through Dreamy's way. Or you could always just validate the old chapter and add a new, blank chapter to send the e-mail out, and then delete the blank one right away. I don't think the e-mails list how many chapters there are, so people shouldn't get confused trying to find one more chapter than exists.

Actually, for some reason it's corrected itself. Maybe the first one was a fluke, or maybe it started working properly because I rolled back to PHP 4. I tried it both ways just now and both seemed to show up.

Jan, I would have included an exact url but there technically wasn't anything to include. I didn't get any errors, it just didn't show up until I played around with it.

It's still a good idea to include the URL because then the people trying to help know exactly where to start when trying to track down the problem.

Thanks for the advice. Going into the db was how I did fix the one problematic story, but then, I did a test story and it worked.

Now I have another validation-related issue, but I think it's different than my first, so I'll start a new thread once I poke around in here to make sure it's not already being dealt with.

To fix this, edit line 109 of admin/validate.php from this:

dbquery("UPDATE ".$tableprefix."fanfiction_stories SET updated = NOW( ) WHERE sid = '$sid'");

to this:

dbquery("UPDATE ".$tableprefix."fanfiction_stories SET validated = '1', updated = NOW() WHERE sid = '$sid'");

That should fix it. I've tested it on a couple different stories, but haven't tried it on all the different combinations (author on auto validation, not validated, etc.), so it may fix everything. YMMV, use at your own risk, etc., etc. (I've got version 3.2.1 on an upgrade from 1.1 installed.)

I'm not having any problems with validation at all, so I'm marking this solved. 🙂 i've been testing it for over a month and have validtaed plenty of fics. If you have any future validation problems, please open a new bug topic to avoid confusion. Thank you!

And thank you Tammy, for fixing the problem.