Hi folks,
I made a secondary copy of my entire installation and copied the database as well so that I could try upgrading the current 2.x installation to the newly released 3.2. I uploaded all the 3.2 files and replaced the old ones (I didn't delete any, though!) and ran the upgrade20.php, which worked fine fine fine all the way up to updating the Stories and Series table.
When it got to updating Stories and Series Information (the first batch, 1 - 186) I got a black page with this error:
A fatal MySQL error was encountered.
Query: UPDATE fafafanfiction_series SET confirmed = 1, classes = '2,10' WHERE seriesid = '8'
Error: (1054) Unknown column 'confirmed' in 'field list'
What can I do?
Please update your post to conform to the Support Request Template, as we don't even have a link to your site, so we can't even take a look at it.
My apologies! Here w go:
URL to your eFiction: http://www.furrag.com/beta9
Version of eFiction: 3.2 (upgrade from 2)
Have you bridged eFiction, if so with what?: None, clean update
Version of PHP: 4.4.4
Version of MySQL: 5.0.24-standard
Have you searched for your problem: Yes
If so, what terms did you try: The error message text: Error: (1054) Unknown column 'confirmed' in 'field list'
State the nature of your problem: Upgrade to 3.2 fails at Step 11: Error: (1054) Unknown column 'confirmed' in 'field list'
Do you have a test account for us? I'm unable to create new acounts since the site is in maintenance mode and I can't get it out since the installation won't complete!
Try this link, though: http://furrag.com/beta9/install/upgrade20.php?step=11&install=automatic&offset=200
It *ought* to work, because when 3.0 just came out I tried a test update as well. Again, I'd made a copy of the entire eFiction 2 installation and its database and updated that by uploading all the 3.0 files and running the upgrade script -- not a hitch, that time. I never got around to creating the kind of skin that I wanted, but now I've got some time on my hands and wanted to try again.
Hey, if anyone has a download link for 3.0, I could try upgrading to that first, then go to 3.2 -- just to see if it'll work.
Hey, if anyone has a download link for 3.0, I could try upgrading to that first, then go to 3.2 -- just to see if it'll work.
Unfortunately 3.0 contains security holes, so I would highly not recommend to attempt to do that, unless doing private testing.
As I say, I'm doing this upgrade on a redundant and secret backup of the live site to make sure that the upgrade process can proceed without a hitch when I upgrade the live site. Since I performed just such an upgrade last year with 3.0 (without a hitch) and have made absolutely no changes to the site since then, I wanted to try to hop-skip; upgrade to 3.0 first and then from 3.0 to 3.2. If that works, then at least I know I can upgrade, although I will of course still help with whatever you need in order to fix whatever's going wrong in the current upgrade script!
It's a bug in the upgrade script. I'm working on it.
Excellent! Thank you so much!
Re-download the full .zip. It should work now. You'll probably need to restore your test site to 2.0 and start over from the beginning.
I'll let you know how it goes!
No joy, unfortunately. I started over all the way from scratch, with a fresh 2.0 backup. It halts at the same step, with this new message:
A fatal MySQL error was encountered.
Query: UPDATE fafafanfiction_series classes = '2,10' WHERE seriesid = '8'
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '2,10' WHERE seriesid = '8'' at line 1
There appears to be a typo in install/upgrade20.php on line 536. Change fanfiction_in_series to fanfiction_inseries. But I'm still running into problems at step 12.
Hey! As of the March 17th version (3.2), the upgrade from 2.x to 3.2 worked flawlessly. All solved!
