URL to your eFiction: http://seventh-star.net/drfa
Version of eFiction: 3.0
Version of PHP: 4.4.4
Version of mySQL: 4.1.21-standard
Have you searched for your problem: yes
If so, what terms did you try: I didn't need to use the Search function, as the 3.0 upgrade forums are brand new and there are very few posters. But I looked at all the posts, and none of them seemed to deal with this (yet).
Have you looked at the FAQs: I haven't seen any definitive FAQs for 3.0 yet, aside from the readme.txt file included in the install.
State the nature of your problem: Okay, so I managed to get the 3.0 upgrade *mostly* working; there are still some things I need to iron out. The biggie is this one:
A fatal MySQL error was encountered.
Query: ALTER TABLE `fanfiction_settings` ADD `anonchallenges` TINYINT( 1 ) NOT NULL
Error: (1060) Duplicate column name 'anonchallenges'
Which occured on http://www.seventh-star.net/drfa/modules/challenges/install.php?confirm=yes when I tried to install the challenges module. Should I just go into phpMyAdmin and delete the row from the fanfiction_settings table so it can complete the install?
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
You've already got the module installed. The upgrade script did it for you.
EditTurn debug on in your site settings. You've got something else going on with the browse pages that I can't even begin to figure out. It's on all the pages. I can't for the life of me figure out where "Yes", "No" and "Not Sure" are coming from.
Okay, so debug is now on, and I guess since the challenge module was already installed by the upgrade script, there's no need to return to that. But when I go to the Browse/Challenge page, this is what I see:
A fatal MySQL error was encountered.
Query: SELECT COUNT(seriesid) FROM fanfiction_series as series WHERE FIND_IN_SET(Yes, series.classes) > 0 AND FIND_IN_SET(No, series.classes) > 0 AND FIND_IN_SET(Not Sure , series.classes) > 0
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';, series.classes) > 0' at line 1
I think that's the error you're seeing on all the Browse.php subpages, right?
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
Yes, that's what I'm seeing. It's from your poll module. Is this the poll that comes with the script? Set the poll block to be index only please.
Setting it to Index Only seemed to fix the problem on all the browse.php subpages, but I wonder why that happened in the first place? Is there no way to have it set to "Active" without the error cropping up, or is this just a temporary measure until a fix is found?
Edit: I just noticed that despite the accidental reinstallation of the challenges module not finishing, there are still two links for the Challenges admin panel when I go to the main admin panel. Is there a way to remove one of them?
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
Delete the panel.
Ah, okay. I thought I had already deleted the secondary Challenge info, but there was one more panel that I missed. I got it now, and the second link is gone.
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
