This is a new error from the coauthors table error, so I'm moving it to a new post, if allowed.
I've tried updating my 2.xx efiction to 3.5, and accidently reloaded my website instead of updating it. So I tried to update via the php, and got the coauthors error. This is from my original post:
URL to your eFiction: http://www.meijinhada.org/fallendown
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2.5
Version of MySQL: 5.0.67-community-log
Have you searched for your problem: No; found similar problems by going through the pages
If so, what terms did you try:
State the nature of your problem: A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, co.uid FROM fallenfanfiction_coauthors AS co LEFT JOIN fallenfanfiction_authors as author ON co.uid = author.uid WHERE co.sid = '20'
Error: (1146) Table 'meijinha_fallendown.fallenfanfiction_coauthors' doesn't exist
Do you have a test account for us? No.
So I instead ran upgrade20.php, as was suggested, had a problem with a deleted naughtywords.php, which I fixed; however, I have a fatal MySQL error which I have not found the answer to by searching:
A fatal MySQL error was encountered.
Query: INSERT INTO fallenfanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'LeBeau', '', '', '', '', '', '', '', , '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 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 ' '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, 0' at line 10
I did go to my PHPAdmin and change the version manually, but it still comes up. Now, I also can't "browse;" it tells me the table is empty. So somehow, I managed to delete the settings? I'm confused.
This is what I think your issue is. Many of those fields in 2.0 were, I believe (I'm not very familiar with 2.0), found in dbconfig.php. In 3.0 that stuff is found in fanfiction_settings (config.php merely tells the database name, user, and password), and the script is unable to insert the proper data into the table, which it needs to run a lot of stuff on the site. So you can do this by hand instead. But as I said in the previous thread, you'd still have to get everything after this point in upgrade20.php to run, which will probably be trickier.
Just to note, fanfiction_coauthors is a different table and should be empty at this point, since you don't have any coauthors on your site.
Yeh. I'm just kind of hoping someone will give me a bit of a walkthrough on HOW to edit everything though. I am horribly rusty with this after a year of not dabbling.
If you have access to your database through PHPMyAdmin or similar, then you can go in there and put in the information manually. You can find the default site settings in docs/tables.sql, right at the end. Of course, where things like your sitekey or site slogan, etc., differ, you should go ahead and put those in instead of the defaults.
Well, I did; still nothing. And if I go directly to my page, it claims this:
Warning: Invalid argument supplied for foreach() in /home/meijinha/public_html/fallendown/header.php on line 88
A fatal MySQL error was encountered.
Query: SELECT ap.*, author.uid as uid, author.penname as penname, author.email as email, author.password as password FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs as ap ON ap.uid = author.uid WHERE author.uid = '1'
Error: (1146) Table 'meijinha_fallendown.fanfiction_authors' doesn't exist
If I do a fresh install, then paste in my stories folder, and replace the important php files (like stories, authors, etc) in PHPMyAdmin, do you think that would reasonably bring back my site? Obviously hand-editing isn't working. And I seem to be accumulating more and more errors.
Something else must have failed, before the line with the stuff about the settings table, because the authors table is also missing. Maybe it would be best to start over again, upload backups and then upload the 3.5.1 files again. I don't think refreshing during the uploading of the files should really have any bearing on the success of the upgrade (except maybe in some highly unlikely circumstances?), so I'm wondering if there's something else going on, maybe with your server or something.
