URL to your eFiction: http://www.vampires-kiss.net/archive1/
Version of eFiction: was version 2, trying to update to version 3
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4
Version of MySQL: 4.1.22-standard-log
Have you searched for your problem: yes
If so, what terms did you try: Invalid argument supplied for foreach, Step 2 Errors
State the nature of your problem:
Warning: Invalid argument supplied for foreach() in /backup/tmphome/vampires/public_html/archive1/header.php on line 86
A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_blocks
Error: (1146) Table 'vampires_archive.fanfiction_blocks' doesn't exist
Do you have a test account for us? no
I've tried to update my efiction script from 2.xx once before. I couldn't figure out the problems, so I ended up going back to the 2.xx version. But the site has been getting hit by tons of spam (they even started making memberships!), so I decided to try again. I started fresh, uploading all the files in a new folder with the correct database info.
And now I'm lost. Any help would be much appreciated!
Well it says 'vampires_archive.fanfiction_blocks' doesn't exist, so I'd look into my database and see if that table exists or not. If it doesn't, I think there is a list of what it's sql structure is supposed to be in the /docs folder of your eFiction download so you can copy paste it in?
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
I checked out my database and the table is named ficfanfiction_blocks, not fanfiction_blocks. I did look at the tables.sql file, but I'm not too sure how to go about fixing this.
(sorry! I'm still learning my way around mysql!)
There should be an operations tab in the main/right section. Click on it. You should be able to rename it there. But if one table is not named right, the others probably are too. After reading your post, I remember that eFiction 3.3 had a problem with table prefixes not sticking.
https://efiction.org/forums/index.php?topic=5364.0
You can rename the tables to take the prefix off, or you can try what Goku Girl did:
The easiest way to fix this is to go into phpMyAdmin and delete the prefix from the settings table (edit the table, NOT empty it) then hit the back button to redo step 10.
https://efiction.org/forums/index.php?topic=5266.0
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
Thank you! I fixed the prefix on that (and a few other ones that kept saying they didn't exist. Now I'm getting this message;
Warning: Invalid argument supplied for foreach() in /backup/tmphome/vampires/public_html/archive1/header.php on line 86
Warning: Invalid argument supplied for foreach() in /backup/tmphome/vampires/public_html/archive1/includes/pagesetup.php on line 102
Did I do something wrong? *panics*
In Goku Girl's instructions, she said to redo step 10. I don't know how to do that, so if you didn't figure it out we'll have to wait for someone else to answer.
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
In Goku Girl's instructions, she said to redo step 10
Since I still seem to be stuck on Step 2, guess I'll have to wait! Thanks for your help.
