Advertisement:

Author Topic: Late to the party - upgrading from 1.1.21 to 2.X  (Read 1114 times)

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Late to the party - upgrading from 1.1.21 to 2.X
« on: November 15, 2019, 08:34:04 AM »
Good day to all!

I have a bit of a problem...

Site is hosted on Godaddy.  SMF was at 1.1.19

About 6 months ago plan was upgraded so the php files were moved to a new server running 5.6. Databases were not migrated, they stayed on old server.  Forum running for a while fine.
Then a few weeks ago ran into the code was depreciated error.

Downloaded and tried to run the upgrade to 2.0.15. It was not pretty.

So, I d/l a backup of 1.1.19 and DBs to a music server I have here.  Have it running fine.  Patched it to 1.1.21.  Uploaded it to godaddy server.  Get the depreciated error (expected it).  Went to do the upgrade to 2.0.15 - WHITE SCREEN OF DEATH.  Backed it off to .19.  Tried upgrade again.  During it's minimal check, not all need files there, so upgrade does not even start.


So, I'm at the point of I'm ready to do a fresh install.

I'd like to keep the topics and sub topics defined, registered users, and posts.

I'm sure it is possible, it's just how much TIME do I want to put into it.

Thoughts / comments please.

Looked at it this morning and there is a connection issue to the DB I need to fix.

TIA,
Radnor302

Offline oridyne

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • @@BBBBForum on Twitter
    • Big Bang Burger Bar
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #1 on: November 15, 2019, 11:09:04 AM »
In the test upgrades I have been doing for my site (V 1.1.21) it has been necessary to upgrade to 2.0.13 first then upgrade again to 2.0.15.This seems to avoid a lot of errors, I'm guessing the earlier 2.0.x upgrades were more geared towards the previous branch as well as supporting older php versions etc.

<*> I'm dangerous when I know what I'm doing <*>

Big Bang Burger Bar

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #2 on: November 15, 2019, 11:18:44 AM »
I'm willing to try 2.0.13.  Is it still available to d/l?  All I see is .15.

Speaking of .15, I made a subdomain on my site and installed .15 w/o problems (made a new DB).  Then used myphpadmin to look at the structure side by side.  See some cols renamed and few new ones.

Would love to have the UPGRADE perform the DB conversions for me taking the db from 1.1.121 to 2.0.X.

Radnor

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,495
  • Gender: Male
    • i30 Owners Club

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 52,483
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #4 on: November 15, 2019, 11:29:33 AM »

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #5 on: November 15, 2019, 11:58:27 AM »
GoDaddy. :P

You should be able to upgrade 1.1.19/.21 -> 2.0.15 directly, don't think going to .13 will make any difference.  Did you check to see if all files are actually there?  Some GD servers were blocking up to a dozen /Sources files, although haven't seen that recently.  Upgrader may also report missing language files if it's not happy with php config.  Some GD servers will just not run the upgrade, I've done several where we had to export db, import to my server, run upgrade, import upgraded db back to GD server.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #6 on: November 15, 2019, 01:02:59 PM »
GoDaddy. :P

You should be able to upgrade 1.1.19/.21 -> 2.0.15 directly, don't think going to .13 will make any difference.  Did you check to see if all files are actually there?  Some GD servers were blocking up to a dozen /Sources files, although haven't seen that recently.  Upgrader may also report missing language files if it's not happy with php config.  Some GD servers will just not run the upgrade, I've done several where we had to export db, import to my server, run upgrade, import upgraded db back to GD server.

I've been messing around with this for a few weeks trying all kind of different things....  Earlier this week I went to do an update and the update does a quick check.  When it did it came back saying some files were missing.

I have a new install running in a subdomain.  Is there any way to run the DB converter to upgrade the DB from 1.1.21 to 2.0.15?  I think thats the point I'm at now.

As far as upgrading...  I've done both d/l .15 and unzip on local machine and ftp files to server and d/l .15 local, upload, and unzip @ server.  No joy for either.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,654
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #7 on: November 15, 2019, 02:31:10 PM »
Godaddy might be deleting some files via ftp on upload mainly files in Sources folder. You might have to upload though the online interface for file manager.
There are the files i commonly see removed from sources folder
Code: [Select]
Post.php
PersonalMessage.php
Subs-Auth.php
ModerationCenter.ph
Subs-Post.php
LogInOut.php
Subs-Editor.php
Register.php
Reminder.php

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Bob Perry of Web Presence Consulting

  • Sophist Member
  • *****
  • Posts: 1,024
  • Gender: Male
  • (T)ogether (E)veryone (A)chieves (M)ore
    • Bobert921 on Facebook
    • https://www.linkedin.com/in/bperry921/ on LinkedIn
    • @bperry921 on Twitter
    • Web Presence Consulting
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #8 on: November 15, 2019, 07:44:28 PM »
I ran into same problem because PHP 5.6 is no longer supported, had to go to 7.1 and still had some glitches, but the guy I have as the hosting support knows his stuff and smooth as silk now... I make two recommendations, get the hell away from godaddy, and check in your phpMyAdmin utilities and be sure the coallation sequence is the same for all tables, I recommend using utf8-general-ci
Best Regards,
Bob Perry



