URL to your eFiction: www.savingsarasidle.com/fanfiction
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2.8
Version of MySQL: 5.0.67
Have you searched for your problem: (yes/no)
If so, what terms did you try: SELECT PENNAMEFIELD AS penname
Do you have a test account for us? User: EFTest, Pass: 1234abc
State the nature of your problem: Copy and paste any errors you are receiving.
Hi everyone.
First off, let me admit I have no idea about MySql or PHP or anything past the basic, plug-in and install!
I'm setting up eFiction 3.5, and I'm getting these errors:
Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home/savingsa/public_html/fanfiction/install/languages/en.php on line 2
Warning: include() [function.include]: Failed opening 'version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/savingsa/public_html/fanfiction/install/languages/en.php on line 2
A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '1' LEFT JOIN ffics_fanfiction_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 ffics_fanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1
Can anyone offer up any (step by step) help as to how to fix this?
Also, its not allowing me to choose which category to put my story in.
Thanks!
Version of PHP: 5.2.8
Version of MySQL: 5.0.67
Do you have debug on? I think the two warnings would likely disappear if you turn it off. It's looking for the language file in the install folder, which is meant to be deleted after installation (and it looks like you did, since it can't find it), so as long as you've completed the install then those messages don't strike me as particularly worrisome.
As for the fatal error, it's like shooting fish in a barrel to find a thread explaining the problem around here. I summarize it here: https://efiction.org/forums/index.php?topic=6832.msg36577#msg36577
Thank you!
For some reason, even though I chose to turn off "One Category" it still turned back on.
You were right about the Characters, in my other post, for some reason I had submission turned off, which again, like One Category, I could've swore I had turned on.
Version of PHP: 5.2.8
Version of MySQL: 5.0.67
Well, if it's not turning off even when you're telling it to, that's pretty weird. You could change in manually in your database in the fanfiction_settings table. I'm not sure off the top of my head what the field is called, but it should be fairly obvious. Unless you were talking past tense in the sense that it's no longer occurring? (It's late for me... lol.)
