URL to your eFiction: http://www.escape-ism.com/ourstories
Version of eFiction: 3.3 (NEW)
Have you bridged eFiction, if so with what?: SMF 1.1.3[ TinyPortal v0.9.8] (OLD) (Using included SMF Bridge)
Version of PHP: 5.2.3
Version of MySQL: 5.0.24a
Have you searched for your problem: Yes. Repeatedly.
If so, what terms did you try: Every Word that I could think of related to MYSQL errors, the wording of the error, and SMF bridge related problems.
State the nature of your problem:
Non -admin users get the following error when they try to save a story:
A fatal MySQL error was encountered.
Query: SELECT author.ID_MEMBER as uid, author.emailAddress as email, author.memberName as penname, alertson FROM fanfiction_favorites as fav, fanfiction_authorprefs as ap, writers_members as author WHERE fav.item = AND fav.type = 'AU' AND fav.uid = author.ID_MEMBER AND ap.uid = author.ID_MEMBER AND ap.alertson = '1'
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 fav.type = 'AU' AND fav.uid = author.ID_MEMBER AND ap.uid = author.ID_MEMBER' at line 1
I have little to no knowledge of mysql - so I have no idea what syntax needs to be changed or even where it needs to be changed.
Special Note: I still get this error when using the version of QueryString.php provided with the bridge, however:
My existing QueryString.php is extensively modified due to a previous modification of my SMF. My understanding of coding is limited - but from what I could see, the modifications required by eFiction are already implemented...so I need to keep my QueryString.php
(Please correct me if I'm wrong - however I'm certain it is not the cause of the problem my users are experiencing)
A copy of My version of QueryString.php is here: http://www.escape-ism.com/My_pics/example2007.txt
I had originally rejected the idea of bridging SMF to eFiction because of this problem - but I realized that If I don't do this now before my site gets any bigger - things will be a great deal worse later on. Any help I can get is appreciated.
edit: I forgot to put this:
TEST ACCOUNT: tonya_moore
PASS: poetry2007
What do you mean by
Non -admin users get the following error when they try to save a story:
Do you mean that members get this error when they try to ADD a story to the archive? Or are you using a save Word mod?
Are they validated or unvalidated, or both?
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
oh - sorry - When they try to ADD a story.
I have it set to Automatically validate all stories.
...but - I see now that all members are listed as non-validated. I'll see what validating them does - regarding this problem...
:EDIT: Thanks so much Jan_AQ! There's no problem now. Validating all the members imported from SMF one by one - seems like it might have done the trick.
