I'm installing a fresh eFiction 3.5, and I'm running into problems with stories.php.
Initially, I had the "DBPREFIXfanfiction_coauthors" problem, but I fixed that based on instructions in the forum. That left me with the following error, when I try to edit a test story:
A fatal MySQL error was encountered.
Query: SELECT author.penname AS penname FROM dwrpf_fanfiction_coauthors AS c WHERE sid = '1' LEFT JOIN dwrpf_fanfiction_authors as author AS a ON a.author.uid = c.uid
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN dwrpf_fanfiction_authors as author AS a ON a.author.uid = c.uid' at line 1
I've tried turning off co-authors, but to no avail. I'm willing to downgrade stories.php to the 3.4.3 version, but I'd prefer to fix the code instead.
BTW, what's the progress on a new release, preferably without these bugs?
Hm, are you sure you've tried all the 'fixes' in these threads:
https://efiction.org/forums/index.php?topic=6674.0
https://efiction.org/forums/index.php?topic=6677.0
They seem to be having the same error message that you're having.
Follow this, in particular: https://efiction.org/forums/index.php?topic=6677.msg36148#msg36148
There are four lines in stories.php that need to be modified.
Aha! Removing the "AS a ON a." fixed the problem.
Thanks!
