Someone sent me a report of a review. The url didn't work.
http://www.potionsandsnitches.net/fanfiction/reviews.php?reviewid=9623
The page it took me to just said:
A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_categories WHERE parentcatid = '-1' ORDER BY displayorderORDER BY review.reviewid DESC LIMIT 0,8
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 'BY review.reviewid DESC LIMIT 0,8' at line 1
Also, I had no idea who sent me the report. I had the From e-mail, but it was missing the new "This message was sent by so and so from such and such place."
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
This is now fixed! Thank you so much Tammy! 😀 It's awesome because now it just shows the single review.
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've actually just had someone e-mail me with the exact same error. Was this supposed to be something that the 3.3.1 upgrade solved? Because I have at least one user who is having the same problem still.
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
It is supposed to be fixed.
Go to a review and report it yourself and see if the error comes up. It might be because they are a member and not an admin, and it was fixed for admins.
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
Oh wait, actually mine is a different reason for getting the same error. People who have responses to reviews sent to them in e-mail get this error when they click the link. I tried it out and am getting the error myself. Should I open up a new bug report thread?
URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67
Yes. Thank you. 🙂
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
