Okay, so now that I've finished one site, I'm on to the other one and I'm getting an error I can't figure out on this one.
URL to your eFiction: http://smfanfiction.net
Version of eFiction: 2.0.7
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.4
Version of MySQL: 5.0.24a
Have you searched for your problem: Yes
If so, what terms did you try: Query: INSERT INTO fffanfiction_favorites(uid, item, type) SELECT uid, sid, 'ST' FROM fffanfiction_favstor, Error: (1062) Duplicate entry '940-ST-48' for key 1, Error: 1062, step 13
State the nature of your problem:
I'm upgrading and at step 13 I get the following message:
A fatal MySQL error was encountered.
Query: INSERT INTO fffanfiction_favorites(uid, item, type) SELECT uid, sid, 'ST' FROM fffanfiction_favstor
Error: (1062) Duplicate entry '940-ST-48' for key 1
I don't know how to fix this. O_o
My eFiction Archives
http://smfanfiction.net
http://meijitales.com
http://pontapair.com (under construction)
ah duplicate entries, I'd wait for a mod, but as a fellow user I'd empty the field in PHPMyAdmin then try again
I am rebuilding efiction! Join us on irc! #efiction at
Empty what field? How do I do that?
My eFiction Archives
http://smfanfiction.net
http://meijitales.com
http://pontapair.com (under construction)
You're probably going to have to clean your favorites stories table up before you can upgrade. At some point one (or more) people set the same story as favorite more than once. You need to remove the duplicates.
