This is a really weird problem.
I upgraded to version 3.3 recently (yesterday) and everything went smoothly. When I checked my forum this morning I had one of my authors tell me that she couldn't manage her story. When she clicked the link, there was nothing there for her, yet the story was still listed under her profile.
I went to my test site and added a new user and tried to upload a new test story. The results were that everything did like it should and the story was seemingly added, but when I went to the main page it didn't show up in the recent stories list. It didn't show in the author's profile or anywhere else. I even checked the validation list on the off chance that it would show there, but still, nothing. However, when I clicked on the manage stories link for the new user, the story was listed there as it normally would be.
It should also be noted that on my main site, the stories I had added before the bridge for those accounts also before the bridge did show up. I didn't think to check on stories added after the bridge.
On the off chance that the differences between the two versions weren't too large, I uploaded the 3.2.1 files I had from the 13th of this month (several chapters had been added and I didn't want to loose them) and ran the update on my test site. It went smoothly and everything was working, including the issues listed above. The story I first added never showed up again,( it even vanished from the manage stories list) but the new one I added to test the the roll back did, so I went ahead and did the same to my main site. So far so good.
My site is bridged with SMF and nothing even remotely like this has ever been reported before. I have no clue what is going on with this one. Any help would be appreciated.
Also, is it safe to roll back my update the way that I did?
PS I'll change the test site back to the 3.3 version so that you can test if you'd like. Tammy already has a test account there.
PPS After changing back to version 3.3 I noticed that the new story that did get added was still showing up. I tried to add another new one and it showed to. So I decided to check the stories/profile directory and found that both stories are in a file for that user, but that the one that wouldn't show had been added to the stories/ directory. It looks to me like the profile directory for the new user wasn't created the first time had 3.3 installed, and so the story was added directly to the stories folder. When I added a story when I had it rolled back to 3.2.1, the profile folder was created and the story added, so that when I went back to 3.3 and tried to add another new story, it went into the correct folder.
I still don't see what this has to do with the original problem, of the member who couldn't edit her story but it's something at least.
I created another new user and tried adding another story. As with the last time, everything did as it should, but when I was redirected to the Manage Stories page, the story that had been missing showed up in the new account.
Checking with my ftp, there was no profile folder for the new account and the new story had been added directly to the stories folder once again. It still doesn't show up on the main page, the most recent list, or anywhere but the new user's Manage Stories page.
It's as if 3.3 is using the stories folder as the profile folder for new users. This isn't the exact same problem as the member above reported, but it may be from the same cause.
Anyway, now that I have some time I'll do a bit more checking.
EDIT Just heard from the author again. Using the 3.2.1 files seems to have fixed the problem she was having too.
It looks like I'm the only one having this problem. Anyone else having issues where if a user doesn't already have a profile folder, the script adds that user's story directly to the stories folder? Or issues like my first post, where after the 3.3 upgrade the author isn't able to get to her stories with her account info page, but it's still listed under her name in the stories list and profile page?
I'd just like to confirm that I'm not completely crazy, here. 🙁
I took my SMF bridge apart. 🙁 Did you update all the bridge files when you upgraded? There are updated bridge files in the bridges folder.
Everything except the stories, tinymce, and skins folder. The first issue sounds a bit like what was happening in this thread: https://efiction.org/forums/index.php?topic=5310.msg28749#msg28749 only without the warnings. Do you think it could be something like that?
But then again, it seems to be only happening to me. I'd just try the fix, but I don't know which file to edit in the case of stories instead of images.
I'll download 3.3 again and reupload the files, just in case something got corrupted during download. Thanks for spending so much time on this. If all else fails, I'll just stick with the 3.2.1 files.
I've yet to update my bridged sites..so I won't know until this weekend when I get to them if this problem repeats itself with my setup. I will let you know either way though.
I'd think its more likely that the login function isn't working correctly. It's not finding the user's id if it's putting the files in the main stories folder instead of their folder.
In the bridge get_session_vars.php file change line 26 to:
$eficdata = dbquery("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, ap.* FROM ".TABLEPREFIX."fanfiction_authorprefs as ap RIGHT JOIN "._AUTHORTABLE." ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '$ID_MEMBER'");
That didn't work. As soon as I signed up with a new member account, I clicked on manage stories and the two stories that were 'missing' (the ones that went into the stories folder) showed up as stories for the new account. Clicking on the stories lead to an error page saying that they don't exit. I then tried to add a story again and it's now in the stories folder with the other two and there is still no profile folder for the new member.
I did find some new info that may help. With your test account, your name comes up on the members and authors list, but when I as an admin tried to add a chapter to your test story, your name isn't in the list of authors. The same thing with the new test accounts. They show up on the members list, but not when trying to add a story or chapter to their accounts as admin.
I hate to bother you again, but I wanted to ask if you had found out anything else about this?
I just tested this on my bridged site. It's occurring as well. The new user isn't getting a folder created to store their stories. THe script acknowledges that there's a story awaiting validated, but can't find it to pull it up when you view submissions.
EDIT: alright, here's what I'm observing:
I used the new test account on my site. Logged in, submitted a story. It shows in the user's manage stories. I log out, log in as admin, tells me I have a submission to be validated. I go to the Submissions link and nothing shows, even after clicking View all. I look at the stories folder and the new txt file is in the main stories folder. A folder for the new user is not created. I took a look at the stories table in efic and noticed the uid for the story and the chapter is 0. I'm thinking this might be something, but I don't understand how the story hows up in the user's manage stories. Also, after I validate the user as an author, there is no change either.
EDIT2: I just went back and logged in as the user. Now the submitted story won't show under manage stories. I decided to see what would happen if I made the user an admin. As admin, the submitted story doesn't show as outlined above. HOWEVER, if I add a new story with the user who is a now admin and choose that username as the author, the folder for the user is created with the uid number and the txt file is placed there as it should be. Checking the DB, the correct uid is assigned to the story and its associated chapter. So with this, I decide to try out what happens if I go the the 'orphan' story and change the uid to the user it's supposed to be. Once I did this for the story and the associated chapter, the story shows up in the submissions queue as well as the user's manage stories link.
It appears that the issue is the uid=0 for the submitted story and its associated chapter when it should be the uid the user is assigned upon registering when the user is either a validated or unvalidated author that is new after the bridge is implemented and doesn't have a folder already existing.
Darklight, see if you can replicate my findings in my above post on your test site. I think I may have narrowed down what the issue could be.
I just tested this on my bridged site. It's occurring as well. The new user isn't getting a folder created to store their stories. THe script acknowledges that there's a story awaiting validated, but can't find it to pull it up when you view submissions.
EDIT: alright, here's what I'm observing:
I used the new test account on my site. Logged in, submitted a story. It shows in the user's manage stories. I log out, log in as admin, tells me I have a submission to be validated. I go to the Submissions link and nothing shows, even after clicking View all. I look at the stories folder and the new txt file is in the main stories folder. A folder for the new user is not created. I took a look at the stories table in efic and noticed the uid for the story and the chapter is 0. I'm thinking this might be something, but I don't understand how the story hows up in the user's manage stories. Also, after I validate the user as an author, there is no change either.
After checking my database, I can confirm this.
EDIT2: I just went back and logged in as the user. Now the submitted story won't show under manage stories. I decided to see what would happen if I made the user an admin. As admin, the submitted story doesn't show as outlined above. HOWEVER, if I add a new story with the user who is a now admin and choose that username as the author, the folder for the user is created with the uid number and the txt file is placed there as it should be. Checking the DB, the correct uid is assigned to the story and its associated chapter. So with this, I decide to try out what happens if I go the the 'orphan' story and change the uid to the user it's supposed to be. Once I did this for the story and the associated chapter, the story shows up in the submissions queue as well as the user's manage stories link.
Confirmed again.
I had the line right but the change wrong. Change it to:
$eficdata = dbquery("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, ap.level, ap.userskin, ap.ageconsent FROM ".TABLEPREFIX."fanfiction_authorprefs as ap RIGHT JOIN "._AUTHORTABLE." ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '$ID_MEMBER'");
I just did a quick test and so far this seems to have worked. Thank you so much Tammy! I'll do some more tests and get back to you if I run into anything else.
Thanks again 😀
