URL to your eFiction: http://www.wizardtales.net/index.php
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: no
Version of PHP: 5.2.6
Version of MySQL: 5.0.67-community
Have you searched for your problem: yes
If so, what terms did you try: SQL, 1054, fatal error, MySQL
State the nature of your problem: As a starting note, yes, I have noticed similar threads for 3.4.3. They are marked 'solved' but for the life of me, I can't find the solutions anywhere. So I'm sorry if this is redundant!
That said, I am getting fatal MySQL errors in several areas:
- Members in the Admin area posts the following error:
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, author.uid as uid, ap.stories FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs AS ap ON author.uid = ap.uid GROUP BY author.uid ORDER BY author.penname LIMIT 0,40
Error: (1054) Unknown column 'ap.stories' in 'field list' - Authors on the main site posts the following error:
A fatal MySQL error was encountered.
Query: SELECT count(author.uid) FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs as ap ON author.uid = ap.uid WHERE ap.stories > 0
Error: (1054) Unknown column 'ap.stories' in 'where clause' - Clicking on an author or member penname posts the following error:
A fatal MySQL error was encountered.
Query: SELECT count(stories.sid) FROM fanfiction_stories as stories LEFT JOIN fanfiction_coauthors as coauth ON stories.sid = coauth.sid WHERE validated > 0 AND (stories.uid = '1' OR coauth.uid = '1')
Error: (1054) Unknown column 'coauth.sid' in 'on clause' - Clicking on any story title within the site gets the following error:
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, co.uid FROM fanfiction_coauthors AS co LEFT JOIN fanfiction_authors as author ON co.uid = author.uid WHERE co.sid = '1'
Error: (1054) Unknown column 'co.sid' in 'where clause'
I'm sure you get the idea, and I'm sure there are more...any help and/or fixes would be greatly appreciated.
Do you have a test account for us? no...I can't create one because of these errors. I can provide admin information privately if necessary.
MuggleMomma
Owner,
This has been a problem noted by several people with 3.5. I haven't seen a good fix that works for everyone yet, but this thread is the best: https://efiction.org/forums/index.php?topic=6674
Also, check your database to make sure all the changes were done properly. That helped me somewhat.
I am going to attempt downgrading to eF 3.4.3 until a patch is released. If that doesn't work, I'll go in and edit the php myself.
MM
MuggleMomma
Owner,
Downgrading did nothing. Going to attempt a fresh install and database import.
MuggleMomma
Owner,
I had the same problem (did a 3.3.1 to a 3.5 upgrade), at least with the authors page; I checked update.php and then ran this SQL query in phpMyAdmin:
ALTER TABLE `".TABLEPREFIX."fanfiction_authorprefs` ADD `stories` INT NOT NULL DEFAULT '0'
This was AFTER I had already used the SQL query for creating the co-authors table, which was showing up in an error on the main page.
It seemed to fix the error I had, and I can't find errors similar to the ones you had (the only one I was able to find for sure was the one when you click on "Members" on the main page)
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
