http://www.pretendercentre.com/missingpieces/index.php
i have just moved my efic and then ran an upgrade to 3.2. Mostly it has gone smoothly, all except for the challenge mod.
I ran the challenges/install.php and it now has two installs and double everything in my code_blocks table.
I deleted the doubles and that seemed fine, but then i had two challenges links in my admin area. So i unintsalled one of them whch took both of them out.
So reinstalled one, and that seems to be fine. I copied the table_challenges back in and all my challenges are there now.
the problem is that wehn you go to story listings, they are not showing up and i think it is becasue of the code blocks table. I have tried to figure out how to fix it and just cant. I think it has smt to do witht the code_id in the codeblocks, but i have no idea what to change it to, and i am not sure which set of doubles to delete, or if it matters which ones
code_id code_text code_type code_module
1 include(_BASEDIR."modules/challenges/authorof.php"... AO challenges
2 include(_BASEDIR."modules/challenges/storyblock.ph... storyblock challenges
3 include(_BASEDIR."modules/challenges/seriesblock.p... seriesblock challenges
4 include(_BASEDIR."modules/challenges/seriestitle.p... seriestitle challenges
5 include(_BASEDIR."modules/challenges/adminfunction... delchar challenges
6 include(_BASEDIR."modules/challenges/adminfunction... delcategory challenges
7 include(_BASEDIR."modules/betareader/members.php")... membersList betareader
8 include(_BASEDIR."modules/displayword/storyblock.p... viewstory displayword
10 include(_BASEDIR."modules/challenges/authorof.php"... AO challenges
11 include(_BASEDIR."modules/challenges/storyblock.ph... storyblock challenges
12 include(_BASEDIR."modules/challenges/seriesblock.p... seriesblock challenges
13 include(_BASEDIR."modules/challenges/seriestitle.p... seriestitle challenges
14 include(_BASEDIR."modules/challenges/adminfunction... delchar challenges
15 include(_BASEDIR."modules/challenges/adminfunction... delcategory challenges
16 include(_BASEDIR."modules/challenges/otherresults.... otherresults challenges
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Why did you run the challenges/install.php? If you just moved the whole thing, all the files, it should have existed the way it existed before.
Installing the challenges module creates the challenges tables in the database, ect. Uninstalling them deletes them. I think that what you did, was when you uninstalled it deleted all the challenges information from your database.
I think you may need to put a backup of your story info back, or the old challenges info, if you have them. Probably the story database, I don't know for sure without looking.
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
Thanks Jan _AQ, I suspect you are right.
I ran it because it wasnt showing up on any of the usual places it showed up. Then after i ran it, it came twice, so it must have been there and probably just needed a hard refresh or my cache cleared. So i think i made this mess for no reason grrrr.
Have deleted all the duplicates in the codeblocks table and now am just re-submitting the responses. There are only 68 of them so it is not that big a hassle and it seems to be working fine. My count is out but once i do a recaclutae hopefully that will be fixed.
thanks again.
Now i am calmer, and the move has been more or less successful i realise that i probably did some very dumb things. I had never been successful before in restoring a database (backing them up is easy-peasy, but getting the buggers back in was a complete mystery to me. And it was a rush job too cos the damn hacker was ploughing thru my entire site.) Hopefully i will never have to move again, but if i do, i have certinaly learnt A LOT from this experiecne.
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
i'm glad that it's working better now. 🙂 I hope that you get everything working well soon.
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
Thanks Jan_AQ, it is all up and running now as far as i can tell, got some problems with 3.2, but they are the same problems other ppl have, so i am happy about that (how is that for twisted)
Sorry for posting some dumb stuff recently, the whole thing has been quite stressful and i know some of my posts here have been a little inchoherent.
Good news is i have efic back in and running, smf back in and no damage at all, same with coppermine and i have learnt much about mysql and how the tables work, can even restore a back up now, which is a really good thing.
So i am deciding to look at the whole 'some bastard hacker has destroyed my entire domain' as a positive thing now. everyhting is in better addresses (when i started all of this way back when i had no clue ), and now i am confident if a worse-case-scenario happens, i can rebuild the entire thing if necessary 😀
thanks for your help and suggestions, it really made a big help
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
You're welcome. 🙂
Hearing "no damage at all" in getting your bridges back really made me smile. After hard work, it's great that you got them. I wasn't as lucky when it happened to me... twice. 🙂
Would you mind sharing your SMF bridge sometime? i've been wanting one, but have no idea how to go about 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
Actually, i have never bridged anything. I was thinking about bridging to my smf since nearly every member there is also a member at efic. But just as i was beginning to understand even what a bridge was and contemplating having a go at it, all this hacking started.
even though i wasnt bridged, they got me anyway. They got into SMF thru a separate vulnerability and then rode into coppermine because stupid me had the same database password. Then they got into my efic because i hadnt upgraded to 3.2 yet and didnt realise that i needed to delete the bridge folder, as i hadnt installed it.
Now things are settled down, i might to a test run on a brigdge bw sfm and efic on the test site and if i get it running i will give you a full report 😀
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Great, well good luck! 🙂 *crosses fingers for you*
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
