http://library.donnieyen.us/
EFIC: V3.0.1, bridged with SMF
Fresh install, existing SMF
I get this MySQL error when I try to edit an existing chapter as admin
A fatal MySQL error was encountered.
Query: SELECT story.title, story.sid, chapter.uid, chapter.inorder, author.memberName as penname FROM dylibr_fanfiction_stories as story, dylibr_fanfiction_chapters as chapter, dyusmb_members as author WHERE author.uid = chapter.uid AND story.sid = chapter.sid AND chapter.chapid = 1
Error: (1054) Unknown column 'author.uid' in 'where clause'
The link displayed when this occurs is:
efic_url/stories.php?action=editchapter&chapid=1&admin=1
I edit chapters all the time as an admin with no problem. This is not an upgrade or installation problem, I think. Maybe it's a bug having to do with your SMF bridge?
Is the chapter you are trying to edit, added since you upgraded the site? Or before?
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
I'm thinking it might be a bug with the bridge too because of the call to my SMF table, but I thought this would be the best place for the Q until told otherwise. Should I edit the title?
Edited my original post, this archive was a fresh new V3.0.1 install.
The chapter I'm trying to edit was to a new story. The story was posted post installation
It's a bug. Temp solution that should get you going is turn logging off while you edit the chapter.
This should be fixed with the 3.0.2 release.
Indeed it is. I've gone in and edited a few already posted stories and I have no errors reported. Thanks much!. Editing the first post to mark as SOLVED
