First off, thanks again to those who helped me with my last issue.
I'm not sure if this is the right place to post this thread since I don't know if a module issue is considered a bug or not, so please go right ahead and move it if it's in the wrong place.
URL to your eFiction: Still under construction. Not yet public
Version of eFiction: 3.4.3
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.7
Version of MySQL: 4.1.22
Have you searched for your problem: Yes, I think I've read everything here regarding challenges
If so, what terms did you try: MySQL error, challenges not displaying, challenges module
State the nature of your problem: A fatal MySQL error was encountered when istalling the challenges module, then I tried manually installing and things got worse.
Do you have a test account for us? Not at this time
So, I upgraded to 3.4.2 when it was released and got things working after a few minor problems. I decided that before the site is ready to go public it would be nice to get the challenges module installed and working. I did test it out before the upgrade and everything worked fine, but I uninstalled it back then because I didn't need it.
My first try gave me the following error:
A fatal MySQL error was encountered.
Query: SELECT count(chalid) FROM fanfiction_challenges
Error: (1146) Table 'sublimer_eFiction.fanfiction_challenges' doesn't exist
I searched for the error here and found this support thread. The problems seemed identical so I followed the instructions there, removing both the ef_fanfiction_challenges table and the rows in the modules table. I also deleted the challenges folder and uploaded it fresh afterwords. Then I started over with the SQL queries. Now, I seem to have a new problem. While the site is working again, the Challenges module is not. It does not display in the menu, the browse panels or anywhere else yet my Information panel looks like this:
Info
Members: 26
Series: 1
Stories: 75
Chapters: 257
Word count: 569485
Authors: 23
Reviews: 1
Reviewers: 1
Newest Member: Endymion
Challenges: 0
Challengers: 0
Challenges: 0
Challengers: 0
The story count is wrong too and recalculating things won't change it (I've tried several times), but I imagine that's another unrelated issue and needs a seperate topic. The problem I'm inquiring about here is where did those last 4 entries in the info panel come from and how can I get this working the way it's supposed to?
I think I've tried just about everything at least 7 times in the past 48 hours and read every single thread on this forum regarding challenges, but I'm still stuck. I've even tried uploading different skins to make sure it's not a skin issue. Any suggestions would be appreciated. Thanks in advance!
I get the double challenges too, and the modules page still says that I need to run the update and when I hit run it says its already installed.
I figured out a way to get the look of the info chart without doing it, but I can't figure out what the code is to grab the challenges stuff for challengers and challenges.
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
I get the double challenges too, and the modules page still says that I need to run the update and when I hit run it says its already installed.
Yeah, I was getting that too, but after I tried the manual install, I get something different now. I tried to uninstall the module in the Admin section and it tells me that it's actually not installed. And despite the fact that those double challenges are showing on my side menu the main menu, browse, search, etc, does not show any links to the challenges or any way to submit a challenge. Aside from there double challenges on the side menu, there's absolutely nothing to show me that I've installed the thing, so I can't use it. And now trying to uninstall it manually brings up that same fatal SQL error again. I'd either like it to work the way it's meant to work or be removed completely and at the moment it seems that neither is possible.
Any advice could be greatly appreciated.
One small note to add to this...
The beta readers module seems to be doing the exact same thing. I go into Authors then I click the scroll down menu that shows All Member, Admins, Authors and Beta Readers and Beta readers comes up four times in the list. I can only assume that I've installed the mods more than once, but when I look in phpMyAdmin, I only see both the challenges and the beta readers in there one time.
I have no idea what I'm doing wrong here. 😕
I'm still stuck on this. My archive hasn't gone live yet so I have some time, but I'm just wondering if anyone knows how I can solve this.
One small note to add to this...
The beta readers module seems to be doing the exact same thing. I go into Authors then I click the scroll down menu that shows All Member, Admins, Authors and Beta Readers and Beta readers comes up four times in the list. I can only assume that I've installed the mods more than once, but when I look in phpMyAdmin, I only see both the challenges and the beta readers in there one time.
I have no idea what I'm doing wrong here. 😕
I tried installing challenges on my test site and got into problems...The beta module had an update at Tammy's website, so I don't know which version you are running. As for the double challenges, etc. you will have to go into Admin->Panels and look for all the double listings there and delete one of them. If it doesn't clear using Panels, you might have to go into myphpadmin and clear the duplication there.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Well, the Run Update problem is fixed with 1.4 with the new version of Efiction, however, the duplicate Challenges is still not fixed. I did find a duplicate entry on the below site, mine didn't have one, but still does the below.
http://archive.worldofslash.com/index.php
Members: 355
Series: 3
Stories: 50
Chapters: 656
Word count: 3182794
Authors: 15
Reviews: 88
Reviewers: 21
Newest Member: Bellerophon
Challenges: 2
Challengers: 1
Challenges: 2
Challengers: 1
There are 1 chapters waiting to be validated.
Is there any way we could get a list of all the variables for this block. I.E. {authors} etc
Dreamy
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
If you've got duplicates, you need to go into your panel admin and delete them.
I didn't see a duplicate in the panel admin at either World of Slash, or the Ruby Quill, that's the problem. *confused* I looked in the MySQL for fanfiction_pannels, and I looked on the panels interface on the admin section of both sites, didn't find duplicates at either. The only duplicate I found was on WoS and it was 2 entries in the modules section. RQ, doesn't have that duplicate.
All I found was one each of the below:
Challenges
Your Challenges
Top 10 Challenges
Challenges by {author}
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
I didn't see a duplicate in the panel admin at either World of Slash, or the Ruby Quill, that's the problem. *confused* I looked in the MySQL for fanfiction_pannels, and I looked on the panels interface on the admin section of both sites, didn't find duplicates at either. The only duplicate I found was on WoS and it was 2 entries in the modules section. RQ, doesn't have that duplicate.
All I found was one each of the below:
Challenges
Your Challenges
Top 10 Challenges
Challenges by {author}
In myphpAdmin, you have to look for duplicates in fanfiction_codeblocks, if you see two or more that might have the codeblock of sitestats (you'll see this under Browse), just delete one of them. Make sure they are duplicates of each other though.
barb
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Ahhhhh! No wonder I couldn't find it! Its fixed now! Thanks so much for your help babaca, I have been trying to figure out how to fix this forever! LOL
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
No problem, I had a similar problem with recommendations a little while ago.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
I tried installing challenges on my test site and got into problems...The beta module had an update at Tammy's website, so I don't know which version you are running. As for the double challenges, etc. you will have to go into Admin->Panels and look for all the double listings there and delete one of them. If it doesn't clear using Panels, you might have to go into myphpadmin and clear the duplication there.
In myphpAdmin, you have to look for duplicates in fanfiction_codeblocks, if you see two or more that might have the codeblock of sitestats (you'll see this under Browse), just delete one of them. Make sure they are duplicates of each other though.
If you've got duplicates, you need to go into your panel admin and delete them.
Oddly enough, the only place Challenges is showing up at all is in that side column. It's not listed even once in the Admin section under Panels. I did find and delete the duplicate entry in fanfiction_codeblocks and when I deleted that, the extra "Challenges" and "Challengers" disappeared. One problem solved, thank you.
Unfortunately the duplicate entry wasn't the only issue. Challenges is not showing up as a link in the main menu so there's no actual way to go there and submit a challenge because it doesn't exist. I'm still lost, it seems.
Where can I download the update? Maybe that's the problem.
What skin are you using? Challenges might be showing up in its variable file or hard coded into the default. Look in those tpl lfiles to see if {challenges} appear there and remove it from there... unless you are trying to install Challenges.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Thanks for the quick reply.
I'm using a modified version of this skin (Harry Potter 02) by The-Butterfly.de. Yeah, I'm trying to install the challenges module. I had it working just fine before I upgraded to 3.4.2. but if the module that comes with the upgrade isn't the newest version, I wonder if that might be the problem. If I must remove it completely, I will, but it would have been a super useful feature to have and I just can't understand why it won't work this time.
