URL to your eFiction: http://www.devianthearts.com
Test site is: http://stuff.devianthearts.com
Your version of eFiction: 3.2
Latest Patche(s): Yes
Any mods installed?: bridged
Have you modified your eFiction?: No.
Version of PHP: 5.2.1
Version of MySQL: 5.0.18
Have you searched for your problem: No
Other Notes: Hosting on dreamhost with php running as cgi
State the nature of your problem: When trying to leave a review I get this error, but the author is sent an alert anyway:
A fatal MySQL error was encountered.
Query: SELECT COUNT(DISTINCT uid) FROM fanfiction_reviews WHERE WHERE review != 'No Review' AND uid != 0
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 'WHERE review != 'No Review' AND uid != 0' at line
EDIT The review does seem to show up, so I don't know where this error is coming from.
I just updated the .zip and the fix .zip to fix this.
Thank you Tammy. 🙂 this seems to be fixed now, I just tested it and was able to post a review, and I got an e-mail about it.
Moving to solved...
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
