2.0.7 to 3.2.1 Step 19 MySQL fatal error

Onto your step 19 errors:

Basically what's happening is the upgrade script is trying to alter the table by deleting something that it can't find.  This is the drop error you had first which prompted you to try manual.  When you get the primary key already exists error, this means that the table already has that index defined.  It's ok to run the next statement.    First though, take a look at your fffanfiction_authorinfo table and verify that your index was defined.  It'll be in the lower left and should look something like this

Steps:

Access phpMyAdmin
Click on your fanfiction_authorinfo table
You should see an area that says Indexes in the lower left side of the screen

Just verify that you do have a primary index defined and it has the fields uid and field. 

Now, onto doing the DB optimization manually. You'll be copy/pasting statements one at a time from optimize.sql.  You've already put your prefix in front of the table, so you're good to go there.  [I'm just keeping that step in there for anyone else that reads this and has the same problem]

Steps:

Access phpMyAdmin
Click the tab for SQL
You'll see a box.
Open the optimize.sql file in a text editor like notepad
Add your table prefix in front of each table name. 
Copy/paste the first statement into that box, click go. Do this one at a time for each statement. 

Make a note of the errors you get, so you can look at the table in question and verify any missing data is not there for statements that are dropping [aka deleting] information.  Also make note of errors for things being altered.  Chances are the table's already altered, and you'll prolly get an error stating duplicates for any ALTER statements you run or the multiple primary key error.

Now from this, looking at the upgrade script, I'm not 100% certain so perhaps Tammy, Carrissa, Jan_AQ et al can clarify.. it looks like a part of step 19 does some updating in addition to the sql statements in the sql file.  What I would do [and I tend to do things the hard way first, so you may want to wait for another suggestion :P] is to alter the upgrade20.php to take out the optimizing queries you've just done manually and run step 19.  I can detail that below if you want to try it.

Steps:

Make a copy of upgrade20.php  [this will be your backup copy in case my suggestion doesn't quite work out.  Backups are good,  backups are wise  :lol:]
Open upgrade20.php in a editor like notepad
Find the code that says:

	case "19":

Then look for lines that follow after it that says

		if(isset($_GET['install'])) {
if($_GET['install'] == "automatic") {
dbquery("alter table ".$tableprefix."fanfiction_categories drop index category;");
dbquery("alter table ".$tableprefix."fanfiction_categories drop index parentcatid;");
dbquery("create index byparent on ".$tableprefix."fanfiction_categories (parentcatid,displayorder);");
dbquery("create index forstoryblock on ".$tableprefix."fanfiction_chapters (sid,validated);");
dbquery("alter table ".$tableprefix."fanfiction_comments drop index nid;");
dbquery("alter table ".$tableprefix."fanfiction_comments add index commentlist (nid,time);");
dbquery("alter table ".$tableprefix."fanfiction_inseries drop index seriesid;");
dbquery("alter table ".$tableprefix."fanfiction_inseries drop index inorder;");
dbquery("alter table ".$tableprefix."fanfiction_inseries add index (seriesid,inorder);");
dbquery("alter table ".$tableprefix."fanfiction_inseries drop index sid;");
dbquery("alter table ".$tableprefix."fanfiction_inseries add primary key (sid,seriesid);");
dbquery("create index avgrating on ".$tableprefix."fanfiction_reviews(type,item,rating);");
dbquery("alter table ".$tableprefix."fanfiction_reviews drop index sid;");
dbquery("create index bychapter on ".$tableprefix."fanfiction_reviews (chapid,rating);");
dbquery("alter table ".$tableprefix."fanfiction_reviews add index byuid (uid,item,type);");
dbquery("alter table ".$tableprefix."fanfiction_series drop index owner;");
dbquery("create index owner on ".$tableprefix."fanfiction_series (uid,title);");
dbquery("alter table ".$tableprefix."fanfiction_stories drop index validated;");
dbquery("create index validateduid on ".$tableprefix."fanfiction_stories (validated,uid);");
dbquery("create index recent on ".$tableprefix."fanfiction_stories (updated,validated);");
dbquery("ALTER TABLE `".$tableprefix."fanfiction_inseries` DROP `updated`");
dbquery("ALTER TABLE `".$tableprefix."fanfiction_news` ADD `comments` INT NOT NULL DEFAULT '0'");
dbquery("ALTER TABLE `".$tableprefix."fanfiction_series` ADD `numstories` INT NOT NULL DEFAULT '0'");
$serieslist = dbquery("SELECT seriesid FROM ".$tableprefix."fanfiction_series");

You want to take out all the lines that start with dbquery  since these are the statements you have just run manually.  When you're done that section should look like this:

		if(isset($_GET['install'])) {
if($_GET['install'] == "automatic") {

$serieslist = dbquery("SELECT seriesid FROM ".$tableprefix."fanfiction_series");

That should be all you have to change.  Save the file, upload it to your server overwriting the copy that's already there.  Then in your browser, put in this URL:

http://www.youreficURL/install/upgrade20.php?step=19

After that's done, access your archive.  Go to Admin > Archive Maintenance and click on recalculate reviews, and recalculate site stats.  See if that doesn't fix your site statistics problem.