I was testing my site today and got the following on Adding a new story...
Notice: Use of undefined constant PENNAMEFIELD - assumed 'PENNAMEFIELD' in /home/therabid/public_html/stories.php on line 295
Notice: Use of undefined constant DBPREFIX - assumed 'DBPREFIX' in /home/therabid/public_html/stories.php on line 295
Notice: Use of undefined constant UIDFIELD - assumed 'UIDFIELD' in /home/therabid/public_html/stories.php on line 295
A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '13' LEFT JOIN therabidfanfiction_authors as author AS a ON a.UIDFIELD = 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 therabidfanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1
Now I've not touched the php files, cause I'm just not that brave, any ideas how to fix?
:lol:I figured it out after a few hours! I had deleted all the test stories and forgot to reset!
*I'm an idiot*
Have you done this? https://efiction.org/forums/index.php?topic=6677.msg37459#msg37459
It doesn't look like you have. It's a known problem with the stories.php in the 3.5 download, which you should fix if you haven't already.
