A fatal MySQL error was encountered.
Query: SELECT COUNT(uid) FROM settfanfiction_authorprefs WHERE stories > 0
Error: (1054) Unknown column 'stories' in 'where clause'
I've a fresh install, newly initialized etc, nothing done to the mysql database besides it being blank beforehand. No mods, no bridge, no importing of old data were done yet.
I am rebuilding efiction! Join us on irc! #efiction at
So you didn't set up any categories, ratings or classifications yet? Do that.
Also, you need to always post a link to your site. I'll assume that the info in your signature is not correct since it lists version 3.3.1 and modifications to that script.
Do you have any user accounts created yet?
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 have my one admin account, i added cats and classifications which sily me i had forgotten, so hmm i don't have an option to select a category when submitting a story now. Oh, ok fixed that, alright sending a story worked. i edited it and validated it and crash
A fatal MySQL error was encountered.
Query: SELECT COUNT(uid) FROM settfanfiction_authorprefs WHERE stories > 0
Error: (1054) Unknown column 'stories' in 'where clause'
opened the story after validating it in the submissions area and crash
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, ap.uid, ap.stories FROM settfanfiction_authors as author LEFT JOIN settfanfiction_authorprefs AS ap on author.uid = ap.uid WHERE ap.uid = '1'
Error: (1054) Unknown column 'ap.stories' in 'field list'
I am rebuilding efiction! Join us on irc! #efiction at
Did you try and install the recommendations module? I'm getting errors about the recommendations module on your homepage. Make sure that you have everything for 3.4, even module updates from Tammy's personal site.
If it's a fresh install, I would start over. Delete the database and the file, get a new zip of 3.4.1, reupload and reinstall. See where that takes you.
Don't try adding or installing any extra things like challenges, beta readers, or recommendations until the main basic install is good, and you don't have problems like that. Make sure you have all things available to use, like categories, classifications, and characters. You have no characters on your site.
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
that's the thing, i had not installed it. i strongly believe there is code in the beta module that was taken from the recommendations module and its conflicting
I am rebuilding efiction! Join us on irc! #efiction at
It's not a problem in either module. It's a problem from the upgrade. A field didn't get added to the authorprefs table.
fixed then, thanks a lot
I am rebuilding efiction! Join us on irc! #efiction at
