URL to your eFiction: http://www.tokiohotelfiction.com
Version of eFiction: 3.4
Have you bridged eFiction, if so with what?: no
Version of PHP: not sure
Version of MySQL: not sure
Have you searched for your problem: yes
If so, what terms did you try: errors, authors, coauthors
State the nature of your problem: I updated to 3.4 today, because I was having issues with my webhost (they disabled my site), and hoped that updating would solve my issues with MYSQL slow queries and the like. Updating did help, the site is running faster and the webhost has gotten off my back and enabled the site.
Unfortunately, I'm having many issues since updating. I apologize if some of these issues have been brought up somewhere else on the board, I haven't seen much about 3.4 yet.
#1: All coauthors have been stripped from stories.
#2: Some of the author statistics are off. For example, one author has written 24 stories and it says she only wrote one. Some of this we can fix by re-adding coauthors, but the fic # is still off. This has only happened to random members.#3: Random members cannot edit old chapters of their fan fic or upload new ones. They get a blank white page or an error message after they try to submit changes or upload chapters. Some members can't upload chapters, but can upload new fics.
#4: Many authors can't edit their fan fic info. They can't change ratings, summaries, or anything like that.
I feel like all of these problems are connected somehow... maybe?
A shove in the right direction would be amazing, thank you!
EDIT Some of our validators cannot see the text of submitted chapters and stories in the validation queue. Some they can see and some they can't. The chapter or fic just looks blank, but isn't.
Tammy is looking to resolve the co-author problem... expect a fix in a few hours.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Excellent, it'd be great to get that fixed. π
Do you have a backup of your database? If so we can restore the co-authors info, but it's not something I can write a script for. I'll have to work with you individually.
Yes, we have a back up. Could a back up possibly fix the issues with the fan fic count, too?
Yeah, but that I wrote a script for. Update to 3.4.1, then go to Archive Maintenance and run "Recalculate Stories"
Tammy, we ran the update and selected "recalculate stories" and it changed the story count, but not correctly. One of our authors who has 29 fics, had 5 listed before I recalculated the stories, and now has only 4 listed.
In the admin panel it says that "recalculate stories" is for fixing "count and ratings for reviews." We don't have a problem with the review count showing up wrong, but for the actual story count. Am I reading this wrong?
As a side note, we think we sort of figured something out about authors not being able to update chapters. Admins can update chapters, but normal authors cannot. Everyone can upload brand new fics, but only admins are able to actually add or edit chapters. Could this be some sort of permissions thing?
Thanks so much for your help so far, I hope I can figure out this chapter uploading thing really soon, as our authors are chomping at the bit over it.
Scratch that, it just seems to be random...
If your normal authors had been trying to update a coauthor story that could explain it.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
If your normal authors had been trying to update a coauthor story that could explain it.
They haven't been, which is why the error message confuses me. As the day has progressed, I've come to find that about 85% of our authors cannot add new chapters to fan fic. You can imagine that this has put the site at a stand still. π
Does anyone have any sort of idea what I could do to fix this? I don't know what to tell my authors and I'm really lost.
Found out the error here. I had the same error.
Go to your stories.php. On line 53 you'll see this:
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."_coauthors WHERE sid = '$sid'");
The code should actually be this:
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."fanfiction_coauthors WHERE sid = '$sid'");
Found out the error here. I had the same error.
Go to your stories.php. On line 53 you'll see this:
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."_coauthors WHERE sid = '$sid'");
The code should actually be this:
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."fanfiction_coauthors WHERE sid = '$sid'");
CAN I BUY YOU A DRINK?
or something?
Thank you! π
Do you have a backup of your database? If so we can restore the co-authors info, but it's not something I can write a script for. I'll have to work with you individually.
I had the same problem. The co-authors disappeared. I take it they should all now be listed in the co-authors table? Or do they just need to be put back in the table they used to be? I do have a backup of database.
Julieann
Running 3.4.3 bridged with SMF and Coppermine
Mods: Challenges, cpg-art (not working), Limit Summary Length, Bio to Prefs, Top 20 instead of 10
Wants: Move Betareader to Prefs, Twitter
They should all be in the coauthors table now. If you only had a few, it's probably going to be easier for you to use phpmyadmin and just enter them. If you have many, we'll work something up.
They should all be in the coauthors table now. If you only had a few, it's probably going to be easier for you to use phpmyadmin and just enter them. If you have many, we'll work something up.
I am pretty sure our coatuhors table is missing... when we got into PHPmyadmin, the table isn't there. We have a backup of the database, is there anyway to insert the table back in? Would that even fix the problem?
Also, our story counts are still off, despite the new update, and our validators still are having problems reading submissions. Sometimes the text just doesn't show up and I really have no clue as how to fix that.
Fortunately. I had the old table pre-upgrade still up at my test site, so I was able to go into the phpMYAdmin for that, went to the Stories database and chose to browse only the story sid and coauthor uid. Then I sorted those to bring those with co-authors to the first page. Then I just copy and pasted those columns and rows (only had about 1 page worth) into a text document. Placed the single quotes and brackets in the right places and placed those in a simple DB 'insert' statement. Uploaded, and it's working great!
Yay!
The only thing I can see as still a problem with the co-authors is that when you go to a co-authored story, the co-author isn't listed above the story itself. But I believe someone else already mentioned that problem. π
Julieann
Running 3.4.3 bridged with SMF and Coppermine
Mods: Challenges, cpg-art (not working), Limit Summary Length, Bio to Prefs, Top 20 instead of 10
Wants: Move Betareader to Prefs, Twitter