"The world is moving so fast these days that the man who says it can't be done is generally interrupted by someone doing it." Elbert Hubbard

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #9 on: November 15, 2019, 08:50:51 PM »
Upgrader usually works better in php 5.6 when upgrading from 1.1 to 2.0, doesn't like 7.x.

Offline Bob Perry of Web Presence Consulting

  • Sophist Member
  • *****
  • Posts: 1,024
  • Gender: Male
  • (T)ogether (E)veryone (A)chieves (M)ore
    • Bobert921 on Facebook
    • https://www.linkedin.com/in/bperry921/ on LinkedIn
    • @bperry921 on Twitter
    • Web Presence Consulting
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #10 on: November 15, 2019, 11:35:19 PM »
Upgrader usually works better in php 5.6 when upgrading from 1.1 to 2.0, doesn't like 7.x.

Yes, very good point... went back and reread OP and what's throwing me for a loop is that he says the old database did not migrate... dude, do you still have access to the old database?
Best Regards,
Bob Perry



"The world is moving so fast these days that the man who says it can't be done is generally interrupted by someone doing it." Elbert Hubbard

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #11 on: November 15, 2019, 11:50:50 PM »
About 6 months ago plan was upgraded so the php files were moved to a new server running 5.6. Databases were not migrated, they stayed on old server.

Most of the older GD accounts did not store databases on localhost, they were on third party servers (starbrite?).  That appears to be the case here, they only migrated forum files, not the database, and the forum is running, just won't upgrade.  Sometimes upgrade will work if run in different php version (usually lower, i.e., 5.4) depending on what's available, but sometimes it won't run at all and upgrade has to be done elsewhere.  Don't know the cause, but suspect it's something in php config.


Offline Bob Perry of Web Presence Consulting

  • Sophist Member
  • *****
  • Posts: 1,024
  • Gender: Male
  • (T)ogether (E)veryone (A)chieves (M)ore
    • Bobert921 on Facebook
    • https://www.linkedin.com/in/bperry921/ on LinkedIn
    • @bperry921 on Twitter
    • Web Presence Consulting
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #12 on: November 15, 2019, 11:59:15 PM »
Most of the older GD accounts did not store databases on localhost, they were on third party servers (starbrite?).  That appears to be the case here, they only migrated forum files, not the database, and the forum is running, just won't upgrade.  Sometimes upgrade will work if run in different php version (usually lower, i.e., 5.4) depending on what's available, but sometimes it won't run at all and upgrade has to be done elsewhere.  Don't know the cause, but suspect it's something in php config.

Yes, I'm glad I got outta dodge with them and hostgator as well many moons ago, nothing but headaches and poor support...
Best Regards,
Bob Perry



"The world is moving so fast these days that the man who says it can't be done is generally interrupted by someone doing it." Elbert Hubbard

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #13 on: November 17, 2019, 08:00:04 AM »
OK, where I'm at now...

On HOME computer, installed apache, mysql, php5.6.  It's running.
loaded DB and copied my 1.1.21 s/w.  Get the depreciated error message like on GD host.
D/L the 2.0.15 large upgrade & unzipped it in home dir.

Ran http://127.0.0.1/upgrade.php [nofollow] and get ...

 The upgrader was unable to find some crucial files.

Please make sure you uploaded all of the files included in the package, including the Themes, Sources, and other directories.


AT this point, I'm stuck!  Tried the upgrader on GD host too, same message.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 72,663
    • StoryBB/StoryBB on GitHub
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #14 on: November 17, 2019, 08:07:14 AM »
When you run it on your machine, with the existing database, it's going to get confused because it thinks it should be looking in the same paths as the original site (thus it can't find files) - you will need to use repair-settings to fix the settings on your machine so you can run the upgrader.

What is repair_settings.php?
Please don’t PM me for paid work, I’m not for hire, and even if I was, I doubt you could afford me.
USD$150 per hour. Typical waiting list 3 months.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #15 on: November 17, 2019, 08:21:12 AM »
I ran it before upgrade attempt.

