Upgrade from 1.1.11 to 2.0.11

[bwaynef]

I'm pretty sure those are the right versions. 

I posted a thread a while back here and seemed to exasperate most folks because I wanted to do it the hard way.  I ended up hesitating and putting it off.

I decided today I could go ahead and start the upgrade like I was told ...and things would probably go off well and I wouldn't have anything to worry about.

Forum is backed up (db & files).
Files for the new version are uploaded.
Navigate to forum-url/upgrade.php.
Logged in.


Then I'm hit with:
"Unknown column 'a.attachment_type' in 'field list' "

Any help?

[Illori]

are you sure upgrade.php did actually run? it sounds like it did not.

[Sir Osis of Liver]

Did upgrade.php throw that error, or do you see it when trying to load 2.0 install after upgrade?
 

[bwaynef]

After I log in on the upgrade.php page, to begin the process of upgrading, I get that error.  Coincidentally, I get it when I navigate to http://forum-url.com/ as well.

[Illori]

if you are running upgrade.php it should not give you that error as it is to upgrade your forum and fix getting errors like that.

if you are getting that when running upgrade.php can you provide a screenshot of the page that is making that error show up?

[Sir Osis of Liver]

Was your 1.1.11 install running correctly before you started?  Sounds like upgrade.php is getting to Step 4: Database Changes, correct?

[bwaynef]

I navigate to the /upgrade.php and am presented with the page depicted in the screenshot below.

I enter my credentials, and click continue in the lower right and the next thing I see (immediately) is the message given above.

[bwaynef]

Was your 1.1.11 install running correctly before you started?  Sounds like upgrade.php is getting to Step 4: Database Changes, correct?

My install was running correctly.  I have no idea what step its getting to.

[Illori]

can you post a screenshot of the page that shows the error message?

[bwaynef]

Yeah, but you might be disappointed.

[Illori]

it seems that after you have logged into upgrade.php it is forwarding you to your forum and not keeping you in the upgrade.php script.

i wonder if there are any errors in your server error log related to what is going on.

[bwaynef]

i wonder if there are any errors in your server error log related to what is going on.

Without being able to get to the admin section any longer, do you have any suggestions as to where to look?  Cpanel?

[Illori]

your server error log is not in SMF. it is usually in a file with a name similar to error_log in the main SMF folder.

[bwaynef]

I thought it was accessible in the admin panel of SMF.  Alas, here are the logs from today (apparently my timestamp's off):

[04-Feb-2016 18:38:34 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:38:59 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:38:59 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:39:04 UTC] PHP Warning:  Unterminated comment starting line 17 in /home/intouch/public_html/bonsaistudygroup/Sources/Security.php on line 17
[04-Feb-2016 18:39:04 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:39:09 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:39:13 UTC] PHP Fatal error:  Call to undefined function loadDatabase() in /home/intouch/public_html/bonsaistudygroup/index.php on line 69
[04-Feb-2016 18:39:18 UTC] PHP Fatal error:  Call to undefined function call_integration_hook() in /home/intouch/public_html/bonsaistudygroup/Sources/Load.php on line 330

[Illori]

are you sure all the files in the Sources folder got uploaded correctly? can you try uploading them again and running the upgrade script again?

[bwaynef]

Any chance you know how many there are supposed to be?  I'm about to upload 108.

[Illori]

i said if they got uploaded correctly, not if all of them got uploaded. it is possible that they may have gotten corrupted when they got uploaded.

[bwaynef]

I ask, because the upgrade package on my desktop has 108 files in the Sources directory.  My forum has 166 files in the Sources directory. 

Filezilla says 108 were successfully transferred.


**Edit** Looks like a freshly downloaded upgrade package has 108 files in the Sources directory.

[bwaynef]

...and I took it upon myself to try the upgrade.php again and there's no change.

[Sir Osis of Liver]

Have you uploaded a fresh set of upgrade files?

[bwaynef]

Yes. 

Filezilla says 108 were successfully transferred.

**Edit** Looks like a freshly downloaded upgrade package has 108 files in the Sources directory.

...and I took it upon myself to try the upgrade.php again and there's no change.

[Sir Osis of Liver]

Where is upload.php?  Am unable to link to it at your domain.

[bwaynef]

To clarify, I performed a second upload of the 108 files in Sources/ to my current smf install.  (I was re-reading and if you didn't read it the way I intended, it read a little sarcastic.  I'm gifted with loads of sarcasm, ...but I'm trying to get help right now so I'm toning that down as low as I can for the time being.)

I then went to url/upgrade.php ...and saw no change in behavior.  I was presented with the same message.

[Sir Osis of Liver]

Do what it suggests at the bottom, try disabling security check in upgrade.php.

[br360]

Do you have cpanel or plesk? I'm wondering if it would be better to just restore from your backup, then instead of using FTP, upload the large upgrade zip to your cpanel's file manager. Then you can just extract that to better ensure all the correct files are there.

[Sir Osis of Liver]

It's behaving as if UpgradeOptions() is failing, causing the script to halt and redirecting to forum, as Illori suggested.  That will cause a database error because a 2.0 install is trying to load a 1.1.x database.

[Kindred]

I recommend this...

DELETE all files and subdirectories in Sources and Themes.

then upload the upgrade files one more time.
I am hoping/betting that one or more files is actually NOT getting overwritten in your upload - regardless of what FTP reports.

[bwaynef]

I changed the $disable_security setting to 1, uploaded it, refreshed the page, (noticed that the login was disabled) and clicked continue.  I got the same end result.  (I'll change that back now.)

Hopefully that provides meaning to you guys.  I'm about to be off work, but likely will work on this later tonight. 

It sounds like deletes and re-uploads ...or cpanel uploads are in my future.  I really appreciate your help in this.

[Sir Osis of Liver]

Hmm, don't think it's getting to UpgradeOptions().  Login failure has same result, with this error - Unknown column 'add_deny' in 'field list'.

[bwaynef]

I'm saving those directories (Sources & Themes)  on my laptop (since my backup's at the office) and will delete them once I have a backup I can work with right now.  Then I'll upload those directories and we'll try this again.

[bwaynef]

So, I deleted all those directories/files and uploaded them again, from a new computer (and new download of the upgrade package).  Same result.

[Illori]

Do you have cpanel or plesk? ...then instead of using FTP, upload the large upgrade zip to your cpanel's file manager. Then you can just extract that to better ensure all the correct files are there.

can you try that?

[bwaynef]

Do you have cpanel or plesk? ...then instead of using FTP, upload the large upgrade zip to your cpanel's file manager. Then you can just extract that to better ensure all the correct files are there.

can you try that?

I uploaded the gunzip'd tar file for the large upgrade pkg to a directory on my server using my CPanel file manager, extracted, then copied the resulting Sources/ and Themes/ directories back to the root of my smf installation. 

Nothing doing.

[margarett]

At this point this is one of those "have to see" cases. If you're comfortable with the idea, PM me your cPanel login details and I'll check it in place.

[Sir Osis of Liver]

Just passing through (on way to shoveling snow ), but problem seems to be that upgrade.php login is failing.  If you click Continue with blank username/password fields, or enter invalid values, it should just reload login page, but it's crashing instead.

[bwaynef]

Just passing through (on way to shoveling snow ), but problem seems to be that upgrade.php login is failing.  If you click Continue with blank username/password fields, or enter invalid values, it should just reload login page, but it's crashing instead.

Earlier, the disable security variable was set to 1 and the upgrade.php page was refreshed and it bypassed a login.  The same behavior was experienced.

[bwaynef]

At this point this is one of those "have to see" cases. If you're comfortable with the idea, PM me your cPanel login details and I'll check it in place.

PM sent.

[bwaynef]

While you're thinking, am I right to believe that if I restore the files from my backup, I'll be back up and working?

[margarett]

Yes
But if you do, I can't debug it for you Give me a couple hours, I'm going dinner.

[bwaynef]

I'm not backing things off just yet, but just making sure thats all there would be to "fixing" it.

[margarett]

Spent a good amount of time looking at this..
I'm now downloading your content and will run the upgrade in my localhost.
At this point my money is on mod_security. The upgrade sends a reasonable amount of data (between steps) in the URL and I'm betting it triggers some darned rule of the beast

edit: bingo!
Turns out your cPanel allows to disable mod_security for each domain, so I did it for this specific domain and BANG! the upgrade immediately works

[margarett]

OK so your forum is now upgraded. You should now delete the excessive Themes which aren't available anymore, then you can proceed to install a new theme and your MODs.

Good luck

[bwaynef]

Thanks for your help.  I've been doing some reading so I can get things set up again the way I had it and forgot to come put a bow on this thread.  I turned mod_security back on for this domain and it seems to still work ...so I guess it was just balking at the upgrade part.  (Maybe something to watch out for in upgrades in the future.)

[Kindred]

just FYI -- mod_security, in general, causes more issues than it claims to solve (and is, in general, not necesarry because SMF protects its own input)

We have numerous other complaints of various problems caused by mod_security (mostly because whoever configured it has been overly protective and essentially mis-configured it to exclude even clean data)