2.0.7 to 3.2.1 Step 19 MySQL fatal error

bunny · 2007-04-15T21:36:29Z

I have no idea why it's doing this. I tired it automatic and manually and I'm getting errors both ways:URL to your eFiction:of eFiction: 2.0.7Have you bridged eFiction, if so with what?: NoVersion of PHP: 4.4.4Version of MySQL: 5.0.24aHave you searched for your problem: YesIf so, what terms did you try: A fatal MySQL error was encountered., Error: (1091) Can't DROP 'category'; check that column/key existsState the nature of your problem: I'm upgrading and at step 19 when I select "automatic" I get the following message: A fatal MySQL error was encountered.Query: alter table fffanfiction_categories drop index category;Error: (1091) Can't DROP 'category'; check that column/key existsWhen I did it manually, first (FYI) I have ff before each table, so I had to add the ff to the optimize.sql file (if you want to make a note of that for others) once I got that problem solved this is the error I get from MySQL:ErrorSQL query: ALTER TABLE fffanfiction_authorinfo ADD PRIMARY KEY ( uid, field ) ;MySQL said: #1068 - Multiple primary key defined Do you have a test account for us? test - password is passwordThe site DOES seem to be working...but the blocks aren't activating and the stats are all showing zero even though there are definitely numbers for there.

Page 2 / 2 Prev

Graveyard

Last Post by bunny 19 years ago

16 Posts

4 Users

0 Reactions

5,165 Views

RSS

bunny

(@bunny)

Posts: 18

Active Member

Topic starter

Thanks for all your help with this, Chelle. I really appreciate it.

I wanted to fix the error so there would hopefully not be future ones, but I'm with you on the stumped bit. I broke down and emptied the table on MySQL and manually entered the correct stat values. Now it's showing them correctly.

That seems to have fixed the stats problem. I'll have to look more into the reveiws error bit that was reported to me and then I'll hopefully be finished with this upgrade. 😉

My eFiction Archives
http://smfanfiction.net
http://meijitales.com
http://pontapair.com (under construction)

Posted : 17/04/2007 1:37 pm

Page 2 / 2 Prev

32 Forums
3,760 Topics
20.9 K Posts
1 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!

2.0.7 to 3.2.1 Step 19 MySQL fatal error

Share this:

Like this: