URL to your eFiction: http://www.hpfandom.net/eff/
Version of eFiction: 3.1.1, upgraded from 1.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.3 something
Version of MySQL: 4.1.14
Have you searched for your problem: yes
If so, what terms did you try: advanced search fatal error
State the nature of your problem:
The first page of an advanced search is generated but when a user goes to click page 2 or Next they receive this error
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND FIND_IN_SET(58, stories.classes) > 0 AND FIND_IN_SET(Array, stories.classes) > 0
Error: (1054) Unknown column 'Array' in 'where clause'
I'm not getting that. i did an advanced search on my site and the pages of results were fine, all 8 of them. No errors.
http://www.potionsandsnitches.net/fanfiction/search.php?searchtype=advanced
What types of things are you searching for in the advanced search? Characters, categories, a keyword?
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
Actually I just did a search at your site and I also got an error.
Here's what i had selected.
!Snape and Harry
Humor (to include)
Angst (to exclude)
Abusive! Dursleys (to exclude)
That's why I asked you what you were searching for, so that I could try the same things.
In any case, after checking the three things you mentioned seperately, it seems to be the classifications.
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND FIND_IN_SET(7, stories.classes) = 0 AND FIND_IN_SET(Array, stories.classes) = 0
Error: (1054) Unknown column 'Array' in 'where clause'
Here's the url for a good search just in case something's wrong with the url:
http://www.potionsandsnitches.net/fanfiction/search.php?searchtype=advanced&catoptions=19&formname=search&charid=170&rid=7&wordlow=-500&wordhigh=1000000&sortorder=alpha&offset=8
moving to bug forums...
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
One of my users just reported this error as well. When I played around I also came to the conclusion that it was with classifications. I'll include my info in case it helps.
Site: dracoandginny.com
eFiction: 3.1.1
PHP: 4.4.4
MySQL: 4.0.27
The error:
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM secondfanfiction_stories as stories WHERE validated > 0 AND FIND_IN_SET(17, stories.classes) > 0 AND FIND_IN_SET(Array, stories.classes) > 0
Error: (1054) Unknown column 'Array' in 'where clause'
I am still getting an error whicn I click on another page of results.
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND FIND_IN_SET(27, stories.classes) > 0 AND FIND_IN_SET(Array, stories.classes) > 0
Error: (1054) Unknown column 'Array' in 'where clause'
Test here:
http://www.potionsandsnitches.net/fanfiction/search.php?searchtype=advanced
I selected
Characters: !Snape and Harry
Warnings to include: Baby fic
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
I think I've found this now. Next update.
This will be fixed in 3.3. 🙂
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
Fixed now?
Since ataraxis and Lyndsie are not responding, I guess it's up to me.
Yes this is fixed. 🙂 Thank you 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