Also, I see where I messed up big time!!!  I unzipped the pkg and COPIED to my home dir instead of running from folder it created.

So, I unzipped my copy of .21.  Have depreciated message. Then ran upgrade from it's folder.  Looking at white screen.  PHP is 5.6

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #16 on: November 17, 2019, 01:20:41 PM »
Reread upgrade info....  Copied files to home folder.  Ran repair_settings.  This time it had a lot more items listed that I have ever seen before.
Took all of the recommended values.  Saved file.  Reran upgrade.  Made some progress....

Executing: "Updating holidays and calendar..." (5 of 19 - of this script)

Updating indexes on "messages"...done
Updating table indexes...done
Reordering boards and categories...done
Updating indexes and data on "smileys"...done
Updating indexes on "log_boards"...done
Updating indexes on "log_mark_read"...done
Updating indexes on "themes"...done
Updating data in "settings"...done
Adding new settings...done
Adding PM spam protection settings...done
Cleaning old values from "settings"...done
Encoding SMTP password...done
Adjusting timezone settings...done
Installing theme settings...done
Renaming personal message tables...done
Updating indexes on "pm_recipients"...done
Updating columns on "pm_recipients"...done
Updating columns on "members"...done
Updating columns on "members" - part 2...done
Updating member approval...done
Adding new holidays...done
Updating event start and end dates...done
!!
Error!
Incorrect date value: '0000-00-00' for column 'eventDate' at row 1

clicked continue, but seems to be going nowhere.  Going to let it sit for a bit - range time.

Offline oridyne

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • @@BBBBForum on Twitter
    • Big Bang Burger Bar
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #17 on: November 17, 2019, 07:09:42 PM »
With all due respect to the team here I hit upgrade errors every time I tried leaping straight from 1.1.21 to 2.0.15 on my offline test site, going back and using version 2.0.13 enabled a clean upgrade that further enabled a 2nd clean upgrade to 2.0.15.
Now whether  this is a fluke or something that the older upgrade does the newer one does not based on assumptions I cannot say. But for the sake of a bit of extra time and the saving of my sanity this was a worthwhile process. I have yet to take the plunge live but there I wanted to ensure I went through the whole process, including finding updates/replacements for all of the mods I have been using on the old version.
<*> I'm dangerous when I know what I'm doing <*>

Big Bang Burger Bar

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #18 on: November 17, 2019, 09:54:58 PM »
IIRC, did an upgrade at least once on a *very old* database, got to 1.1.21, would not go to 2.0.15.  Tried 1.1.21 -> 2.0, that worked, then 2.0 -> 2.0.15.  Sometimes you just have to play with it until it works.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #19 on: November 18, 2019, 11:10:54 AM »
This morning on GD servers.  Restored 1.1.21.  Made sure setting ok.  Get my depreciated error (expected).  D/L 2.0 upgrade.  Ran it.
Received a warning telling me to go to 2.0.15 instead.  Received a CRITICAL ERROR "The upgrade script cannot find script.js or it is out of date.
Make sure your theme paths are correct. You can download a setting checker tool from the Simple Machines Website"

It completed the 1st table.  Then received this error...

"
!!
Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again"

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 52,483
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #20 on: November 18, 2019, 11:15:12 AM »
that will be a very common error on godaddy. you will need to be very patient for the upgrade to complete.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #21 on: November 18, 2019, 11:42:00 AM »
Well an update...  on my server at work had 1.1.21 running.  Upgraded to 2.0 WITHOUT any problems.
Was going to upgrade to .15 but PHP is OLD! Server is just used for music.

So, what I'm going to do is backup the DB and zip home folder. Move them to GD and check settings and try it there.

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #22 on: November 18, 2019, 11:42:56 AM »
Sometimes upgrade will work if run in different php version (usually lower, i.e., 5.4) depending on what's available, but sometimes it won't run at all and upgrade has to be done elsewhere.

How large is the db?  Have you cleared _log_errors?

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #23 on: November 18, 2019, 11:44:13 AM »
If you have the upgraded db, do a clean 2.0.15 install and import it to the new install.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #24 on: November 18, 2019, 12:15:28 PM »
Sometimes upgrade will work if run in different php version (usually lower, i.e., 5.4) depending on what's available, but sometimes it won't run at all and upgrade has to be done elsewhere.

How large is the db?  Have you cleared _log_errors?

Well, is there in 2.0 MAJOR compression going on???
The 1.1.21 backup files are (DATABASES) are 13m & 5.1g
For 2.0 backups are 9.3m & 27.6m

