URL to your eFiction: efictiontest.verilyviridian.com
Version of eFiction: 3.0.2
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4
Version of MySQL: 4.1.21-standard
Have you searched for your problem: yes
If so, what terms did you try: 3.1 upgrade
State the nature of your problem: I'm attempting to upgrade from 3.0.2 to 3.1. Upgrading the database through the "Run Update" tool isn't working. It keeps throwing up mySQL errors and adding strange duplicates to my tables. I've already restored a backup of my tables, reuploaded everything (in case I missed something), and tried it again.
I think I just need to modify the tables by hand, but the .sql files in the 3.1 docs appear to be the exact same as the ones in 3.0.2. I'm very tired right now, so it's possible I am seeing things, though. Are the changes noted somewhere?
Check the news thread. If you had problems upgrading and ended up with duplicates in the authorinfo table it was throwing errors. Since you haven't said exactly what errors you're getting, I can't give you more suggestions than that.
That's one of the errors I was getting. I'll try it now, thanks!
I'm having problems with more than just the authorinfo table, and running the script found here ( https://efiction.org/forums/index.php?topic=4472.0) didn't help.
Here's the specific errors:
A fatal MySQL error was encountered.
Query: alter table testfanfiction_blocks add unique index block_name (block_name);
Error: (1062) Duplicate entry 'recent' for key 2
The authorinfo error, for posterity's sake:
A fatal MySQL error was encountered.
Query: alter table testfanfiction_authorinfo add primary key(uid,field);
Error: (1068) Multiple primary key defined
My understanding of the databases is very shaky. I've found information fo authorinfo, but not the blocks one. Is it the same type of problem?
Also, this is just for my test site. I'll be upgrading the real archive from 2.0.7 soon. Should I be running into these problems again? The server has the same specs.
I'm pretty lost right now, so any help is greatly appreciated!
It's similar. Somehow you have the recent block in there twice. You'll need to use phpMyAdmin and delete the 2nd recent block entry in the PREFIXfanfiction_blocks tables.
Okay, I fixed the blocks issue. Somehow the table had gotten changed and duplicated news and recent. Could this have anything to do with the 'who's online' or search blocks that I initialized? I notice that there are fields named 'online' and 'search' there that don't exist in the blocks.sql in the docs folder. (Or I could have messed something up - I had to do this one by hand in the upgrade from 2.0.7.)
Thanks for the quick response, Tammy. You were so fast, that you posted while I was modifying mine about that script not working.
However, after I fixed the blocks issue, I got no further MySQL errors, even though I'd reverted to a previous copy of my databases and only changed the blocks one. I'm not sure what happened to the authorinfo error, though I'm not seeing the actual author info in any of the skins. The only thing showing is their stories and favorites, etc. http://efictiontest.verilyviridian.com/viewuser.php?uid=1
Do you have profiles turned off in your site settings?
I feel kind of silly now - I didn't even realize that was an option. I know that it was on a few days ago, so one of the other people with admin status probably turned it off.
Everything appears to be working now; thanks very much!
