Hi !
I tried to update my 1.1 version to 3.2.1 and when I agree to this message :
This update will perform some tasks on the database to better your site's performance. You are advised to back up your database before starting!
Are you ready to update? Yes or No
I first got a message telling me that fanfiction_stats already existed. So then, I deleted it but now, it tells me that :
Query: ALTER TABLE `fanfiction_inseries` DROP `updated`
Error: (1091) Can't DROP 'updated'; check that column/key exists
And it the table, it doesn't exist. Plus, each time I leave Efiction, the message about fanfiction_stats is back again.
There's the message:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_stats` ( `sitekey` varchar(50) NOT NULL default '0', `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT NULL default '0', `reviews` int(11) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers` int(11) NOT NULL default '0', `newestmember` int(11) NOT NULL default '0' ) ENGINE=MyISAM
Error: (1050) Table 'fanfiction_stats' already exists
What can I do ?
How many times have you tried to update? It sounds like some of the update's been attempted.
You're first problem, you didn't have to delete the table. When you get an error like that, it's not really an error, since all the SQL statement was for was to create the table if it didn't exist. In fact, if there was a statement with it to the effect of IF NOT EXISTS [my syntax is prolly off], then you wouldn't have been alerted to it, it would have run the statement, then progressed to the next command. You can move to the next step. I usually offer up doing manual for people that did the upgrade but ran into and error or problem at a certain step, cause then you can skip the statements/actions that were already done. I'd guess that you ran the update to a point and then tried again and seeing this error because this step was done successfully when your originally did the update.
Second error: Again not an error per se as the action would have been done if it was there. This is why I asked initially how many times the update has been done.
Third error: see above. The update is trying to create a table..you're getting that error because it can't run that statement due to the fact that the table already exists.
So to answer your question, it sounds like you're got through that part of the upgrade just fine. Do you know what step it is that you run into problems?
Do you have a url that people can look at your site and see what's going on?

Sounds more like you get sent to the 3.X to 3.3 update rather than 1.1 to 3.3 upgrade.
Goto http://www.yoursite.com/install/upgrade11.php where http://www.yoursite.com is your efiction website.
Tammy, I really updated from the 1.1
Chelle, I tried to update many times. I don't even know the number, but each time, I restored the db I saved just before starting the upgrade. I'm really not good with these things so I don't know how to instal manually.
My URL is http://www.onlygilmoregirls.net/fanfictions but all you'll see is that the website is in maintenance.
Hi !
I tried to update my 1.1 version to 3.2.1 and when I agree to this message :
This update will perform some tasks on the database to better your site's performance. You are advised to back up your database before starting!
Are you ready to update? Yes or NoI first got a message telling me that fanfiction_stats already existed. So then, I deleted it but now, it tells me that :
Query: ALTER TABLE `fanfiction_inseries` DROP `updated`
Error: (1091) Can't DROP 'updated'; check that column/key existsAnd it the table, it doesn't exist. Plus, each time I leave Efiction, the message about fanfiction_stats is back again.
There's the message:A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_stats` ( `sitekey` varchar(50) NOT NULL default '0', `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT NULL default '0', `reviews` int(11) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers` int(11) NOT NULL default '0', `newestmember` int(11) NOT NULL default '0' ) ENGINE=MyISAM
Error: (1050) Table 'fanfiction_stats' already existsWhat can I do ?
First, in 1.1 you shouldn't have a stats table. Second, I can't find anything in the upgrade script for the fanfiction_inseries table except the lines that create it. There's no alter command in the script for that table. Are you sure you've got all the files uploaded? Pull the site out of maintenance. You may be okay except for the missing stats table. We can walk you through adding that.
