URL to your eFiction: http://fiction.allihave.net
Version of eFiction: 3.3.1
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4
Version of MySQL: 4.1.22-standard
Have you searched for your problem: yes
If so, what terms did you try: challenges, series, also bits of my error to see if it pulls up anything
State the nature of your problem:
Originally I didn't have the challenges table so I created that according to my other post (link is at the bottom) and then I had the following errors. I hope they are all related some how and can be easily fixed.
When I click on browse.php?type=series I get the following error...
A fatal MySQL error was encountered.
Query: SELECT chalid, title FROM fanfiction_challenges WHERE FIND_IN_SET(chalid, '') > 0
Error: (1146) Table 'allihave_fiction.fanfiction_challenges' doesn't exist
Which is completely wrong because the table should be allihave_fiction.fictionfanfiction_challenges if I'm understanding this all correctly, not allihave_fiction.fanfiction_challenges. So that is problem number 1.
-
My next problem is when I clicked on the challenges link from my home page, I received an error. So I searched the forums and found that I needed to correct the link to browse.php?type=challenges and so I did. But when you click the challenges link now, I get the following...
Error!We encountered an error. Please go back and try again.
I have no idea on how to fix that. I have tried changing the challenges link all kinds of ways and I've gotten everything from blank pages to mysql errors so I put it back.
-
Another problem I am having is when I go to Admin and then lick on Challenges. I get "You are not authorized to access that function." which I'm not understanding at all. When going to Admin then clicking on Modules, then the uninstall link for Challenges, I get the following...
Fatal error: Cannot redeclare categoryitems() (previously declared in /home/allihave/public_html/fiction/includes/corefunctions.php:26) in /home/allihave/public_html/fiction/includes/corefunctions.php on line 26
If I go back to Admin, click on Modules then Challenges I get the version but none of the challenges I see in the database over on myphpadmin. If I go to Admin, click on Modules then click on options I get "You are not authorized to access that function." as well as the following...
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
Warning: main(../../header.php) [function.main]: failed to open stream: No such file or directory in /home/allihave/public_html/fiction/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 /home/allihave/public_html/fiction/modules/challenges/admin.php on line 25
---
When in Admin and I click on Admin, then go to click on my name or the test name I get the following error.
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, level, categories, contact FROM fictionfanfiction_authors as author LEFT JOIN fictionfanfiction_authorprefs as ap ON ap.uid = author.uid WHERE author.uid = '1547' LIMIT 1
Error: (1052) Column 'level' in field list is ambiguous
Do you have a test account for us? Yes. both name and pw is "test"
Carried over from https://efiction.org/forums/index.php?topic=5686
Try installing and then uninstalling the challenges module. Seems like it's 1/2 installed for some reason.
I did that and it says it was uninstalled but when I go back it's still there. But if I attempt to go to the link it says it's not installed.
There's a bug in the install/uninstall on the challenges. It'll be fixed in the next update of the script. Which should be out soon after I get back from my business trip. 🙂
