Problem Upgrading 3.11 to 3.2

Delete the queries that give you errors. It most likely means they've already been done. You'll just have to delete them one at a time, or in groups, until you get to the ones that run. It's a pain in the ass, I know, but if you didn't back up, then there is nothing else you can really do.

TY TY TY. Tis sorted now. After deleting lots and LOTS of dbquery lines it updated to a blank screen. So I put in my url and it came up on the main page. Upon going to admin I saw that I was running 3.2. HALLELUJAH.

I got the same error trying to upgrade from my eFiction 1.1 to 3.2.1. After uploading the files and running the upgrade, the site asks me to update. But I gives me the "Error: (1050) Table 'fanfiction_stats' already exists". I did what was said here, I rolled back to my back up, and tried to update again, but got the same error. So I tried to upload the upgrade.php, and after deleting lots of query lines, I gives me a black page. But if I enter my url it still gives me a blank page (upgrade.php). I don't know what else to do.

My url: http://www.panbox.com.br/fusion/eFiction1.1/index.php

I got the same error trying to upgrade from my eFiction 1.1 to 3.2.1. After uploading the files and running the upgrade, the site asks me to update. But I gives me the "Error: (1050) Table 'fanfiction_stats' already exists". I did what was said here, I rolled back to my back up, and tried to update again, but got the same error. So I tried to upload the upgrade.php, and after deleting lots of query lines, I gives me a black page. But if I enter my url it still gives me a blank page (upgrade.php). I don't know what else to do.

My url: http://www.panbox.com.br/fusion/eFiction1.1/index.php

I will assume the update went through because when I click on your link I get your maintenance page. So try logging in and see if everything is in order, then turn the maintenance page off by going to Admin->Settings->Site Settings

Thanks for answering...

When I try to login, the site opens the http://www.panbox.com.br/fusion/eFiction1.1/update.php and I get a blank page...

I get a 404 error on Yukii's site.  Did you take the files down?

Yes, I tried to do everything once again, and I still get the same blank page...

This is how my update.php looks like after deleting all the dbquery lines that were giving me errors...

<?php
// ----------------------------------------------------------------------
// eFiction 3.0
// Copyright (c) 2006 by Tammy Keefer
// Valid HTML 4.01 Transitional
// Based on eFiction 1.1
// Copyright (C) 2003 by Rebecca Smallwood.
//  http://efiction.sourceforge.net/ 
// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// To read the license please visit  http://www.gnu.org/copyleft/gpl.html 
// ----------------------------------------------------------------------

include("header.php");

$blocks['news']['status'] = 0;
$blocks['info']['status'] = 0;

//make a new TemplatePower object
if(file_exists("$skindir/default.tpl")) $tpl = new TemplatePower( "$skindir/default.tpl" );
else $tpl = new TemplatePower("default_tpls/default.tpl");
include("includes/pagesetup.php");
if(file_exists("languages/".$language."_admin.php")) include_once("languages/".$language."_admin.php");
else include_once("languages/en_admin.php");
// end basic page setup

// check that user has permissions to perform this action before going further.  Otherwise kick 'em
/*
if(!$adminloggedin) {
$output .= "<script language="javascript" type="text/javascript">
location = "maintenance.php";
</script>";
$tpl->assign( "output", $output );
$tpl->printToScreen();
exit( );
}
*/


list($field) = dbrow(dbquery("SELECT field_id FROM ".$tableprefix."fanfiction_authorfields WHERE field_name = 'betareader'"));
dbquery("UPDATE ".$tableprefix."fanfiction_authorinfo SET info = '"._YES."' WHERE field = '$field' AND info = '1'");
dbquery("UPDATE ".$tableprefix."fanfiction_authorinfo SET info = '"._NO."' WHERE field = '$field' AND info != '"._YES."'");
dbquery("alter table ".$tableprefix."fanfiction_blocks drop index block_name;");
dbquery("alter table ".$tableprefix."fanfiction_blocks add unique index block_name (block_name);");
dbquery("alter table ".$tableprefix."fanfiction_inseries add index (seriesid,inorder);");
dbquery("alter table ".$tableprefix."fanfiction_panels drop index panel_type;");
dbquery("alter table ".$tableprefix."fanfiction_panels add index panel_type (panel_type,panel_name);");
dbquery("alter table ".$tableprefix."fanfiction_series drop index owner;");
dbquery("create index owner on ".$tableprefix."fanfiction_series (uid,title);");
$alltables = dbquery("SHOW TABLES");

