Review Response Lin...
 
Notifications
Clear all

Review Response Link gets error

2 Posts
1 Users
0 Reactions
1,255 Views
(@mikodragonfly)
Posts: 69
Trusted Member
Topic starter
 

URL to your eFiction: http://www.escape-ism.com/ourstories
Version of eFiction: 3.4.2
Have you bridged eFiction, if so with what?: SMF 1.1.5 [w/Tinyportal v0.9.8]
Version of PHP:5.2.3
Version of MySQL:  5.0.24a-standard-log
Have you searched for your problem: (yes) Exhaustively
If so, what terms did you try: Too many to list - used common sense
State the nature of your problem: See Below
Do you have a test account for us?:YES User: test_2008  Pass:crashtest2008
Problem #1:

When clicking on the above link in email notifying me that an author has responded to a review, I get the following error:

A fatal MySQL error was encountered.
Query: AND review.reviewid = '397' ORDER BY review.reviewid DESC LIMIT 0,20
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 'AND review.reviewid = '397' ORDER BY review.reviewid DESC LIMIT 0,20' at line 1

URL that Generated Error:
http://www.escape-ism.com/ourstories/reviews.php?reviewid=397

Note:
I realize that there is a pre-existing topic, however, it is almost 1 year old and marked as Solved with no mention of  what the solution or actual reason for the error was.

Problem#2:

Category Links in the "Categories Block" - do not take you to the individual Category page.  Instead, they link to another Category listing from which you then have to click a category link again - to get to the specific category.
eg: Go to http://www.escape-ism.com/ourstories
and click on any category in listed in the left sidebar Category Block.
This is where you will end up: http://www.escape-ism.com/ourstories/browse.php?type=categories&catid=6

Note:
Unknown if this problem existed prior to upgrading to eFiction  3.4.2. 
I don't recall coming across it before, although I may have...  and just don't remember - and it was called to my attention by one of our members yesterday.

Any assistance I can get with these things would be greatly appreciated!


I'm here...

 
Posted : 19/05/2008 9:55 am
(@mikodragonfly)
Posts: 69
Trusted Member
Topic starter
 

Sorry for double posting - but my request has changed a bit:

Please disregard the bit about Category Links in the "Categories Block." 
I will simply delete that block, since there doesn't seem to be a solution and I haven't seen where anyone else mentioned having the same problem.

I am, however, really hoping that one of the people who experienced the error with review response link might be able to advise how they had gotten rid of the error?

As always - any help would be much appreciated. πŸ™‚
~ Thanks.


I'm here...

 
Posted : 23/05/2008 7:48 pm
Share: