One of the people I webhost for wanted to upgrade to the latest eFiction. They started the upgrade, and it bombed, then they and I started working on it over the last few days. They were on some sort of hybrid code that was between the 1.1 and 2.0 upgrade code (as I've had to patch, change the upgrade PHP files, etc). I've hacked my way to step 16 - and it's been running for five hours now. I know this is a large site, as there are fifteen thousand stories in her archive, but it appears that five hours is a bit too much.
Are there any others with large databases that have upgraded to the latest (3.1) code, and have an estimate time for completion? I know it's still going, since my fanfiction_stories and fanfiction_chapters mysql data files continue to update every few minutes, so it's definitely not hunt.
# of distinct authors: 1900
# of distinct stories: 15,500
Which upgrade are you doing? 1.1 or 2.0 since you said it was a hybrid of both.
Okay I'm going to guess the 1.1 update as the most likely cause of step 16 is going to be there. It's got to rename all the folders members folders from the penname to the uid field. So yeah, that could be taking a while. Although I think we identified a problem with that step and it may be failing on you. You may want to kill that step if the folders aren't being renamed to numbers, use step 16 from the upgrade20.php file and then continue with the 1.1 from step 17 on. You'll have to rename the folders by hand though or write a script yourself to do it.
I actually chose the 2.0, since it appeared to me closer to the version she was running than the 1.1 upgrade. It did finish during the night, and I was able to move on to the other steps this morning.
The only issue now (and I can open a new request on this) is there are no longer any Admins. The one user that was is now just a regular user. I'm coming at this a little blind (just a hack) so I don't know what makes a user an admin. A quick search on these forums for "add new admin" didn't come up with anything. Any hints?
Normally the person who sets up the efiction install is the admin. You create a username (or keep it as Admin) and a password. If you want another person to be an admin, you have to log in (as Administrator), click on Admin->Admins, click Add new Admin.
Choose the user you want to have admin privileges.
If you want them to be admin of it all select Level 1, if you only want them to be admin of a certain category, you choose a lover number. If yoiu only want to have the power of uplload their own stories (then that's Level 4)
Then click the submit button.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Only problem is, the administrator is frozen out of being an administrator now. There has to be some switch somewhere in the database that indicates a user is an administrator - just need to find out what that switch is.
I think if you go to myPHPAdmin and get to the fanfiction_authorprefs, if you know the uid number of the administrator, click the box next to their number and select edit. Look for where it says Level and change it from 0 (member) to 1 (admin). Then save. That should work.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
Is this resolved now? If there's been no response in a week, this thread will be closed.
