[Solved] Upgrading from 2.0.7 to 3.2.1 Error

cloudyvisions · 2007-04-11T05:44:17Z

URL to your eFiction:- this is an exact replica of my real archive, because I wanted to test it out first. My real archive isof eFiction: 2.0.7Have you bridged eFiction, if so with what?: No?Version of PHP: 4.1.21Version of MySQL: 4.1.10Have you searched for your problem: YesIf so, what terms did you try: Upgrading, 2.0.7, mysql error, 1050 errorState the nature of your problem: I tried to explain the best I could below.Do you have a test account for us? No, but the real archive as a test pw: test, even though I don't think that would help.I wanted to give the upgrade a test run before trying it live, so I uploaded a copy of my entire archive into a new folder to try it out before I did it for real. I get to what I believe is step 4 and it asks me to install tables. and I say that I want to install them automatically. When I choose that, this is what comes up:A fatal MySQL error was encountered.Query: CREATE TABLE `fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;Error: (1050) Table 'fanfiction_authorfields' already existsI tried what another thread suggested - I went to the tables.sql file in the "docs" folder and I added a prefix to all of the tables. It sorta worked that time but none of the authors and stories showed up when I got to the empty archive. And I'm upgrading, I want to keep all of my authors and reviews, etc. so I didn't think that would work. Then I started over back at 2.0.7 and tried to bypass all of the tables prefixes because it just wouldn't let me get through that part, but I was stopped at step 8 with the Message Data:A fatal MySQL error was encountered.Query: INSERT INTO `fanfiction_messages` (`message_name`, `message_title`, `message_text`) VALUES ('', '', '');Error: (1146) Table 'sinfulde_archive.fanfiction_messages' doesn't existSo I am just confused and completely stuck. I spent over 4 hours trying to upgrade to the new version with no success. I would really like to upgrade to 3.2 because I played around with it and it's a wonderful upgrade, but I have 400 members and 1000 stories that I don't want to lose. Thank you in advance you guys!

Page 2 / 2 Prev

Graveyard

Last Post by cloudyvisions 19 years ago

16 Posts

4 Users

0 Reactions

5,127 Views

RSS

cloudyvisions

(@cloudyvisions)

Posts: 78

Trusted Member

Topic starter

Thank you for the help! I'm hoping that someone in the Skins section will be able to help out with the site info blocks issue.

URL: http://www.sinful-desire.org/archive
Version: 3.5.2
Modules: Story End, Beta Reader, Challenges, Story Tracker
PHP: 5.2.5
MySQL: 5.0.67

Posted : 13/04/2007 9:55 pm

Page 2 / 2 Prev

32 Forums
3,761 Topics
20.9 K Posts
0 Online
4,466 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Become a Patron!

[Solved] Upgrading from 2.0.7 to 3.2.1 Error

Share this:

Like this: