Hi Guys,
I am running efiction version 3.2.1 and have an issue with reviews.
They seem to be running ok when you post a review for a fiction in the recently added blocks, I did a test review. However when you click on the link that takes you to reviews it comes up with the following mysql syntax error:
A fatal MySQL error was encountered.
Query: ORDER BY review.reviewid DESC LIMIT 0,25
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 'ORDER BY review.reviewid DESC LIMIT 0,25' at line 1
Not sure where to fix this. Have I missed something again here? Everything else is running fine :). I dont know if it is a bug or not so I have posted in general support.
many thanks Kate
i've been able to view the review pages on my site fine. Can we have a link to a review page that shows the errors?
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
Hi Jan
the link is
http://www.katesfictionandpoetry.com/reviews.php
thanks 🙂
sorry about that.
best wishes Kate
That's an invalid link. You should never hit the reviews.php page without passing variables to it in the string. You should be going to something like:
http://www.katesfictionandpoetry.com/reviews.php?item=1&type=ST
Where are you clicking to get to that link?
Hi
I guessed I had the wrong link in.
It was to get all the reviews up for all of the stories not just one fiction. What do I need to put after the end of reviews.php? to bring this up please.
Many Thanks Tammy 🙂
Kate