dbquery("INSERT INTO ".$tableprefix."fanfiction_stats(`sitekey`) VALUES('$sitekey')");
if(!isset($allowseries)) dbquery("ALTER TABLE `".$settingsprefix."fanfiction_settings` ADD `allowseries` TINYINT NOT NULL DEFAULT '2' AFTER `roundrobins`");
dbquery("ALTER TABLE `".$tableprefix."fanfiction_log` CHANGE `log_ip` `log_ip` INT( 11 ) UNSIGNED NULL DEFAULT NULL");
$serieslist = dbquery("SELECT seriesid FROM ".$tableprefix."fanfiction_series");
$totalseries = dbnumrows($serieslist);
while($s = dbassoc($serieslist)) {
$numstories = count(storiesInSeries($s['seriesid']));
dbquery("UPDATE ".$tableprefix."fanfiction_series SET numstories = '$numstories' WHERE seriesid = ".$s['seriesid']." LIMIT 1");
}

$newslist = dbquery("SELECT count(cid) as count, nid FROM ".$tableprefix."fanfiction_comments GROUP BY nid");
while($n = dbassoc($newslist)) {
dbquery("UPDATE ".$tableprefix."fanfiction_news SET comments = '".$n['count']."' WHERE nid = ".$n['nid']);
}

$storiesquery =dbquery("SELECT COUNT(sid) as totals, COUNT(DISTINCT uid) as totala, SUM(wordcount) as totalwords FROM ".$tableprefix."fanfiction_stories WHERE validated > 0 ");
list($stories, $authors, $words) = dbrow($storiesquery);
dbquery("UPDATE ".$tableprefix."fanfiction_stats SET stories = '$stories', authors = '$authors', wordcount = '$words' WHERE sitekey = '$sitekey'"); 

$chapterquery = dbquery("SELECT COUNT(chapid) as chapters FROM ".$tableprefix."fanfiction_chapters where validated > 0");
list($chapters) = dbrow($chapterquery);

$authorquery = dbquery("SELECT COUNT("._UIDFIELD.") as totalm FROM "._AUTHORTABLE);
list($members) = dbrow($authorquery);

list($newest) = dbrow(dbquery("SELECT "._UIDFIELD." as uid FROM "._AUTHORTABLE." ORDER BY "._UIDFIELD." DESC LIMIT 1"));
$reviewquery = dbquery("SELECT COUNT(reviewid) as totalr FROM ".$tableprefix."fanfiction_reviews WHERE review != 'No Review'");
list($reviews) = dbrow($reviewquery);
$reviewquery = dbquery("SELECT COUNT(uid) FROM ".$tableprefix."fanfiction_reviews WHERE review != 'No Review' AND uid != 0");
list($reviewers) = dbrow($reviewquery);
dbquery("UPDATE ".$tableprefix."fanfiction_stats SET series = '$totalseries', chapters = '$chapters', members = '$members', newestmember = '$newest', reviews = '$reviews', reviewers = '$reviewers' WHERE sitekey = '$sitekey'"); 
dbquery("UPDATE ".$tableprefix."fanfiction_inseries SET confirmed = 1");
$update = dbquery("UPDATE ".$settingsprefix."fanfiction_settings SET version = '3.2' WHERE sitekey = '$sitekey'");
$alltables = dbquery("SHOW TABLES");
while ($table = dbassoc($alltables)) {
foreach ($table as $db => $tablename) {
dbquery("OPTIMIZE TABLE `".$tablename."`");
}

 } 

?>

I installed efiction 1.1 in a free server account and uploded my database... And still, I'm getting the same problem...

Well, first off, Yukki, you can't use a 1.1 skin with a 3.x site which is looks like you're doing.Try using one of the skins that comes with the 3.2.1 download.

Second, and this is an fyi to everyone, the solution I posted above was specific to the 3.11 to 3.2 update, and should not be attempted in any other situations. In fact, I'm going to delete the file I posted because it's no longer valid.