Then I log into my LOCAL server at the bottom it says 39k posts in 5k topics.  Looked at some of the posts and they are there works GREAT!!!

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,242
  • Hoarding Budweiser in NY
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #25 on: November 18, 2019, 12:23:23 PM »
Db dumps are compressed only if you select to zip them.  If you've upgraded the db successfully on local server, you're basically done.  Just import it to a clean 2.0.15 install on your production server.  upgrade.php doesn't do anything to the files, it just upgrades the db to 2.0.15.  Doesn't matter where you upgrade it, as long as it completes successfully.

Offline Antechinus

  • SMF Friend
  • SMF Master
  • *
  • Posts: 25,303
  • Master of BBC Abuse
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #26 on: November 18, 2019, 12:47:19 PM »
Sometimes upgrade will work if run in different php version (usually lower, i.e., 5.4) depending on what's available, but sometimes it won't run at all and upgrade has to be done elsewhere.

How large is the db?  Have you cleared _log_errors?

Well, is there in 2.0 MAJOR compression going on???
The 1.1.21 backup files are (DATABASES) are 13m & 5.1g
For 2.0 backups are 9.3m & 27.6m

Then I log into my LOCAL server at the bottom it says 39k posts in 5k topics.  Looked at some of the posts and they are there works GREAT!!!

5.1 gig for 39k posts? That sounds weird, unless you have a humungous error log. You do know it's a good idea to clear the error log before upgrading a db? Not that it's essential, but it is good practice. You can also get rid of any search index, and rebuild it after the upgrade.

The other sizes sounds about right.
« Last Edit: November 18, 2019, 01:23:37 PM by Antechinus »

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #27 on: November 18, 2019, 01:16:39 PM »
WOW!!!!  I've moved over 2.0 to a sub domain on GD.  It's working there.  Messages, posts - everything there. 
Now going to zip it for safe keeping.  Then move to public side of the house.


THANK YOU all for the help!

Next up is upgrade to .15. in a while.  Worked too much on this.
Taking a vacation from it for a week or so.

Thank you all again!!!

Offline Antechinus

  • SMF Friend
  • SMF Master
  • *
  • Posts: 25,303
  • Master of BBC Abuse
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #28 on: November 18, 2019, 01:24:50 PM »
If your site is only 39k posts you could upgrade to 2.0.15 in about half an hour at most. It's much simpler than changing from 1.1.x to 2.0.x.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #29 on: November 18, 2019, 01:44:47 PM »
Thank you, but I think I'm putting it down for a little while.  I've put a lot of time on it tring to get it back working on 3 different servers.
My brain hurts....  PHP5.6 ok for .15?

Only thing I have now is a pink banner themes dir is wrong.  That "should" be easy compared to what I've been through.

Offline Antechinus

  • SMF Friend
  • SMF Master
  • *
  • Posts: 25,303
  • Master of BBC Abuse
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #30 on: November 18, 2019, 01:49:37 PM »
That is probably because you have moved the db. Go here: https://download.simplemachines.org/index.php?tools
Grab repair_settings.php. Easy to run. Will not frazzle brain. :)

5.6 should be ok.

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #31 on: November 18, 2019, 04:49:21 PM »
OK to make the jump from 2.0 to .15 in 1 step?

PHP version?  On 5.6 7.x available
« Last Edit: November 18, 2019, 05:32:58 PM by radnor302 »

Offline Dzonny

  • Localizer
  • SMF Super Hero
  • *
  • Posts: 12,159
  • Gender: Male
  • No sleep...
    • dzontra.nikola on Facebook
    • Dzonny on GitHub
    • dzontranikola on LinkedIn
    • @opusteniforum on Twitter
    • Samo opusteno
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #32 on: November 18, 2019, 06:22:41 PM »
You ran a large upgrade on 2.0 or you tried to update it with patches? 2.0.1, 2.0.2 and so on?

The error you're getting now can be caused by server being busy, so it might help to just try again?

Offline radnor302

  • Semi-Newbie
  • *
  • Posts: 18
Re: Late to the party - upgrading from 1.1.21 to 2.X
« Reply #33 on: November 19, 2019, 01:49:00 PM »
Just an update....

I copied 2.0 to a subdomain.  Copied the DB w/ new name so I could patch w/o messing up live system

D/L patch 1-5 installed on test forum.  Then installed on live
D/L patch 6-10 repeat as above
D/L patch 11-15 repeat.


So, now I'm CURRENT!

I tried the large upgrade to jump from 2.0 to 2.0.15 initially but when I ran upgrade it complained about missing files.
Patching was slower, but I am FINALLY there!

Thanks to all who helped!