After a member's account is deleted, his/her old ID is still assigned to stories to which s/he was a co-author.
The wireless music box has no imaginable commercial value. Who would pay for a message sent to nobody in particular? (1920)
Tested with version 3.5.
- Created a new coauthored story with Author A, added Author B as coauthor.
- Deleted Author B.
- - Author B was deleted successfully, coauthor table removed row of story ID with author ID.
- - In fanfiction_stories table, coauthors data for story is still listed as 1 and not 0.
(Script needs to check and update fanfiction_stories table to fix coauthor info.)
- Created a new coauthored story with Author A, added Author B as coauthor.
- Tried to deleted Author A.
- - Author A was not deleted, got an error:
A fatal MySQL error was encountered.
Query: SELECT uid FROM fanfiction_coauthors WHERE sid = '1800' LIMIT 1
Error: (1146) Table 'xxx.fanfiction_coauthors' doesn't exist
http://jan-aq.potionsandsnitches.net/fanfiction/admin.php?action=members&confirm=yes&delete=2124
Guessing: The stories table needs to have (one of) the remaining coauthor(s) uid number added to replace the deleted members, instead of looking for it on the coauthors table, since it doesn't exist there.
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
Not sure if this helps, but there was some discussion of this here: https://efiction.org/forums/index.php?topic=6951.msg37321#msg37321
Someone please update as to whether or not this has been fixed (newest SVN files) by testing on their archive. 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
