URL to your eFiction: http://worldsfinest.comicslash.com/archive/index.php
Version of eFiction: 3.0.2
Have you bridged eFiction, if so with what?: NO
Version of PHP: 4.3.9
Version of MySQL: 4.1.12-3.RHEL4.1
Have you searched for your problem: YES
If so, what terms did you try: MySQL; Browse through all forums.
Have you looked at the FAQs: YES, however, no 3.0 FAQS could be found.
State the nature of your problem:
I did an initial install of the script. Everything was working wonderfully, until I loaded four test stories and attemped to use the "Most Recent" feature (c.f. http://worldsfinest.comicslash.com/archive/browse.php?type=recent ) and any of the "Browse" page links (c.f. http://worldsfinest.comicslash.com/archive/browse.php?type=categories ). The stories uploaded properly and I can access them using the "Members" browse. Anyway, here is the error message:
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_stories as stories WHERE validated > 0 AND FIND_IN_SET(Array, stories.classes) > 0 AND updated > '2006-12-31 00:00:00'
Error: (1054) Unknown column 'Array' in 'where clause'
Any help would be greatly appreciated. Thanks!
Turn debug on.
I do have debug turned on. Just checked and it is. I have all of the options on that settings page set to "Yes". Thanks!
Turn debug on and maintenance off. They can't both be on right now as there's a bug in the script.
Done.
What did you use for a name for the "story type" classification? If you used "type" you need to change it to something else. You can leave the title as "story type" and that is what will be displayed. Change "type" to "story_type" or something like that.
Oh my...goodness. That worked! You are like a magician. :kisses: Thank you. My case is closed.
