URL to your eFiction: http://sleepingjaguars.com/buffy/
Version of eFiction: 3.5.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.8
Version of MySQL: 5.0.45
Have you searched for your problem: Yes
If so, what terms did you try: Various error numbers
State the nature of your problem:
When updating from 3.5 to 3.5.1, I accidentally overwrote my config.php. I tried to edit it manually to restore the correct settings. However, I keep getting errors like this:
A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_blocks
Error: (1146) Table 'buffyfic.fanfiction_blocks' doesn't exist
The database buffyfic does exist, and the blocks table is there, along with all the other tables. But the actual name of the table in the database is buffyfanfiction_blocks.
The settings table has a different prefix than all the other tables - it's buffysettingsfanfiction_settings. I'm guessing that's part of the problem? If I edit the $settingsprefix in the config.php file to say buffysettings, it works for the settings table but nothing else, but if I edit it to say buffy, I get errors on the settings table. I can't see a way to edit the name of a table in my webhost's MySql application, but I could be missing something.
Do you have a test account for us? Right now I can't get into the site at all.
There's a difference between $settingsprefix and $tableprefix. Set $settingsprefix to whatever it is for your settings table. The place where $tableprefix is stored at is in your settings table, so look for the field in there, and make sure it matches the prefix for all the tables but the settings table.
OK, I went into the settings table, and tableprefix was empty. I set it to buffy, but I'm still getting that same error when I reload the site. (I'm loading http://sleepingjaguars.com/buffy/, but the error message comes up on http://sleepingjaguars.com/buffy/maintenance.php)
Hmm... I don't know why it's doing that since the table exists and the table prefix has been fixed. The only thing I can offer at this point is that if you wanted to turn maintenance mode off, you could set the maintenance field in fanfiction_settings to 0. Hopefully somebody else can step up with some suggestions because I'm going on vacation for a week. : )
Hm. According to the database, maintenance is already set to zero.
I re-uploaded the install directory and ran through most of the installation again, and that seems to have fixed the errors. The only weird thing now is that on my admin page, I now have two copies of every link:
Add New Series | Add New Story | Add New Series | Add New Story | Featured Stories | News | Featured Stories | News | Submissions | Submissions | Admin Manual | Admin Manual | Skins | Skins | Version Check | Version Check
etc.
I can certainly live with that, but it's kind of odd.
You can fix the double links in your admin page by going to Admin->Pagelinks. Look at the list there and where you see two of the exact thing listed you click the delete link next to the one you don't need.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Are you still having problems with this rahirah?
