URL to your eFiction: http://fics.babaca.org
Version of eFiction: 3.4
Have you bridged eFiction, if so with what?: no
Version of PHP: 5.0.4
Version of MySQL: 4.1.13
Have you searched for your problem: yes
If so, what terms did you try: co-authors
State the nature of your problem:
Since upgrading to 3.4 I noticed that when you look at stories that you know have co-authors, only the main author is present on the story. If you look at Authors list the co-authors are there but if you click on their name it credits them with a story but the story is not listed. If you search by the co-author you get no results.
For instance, if you look up Stephanie on my site: http://fics.babaca.org/viewuser.php?uid=37
It claims she has a fic but nothing is listed.
If you know that story she co-wrote was called Half-Time: http://fics.babaca.org/viewstory.php?sid=33&chapter=1
the only author listed is DaMoyre except in the body of the fic where Stephanie is mentioned.
If you look at the story index: http://fics.babaca.org/viewstory.php?sid=33
Only DaMoyre is listed.
I tried to fix another co-author situation with bonne by editing the story and adding her back as a co-author. Now if you look in her profile:
http://fics.babaca.org/viewuser.php?uid=36
it says she has 2 stories when really it's only one.
barb
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Reupload the storiesby.php file in the users/ folder.
I did and nothing has changed.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Go into phpmyadmin and look at the coauthors table. Does it have content? If so, do a search for uid 33 (Stephanie) is she listed?
Nope she's not there. Only the one I edited through efiction is there.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Yeah, I just found my mistake with the update script. Do you have a backup of your database?
Yeah, but I just fixed it in phpmyadmin. I'm sure I'm not the only one with this problem, but if you want me to I can go ahead and put the backup on.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
I uploaded 3.4.1 and it fixed the error I made on one of my co-authors. It recalculated the stories and fixed bonne's 2 stories down to 1 story.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Yeah, I have this problem too, only I get this error when I try to edit a story:
A fatal MySQL error was encountered.
Query: SELECT uid FROM efiction_coauthors WHERE sid = '77694'
Error: (1146) Table 'fanfiction_data.efiction_coauthors' doesn't exist
Only the table exists as efictionfanfiction_coauthors. sid and uid are correct.
Upgrade to 3.4.1
If 3.4.1 is what is available under downloads, then yes, I've upgraded three times already. I've uploaded all the files over my existing files and ran update.php. And still, I am getting:
A fatal MySQL error was encountered.
Query: SELECT uid FROM efiction_coauthors WHERE sid = '77694'
Error: (1146) Table 'fanfiction_data.efiction_coauthors' doesn't exist
EDIT: Odd. When I go to version check, I get:
You are currently running eFiction version 3.4.
The current version of eFiction is 3.4.1
You need to update.
Yet, when I go to archive maintenance:
This update has already been completed. No further action is needed.
And when I run update.php, I get Update Complete as well.
EDIT AGAIN: I manually editted the settings table so now I'm "up-to-date", but the error is still happening.
EDIT AGAIN: I found the problem. In stories.php on line 53, the code was:
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."_coauthors WHERE sid = '$sid'");
when it should've been
$cQuery = dbquery("SELECT uid FROM ".TABLEPREFIX."fanfiction_coauthors WHERE sid = '$sid'");
I am now able to edit co-authored stories. However, I am still unable to answer reviews as a co-author, and the story does not show up with my co-authored name next to it.
Can you please check and see if this is still an issue with 3.5? Thank you!
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
No response... assumed solved.
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
