Hi,
I have been having several members at my site e-mail me saying that they have an error come up when clicking the link that is in their e-mail notifications that an author has responded to one of their reviews.
Here is an example that one of my members sent me:
sammyndeansgrl has responded to your review. You can see the response at http://www.sinful-desire.org/archive/reviews.php?reviewid=2297
(and this is the error they get on the page:)
A fatal MySQL error was encountered.
Query: Resource id #58ORDER BY review.reviewid DESC LIMIT 0,15
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 'Resource id #58ORDER BY review.reviewid DESC LIMIT 0,15' at line 1
I searched and originally thought it was https://efiction.org/forums/index.php?topic=5273.0 , but that's a bit different problem. If anyone knows why this is happening and possible solutions, I'd really appreciate it! Thank you in advance!
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's been almost a month since I posted this and I was just wondering if anyone had any suggestions on what I can do to solve this! Thanks!
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
Well, I'm not sure this is the same problem. I succeeded to repeat something similar on my installation for non-existing reviews, for which here is a fix (reviews.php file | marked changes).
However, on your site I couldn't open even individual existing reviews. Are you sure you're using the latest version? Because I can link existing reviews on my site just fine.
Anyway, try overwriting your "reviews.php" with the one given above and see if it helps (open the link and then save the reviews.zip file as "reviews.php" file (it is not ZIP, simply I could not save it neither as TXT nor HTML as 3host adds counter script automatically beneath HTML)). Back up your original "reviews.php" file before doing that, of course.
The wireless music box has no imaginable commercial value. Who would pay for a message sent to nobody in particular? (1920)
I have not had this problem, I click on "Author responded to review" links in my e-mail pretty regularly, and haven't had any error or problems. No one has reported problems to me either.
Is this still an issue?
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
Marking this as solved as the link she gave in her first post doesn't give that error anymore either.
