I was just made aware of the following error message from one of my members who tried to read two very different stories, from different authors.
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 WHERE FIND_IN_SET(stories.uid, '126') > 0 GROUP BY stories.uid
Error: (1054) Unknown column 'stories.uid' in 'where clause'
The way co-author works in mine is there is a search box above the co-author box. you type in the first letter of the person you want as a coauthor and a list appears, you select it and click on it and it appears in the coauthor box.
yeah i know that. but after clicking them in the co-author box they go away, so you actually don't pick anything.
But once the name is in the box you don't have to click on them, just fill the rest of the stuff out and when you hit submit it should show both names. I think clicking in the box erases the names if you've made a mistake on who you want as a co-author.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
The way co-author works in mine is there is a search box above the co-author box. you type in the first letter of the person you want as a coauthor and a list appears, you select it and click on it and it appears in the coauthor box.
yeah i know that. but after clicking them in the co-author box they go away, so you actually don't pick anything.
But once the name is in the box you don't have to click on them, just fill the rest of the stuff out and when you hit submit it should show both names. I think clicking in the box erases the names if you've made a mistake on who you want as a co-author.
Oh ok. Thanks, that fixed it.
Now I just need the last thing fixed...the error message
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 WHERE FIND_IN_SET(stories.uid, '126') > 0 GROUP BY stories.uid
Error: (1054) Unknown column 'stories.uid' in 'where clause'
My problem isn't fixed but I thought I might add that it appears it is happening to the last chapter (or only chapters) of a majority, if not all, the stories currently on the site. I don't know if that bit of information helps in figuring what is wrong, but I though it couldn't hurt.
I know it has only been a few days, or a day, since I asked about the last problem, but my members are worried and complaining.
This is what everyone gets when they either get to the last chapter of a story or the only chapter of a story.
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 WHERE FIND_IN_SET(stories.uid, '126') > 0 GROUP BY stories.uid
Error: (1054) Unknown column 'stories.uid' in 'where clause'
Please help.
Still need help but I have recently discovered this has something to do with the STORYEND module/add-on (whatever it is called).
For the Story End module go to Tammy's website:
http://efiction.hugosnebula.com
and go to the forums there... you might have an old version of the script. You can download the latest there (to see the downloads you have to register on that website). Story End is at version 1.3.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
I will come back in a minute to tell you if that worked babaca, but right now, when I delete the storyend module, this is the following error message that displayed at top
Warning: include(modules/storyend/storyend.php) [function.include]: failed to open stream: No such file or directory in /home/tarahogo/public_html/ffn/viewstory.php(302) : eval()'d code on line 1
Warning: include() [function.include]: Failed opening 'modules/storyend/storyend.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tarahogo/public_html/ffn/viewstory.php(302) : eval()'d code on line 1
For the Story End module go to Tammy's website:
http://efiction.hugosnebula.com
and go to the forums there... you might have an old version of the script. You can download the latest there (to see the downloads you have to register on that website). Story End is at version 1.3.
Ok, great! That worked! Thanks so much for your help!
