URL to your eFiction: htt://fanfics.nfu-nfu.net/
Version of eFiction: 3.2
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.4
Version of MySQL: 4.1.21-standard
Have you searched for your problem: (yes/no) yes
If so, what terms did you try: The error message that I received
State the nature of your problem: Copy and paste any errors you are receiving.
After submitting a test review, I keep on getting this error message:
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 1
The review is logged, and you get an email notification for it, but this error message just keeps on popping up.
Do you have a test account for us? No.
So you have to d/l a fix zip file? Do you know where I could get that?
I'm looking at the downloads section, but can't seem to find it.
Thank you!
The news forum. See the link in the "Latest Info" above.
Thank you!
I've downloaded it, now which files would I need to replace, or do I have to replace all of them?
At the top of this forum, there are two sticked topics "How to Upgrade" and "How To Upgrade from 3.x.x to 3.x.x". 😐
