URL to your eFiction: http://www.englishspice.net/fics/
Version of eFiction: 3.3
Have you bridged eFiction, if so with what?: Not unless eFiction bridges itself
Version of PHP and MySQL: Whatever Yahoo! Small Business is using (I can't tell)
Have you searched for your problem: Yes
If so, what terms did you try: I searched "challenges", "betas" and "images" and I found a few that I thought might be similar, but they weren't.
Do you have a test account for us? No
-------------------------------
I have several problems...
1] I installed the Challenge mod alright and can issue challenges, but when I hit "respond to challenge", I get
A fatal MySQL error was encountered.
Query: SELECT title, seriesid FROM fanfiction_series WHERE uid = '1' AND FIND_IN_SET(3, challenges) < 1 ORDER BY title ASC
Error: (1054) Unknown column 'challenges' in 'where clause'
And when I click on the challenge name (as if to look at the stories in response to the challenge), I get:
A fatal MySQL error was encountered.
Query: SELECT COUNT(seriesid) FROM fanfiction_series as series WHERE FIND_IN_SET(3, challenges) > 0
Error: (1054) Unknown column 'challenges' in 'where clause'
Jan_AQ suggested uninstalling and reinstalling the Challenge mod, but it won't uninstall. I have a feeling it's a coding error, however, so if you know what to do, suggestions would be helpful.
2] The Beta Reader list won't install. I install it and say "yes" when it says "are you sure?", but when I go back to the mod list, the install link is still there.
3] I've turned on images in stories, but when I hit "manage images", the page comes up blank. Sounds like a missing page in the install files or something, but I have no experience with eFiction, so I don't know what it would be.
Thanks in advance for all your help!
I have a feeling it's a coding error...
Usually it's not.
Uninstall the modules manually. There should be a challenges table in the database, delete it (drop). There's a module table listing challenges, delete that row. They might have been installed twice, since it was installed on my site already, so you might have to delete it twice, or more if you tried installing it more than once.
Then reinstall.
Images - It's probably because you are set to store stories in the database; images are usually saved in the author's folders. Since you don't have a folder for stories CHMODed, you probably will not be able to upload images to your site.
Beta reader - just ignore that. It's installed. I installed it with an older module version that didn't include the information that it was installed. You have to edit the module to fix it, or the database or something, but I was too lazy to do it. There are instructions for it somewhere, probably on the boards here.
Always leave a link to your site, the version and if it's been modified in anyway when asking for support.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Apparently, you tried to install the beta module 4 extra times.
http://www.englishspice.net/fics/authors.php?list=authors
The scroll down menu lists the beta sort there. Sorry if that doesn't make sense, i've been up all night. :
You're going to have to clean that up manually in your database.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
When you've had a nice rest, send me a private message and we can get together on IM and you can walk me through it...
You always seem to make more sense on YIM, for some reason...maybe it's because you have plenty of time to explain and I have plenty of time to be blonde. π
*drones, "I did knowingly and willfully post a message without the required header. I acknowledge my reprimand from Jan and I do hereby apologize."*
Haha. XD
Yeah, unfortunately my computer with my efiction information and bookmarks and everything won't turn on, I'm using my bro's comp when he's not on. So I don't know how much of a walkthrough I can actually give from memory... And as you can imagine, I'm in a really grumpy mood right now. XD I really hope I can get my computer working again in the next week!
Database editing should be easy though. If you can get into phpmyadmin.
You click on the table "fanfiction_challenges" and then in the right hand part, you click on "drop table".
Then you go into the fanfiction_ modules table. You select a row there (there should be check boxes) and then click on the X at the bottom of the page to drop the row(s).
The module rows you want to delete should be the challenges row, and all of the Beta Readers except for one.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Using phpMyAdmin is scary if you've never done it before...you just follow Jan's instructions and hope to Goddess you're doing the right thing. π (It's like jumping off a cliff, I'm telling you!)
~)~
You click on the table "fanfiction_challenges" and then in the right hand part, you click on "drop table".
I accessed the table and hit "drop table" on the menu bar. I hope that was the right thing to do.
Then you go into the fanfiction_ modules table. You select a row there (there should be check boxes) and then click on the X at the bottom of the page to drop the row(s).
I clicked the corresponding table, but I didn't find a list of rows. I see "row statistics", but that's it. I tried finding a list of rows by hitting "browse" on the menu bar, but all that came up was "challenges", "story end" and "recommendation" on the modules list, even after I expanded the query to 100 rows (starting from record 0).
I'm close on that one, but no peanuts.
And one more...
Images - It's probably because you are set to store stories in the database; images are usually saved in the author's folders. Since you don't have a folder for stories CHMODed, you probably will not be able to upload images to your site.
No way at all to have images?
Oh, wait...I think I may have solved that one...
There is already one field for pix on outside servers, like photobucket...if I add a similar field to the profile, I can have staff icons included. Yay!
~)~
Thank you for all your help, Jan...I'd be pulling my hair out, if it wasn't for you!
Oh dear...
A fatal MySQL error was encountered.
Query: SELECT COUNT(uid) FROM fanfiction_challenges WHERE (uid = '1')
Error: (1146) Table 'spicey.fanfiction_challenges' doesn't exist
(When I tried to click on my profile) I assume that's because I deleted it.
I went to reinstall, but I still only found the "options" and "uninstall" link.
Am I going to have to reinstall manually?
It's because you didn't delete it completely. You only deleted half of it.
Then you go into the fanfiction_ modules table. You select a row there (there should be check boxes) and then click on the X at the bottom of the page to drop the row(s).
That should read: Then you go into the fanfiction_ modules table. You select the challenges row there (there should be check boxes) and then click on the X at the bottom of the page to delete it. Do the same for the beta modules.
I tried finding a list of rows by hitting "browse" on the menu bar, but all that came up was "challenges"...
Yes, delete challenges. You want to uninstall the challenges module, right? Well that row says that challenges is installed. With it deleted, (after the fanfiction_challenges table deleted as well) you can reinstall it.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word