Not sure if this is the right forum to put this in, so feel free to move it if necessary.
I recently updated my scripts to the newest version of eFiction, and my site uses a shared authors table (main_fanfiction_authors) for all three of my archives (main_ , adult_ , atlantis_) and it is mostly working fine. However, when I go to edit chapters ( http://sg1-heliopolis.com/archive/stories.php?action=editchapter&chapid=325&admin=1&uid=1691 ) I get the following error:
A fatal MySQL error was encountered.
Query: SELECT penname, uid FROM AUTHORPREFIXfanfiction_authors ORDER BY penname
Error: (1146) Table 'efic_helioarchive.AUTHORPREFIXfanfiction_authors' doesn't exist
I've looked through stories.php and includes/queries.php but I can't find the problem. Any suggestions? Edit stories, Add stories, etc, all seem to work.
Check includes/storyform.php. Look at the chapterform function. The $authorquery line in that function looks like it's wrong to me. It should be:
$authorquery = dbquery("SELECT "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM "._AUTHORTABLE." ORDER BY penname");
However, what I've got doesn't quite match your error so I'm not sure.
On the plus side, it's probably only affecting your admins and not your regular authors.
Bump. This should be fixed with 3.3.1
No response for months, 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
