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!
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.
