Apologies if this has already been fixed but I've been going through the forum trying to get answers from other posts and still haven't been able to fix these problems listed below on my website. Authors cannot respond to any challenges posted. My site is located at http://tasting-eden.com/cherryswirl if you would like to view what I'm talking about. Even if I click on the link to issue a challenge "efictionefiction" will pop up on the top of the layout which I believe is a skin problem but I can deal with that. These three issues listed below are what is driving me bonkers. Oh, and I've deleted and reinstalled the challenge module so there is only ONE version on there instead of multiple copies.
This is the message that appears when trying to click on the challenge title:
A fatal MySQL error was encountered.
Query: SELECT COUNT(seriesid) FROM fanfiction_series as series WHERE FIND_IN_SET(1, challenges) > 0
Error: (1054) Unknown column 'challenges' in 'where clause'
This is the message that appears when trying to respond to the challenge itself:
A fatal MySQL error was encountered.
Query: SELECT title, seriesid FROM fanfiction_series WHERE uid = '1' AND FIND_IN_SET(1, challenges) < 1 ORDER BY title ASC
Error: (1054) Unknown column 'challenges' in 'where clause'
Lastly (I hope) This is what appears if I try to go to modules in admin and then challenge options:
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /usr/home/tastinr1/public_html/cherryswirl/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /usr/home/tastinr1/public_html/cherryswirl/modules/challenges/admin.php on line 25
Warning: main() [function.include]: Failed opening '../../header.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/home/tastinr1/public_html/cherryswirl/modules/challenges/admin.php on line 25
Notice: Undefined variable: skin in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 146
Notice: Undefined index: header in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: header in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: header in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 706
Notice: Undefined index: header in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 713
Notice: Undefined index: footer in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: footer in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 701
Notice: Undefined index: footer in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 706
Notice: Undefined index: footer in /usr/home/tastinr1/public_html/cherryswirl/includes/class.TemplatePower.inc.php on line 713
Thanks in advance to anyone that takes the time out to try to help!
I think some of the bottom errors will disappear with debug turned off.
archive:
site:
Available for skin/mod commission! 🙂
how would I turn that off?
It is under Admin Section> Settings> Site Settings. It says "Display Debug Information" and I'm guessing yours says "yes". Just set it to "no"
My Site:
eFiction: v3.4.3
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges, Submit Time and Word Count
I think part of your problem is you're using a skin that isn't compatible with the most recent versions of eFiction. Use one of the defaults until you've got everything working. I suggest you grab the .zip again and try re-uploading your the challenges module and then re-installing it. It didn't get installed correctly. You should have a column in both stories and series for challenges.
Thank you for the tip on the debugger. That did take away the bottom half of that code that popped up. I also switched to the default skins but that didn't change anything with the challenges. They still have the same reaction. Was there a separate challenge module download or do I uninstall and reinstall it again...? I'm only asking because I've done that a few times now and I keep getting the same results. Thank you, though, for the help so far.
No it's not separate. I suggest you download the efiction .zip again and upload a fresh copy of the challenges module. As I said, something didn't get installed right.
I uninstalled the module from the admin panel and uploaded the module from the .zip file that I downloaded today. When I went back into the admin panel it still has the option to uninstall and if you click that link it says that the module is not installed yet it doesn't have the option to install now either. When I go into myPHPadmin to see if the block is still there it's not. I'm just really lost and frustrated right now. Do I need to basically delete the whole archive and do this from scratch?
You look to be in a sort of limbo. You got half-installed somewhere along the way or half uninstalled as the case may be. Do you have access to phpMyAdmin? If so, go to your PREFIXfanfiction_modules table and delete the challenges entry. That should let you install it.
Yes, I have access to it. The challenges module isn't even in there to delete! lol I've done that before too so I was kind of familiar with going in to delete it but there's nothing there. I am SO stuck in limbo, Tammy!
I got the challenges back up but the "respond to challenge" link still doesn't work. Any tips on rectifying that? Thank you for your help so far, it's been great.
You're back to where you were. When you click on a challenge, you're still getting the missing column in the series table. Use phpmyadmin to add it.
ALTER TABLE `PREFIXfanfiction_series` ADD `challenges` varchar(200) NOT NULL default '0'
As for the other, are you logged in? You can't respond unless you're logged in.
Everything worked once putting in that code. Thanks a lot, Tammy, you've been wonderful! 🙂
