URL to your eFiction: Beyond Reality
Version of eFiction: 3.5.1
Have you bridged eFiction, if so with what?: No.
Version of PHP: 2.8.0.1
Version of MySQL: 4.1.22
Have you searched for your problem: Yes.
If so, what terms did you try: challenge delete, delete challenges, challenge module, fatal MySQL error in challenges
State the nature of your problem: A fatal MySQL error appears when deleting a challenge.
Do you have a test account for us? I'm sorry. I don't. D=
Firstly I want to apologize for posting this. I've looked all over for this sort of problem, but I can't seem to find anything remotely similar to this. I feel silly asking for help when I know it's probably something that is staring me right in the face. But I just can't seem to figure out the problem and it is bugging me to no end right now.
I recently installed the Challenge Moldule (version 1.4) and it installed correctly (at least to my knowledge). To test it I made a test challenge to see if everything was alright and worked correctly. Once I saw that it uploaded okay and I was able to respond to it with another small test I went and deleted it.
Now this is where this problem comes in:
A fatal MySQL error was encountered.
Query: SELECT challenges, sid FROM fanfiction_stories WHERE FIND_IN_SET(3, challenges) > 0
Error: (1054) Unknown column 'challenges' in 'field list'
To make a note first I tried this three different times so where it says "WHERE FIND_IN_SET(#, challenges)" the # was different. First time it was 1, second time it was 2, and etc. Don't know if this'll make a difference, but I thought I'd say something.
Here's the funny thing. I refresh out of the page and go to try to delete again, but it isn't there. The challenge was deleted, but the Fatal MySQL error popped up anyway. I wondered if I had the Debug on so I went in to turn it off, but it was off. Now I'm puzzled.
I've tried looking in myPHPadmin, but I can't find the problem at all of what it's saying in the error. As I said, it's probably staring at me right in the face. ]x
Also. Don't know if this'll help, but here's the link to the exact url of where the error pops up: Error Page
Again, I apologize. But thank you in advanced for the help! It'll be much apperciated.
Something's wrong with your install. There should be a field in the stories table called challenges. It seems to be missing.
I guess I should've known not to get my hopes up on this challenge module. I've been having the darnest trouble.
I've did some editing here and there and playing around and after a frustrating hour, I finally fixed it.
Thanks a bunch, Tammy. =]
