Notifications
Clear all

Link in email to Review/ReviewerID generates a 1064 MySQL error

3 Posts
2 Users
0 Reactions
2,456 Views
(@guest1976)
Posts: 0
 

I've looked around and haven't found anything that relates to this error specifically in the forums.

We are new at this and this is our first upgrade. On our primary site, we are currently running 2.0.4, but wanted to test out everything prior to the migration to the more/most recent version.

We first mirrored our current efiction site and then upgraded the efiction software there and have a series of people testing its functionality and new features. This is the location of our 3.3 site:

http://test.pommedesang.com/efiction/index.php?

We are experiencing a problem with the email link generated by the ‘Report This’ option on a review. It generates an MySQL error when executed.

This is the link from the email:
http://test.pommedesang.com/efiction/reviews.php?reviewid=37242

This is the error messages generated:
A fatal MySQL error was encountered.
Query: Resource id #42 ORDER 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 #42 ORDER BY review.reviewid DESC LIMIT 0,15' at line 1

This is the URL listed on the page:
http://test.pommedesang.com/efiction/reviews.php?reviewid=37242

The ‘report this’ function works fine when it is a story being reported, but not a review. Any idea what the problem is??

This is the story/reviews I was looking at:
http://test.pommedesang.com/efiction/reviews.php?type=ST&item=6139&chapid=9792

I was testing the ‘report this’ function on the top review,

I filled out and send the form….

This is the form URL:
http://test.pommedesang.com/efiction/contact.php?action=report&url=reviews.php?reviewid=37242

It gets successfully sent to the designated admin email.

Thanks


 
Posted : 17/07/2007 1:10 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

It's the same bug as this one:

Report review url bad
https://efiction.org/forums/index.php?topic=5273.0


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

 
Posted : 17/07/2007 1:48 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

This is now fixed! Thank you so much Tammy!


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

 
Posted : 25/09/2007 5:23 pm
Share: