Advertisement:

Author Topic: Problems upgrading from 1.1.21 to 2.0.12  (Read 6575 times)

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Problems upgrading from 1.1.21 to 2.0.12
« on: October 11, 2016, 07:45:59 PM »
Hi SMF people!

I am having problems upgrading.

I am trying to upgrade a SMF 1.1.21 to 2.0.12 prior to a server upgrade which will break 1.1.21 due to php upgrade.

The forum was originally installed in its own folder, but recently was moved into the root directory (public_html) by someone else.
It was working ok in the root directory however, which is now a parked subdomain.

I have followed instructions.
I downloaded the large upgrade. smf_2-0-12_upgrade.zip
I backed up the database and files.
I extracted the files and uploaded them to the server overwriting the previous files.
I then attempted to run the upgrader

The upgrader screen looks like the first attached gif screenshot upgrade_php01.gif
'Try again' doesnt help.. but 'Try English' presents a more promising screen see attached screenshot upgrade_php02.gif
However, nothing I try in these boxes works for me.

I have the correct ftp username and password, but whatever I try for the install path fails with a message;
"550 Can't change directory to home/public_html: No such file or directory " or similar depending on what I try.
I've tried leaving blank, and every variation I can think of  /,  /public_html,  public_html/  home/jo******ch/public_html/ etc etc

The upgrade file along with the index and settings files etc are all loose in the public_html directory (see attached screenshot)
and you can see the other folders are there.

I've tried everything I can think of and I'm stuck.
Any help will be greatly appreciated.


(By the way, accessing the forum (forum.mysite.html)  in a browser now just shows the following message;

Unknown column 'a.attachment_type' in 'field list'

but that may just be because I'm half way through the upgrade.)

Cheers,
Mark




Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #1 on: October 11, 2016, 07:49:22 PM »
Make all the files chmod 664 and the directories 775
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #2 on: October 11, 2016, 07:57:59 PM »
thanks for the reply.
I have done that.
See attached screenshot.
However I am still unable to get the upgrade utility to work.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #3 on: October 11, 2016, 08:00:06 PM »
what install path should I try if the files are in the root directory (see screenshot above file directory.gif)

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #4 on: October 11, 2016, 09:04:50 PM »
The full root path...like /home/username/public_html/
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #5 on: October 12, 2016, 05:26:44 AM »
When I try that I get the following error


The following error was encountered when trying to connect:

550 Can't change directory to /home/jo******ch/public_html: No such file or directory

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #6 on: October 12, 2016, 05:42:35 AM »
could it be that the forum is hosted on a parked domain?    forum.mysite.com

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #7 on: October 12, 2016, 06:37:48 AM »
path is different from url....

you would need to find out the actual path of your forum.

However... it sounds like you actually replaced the Settings.php from your old site, since that information should already be present if the old site was working.
Get the Settings.php from your backup and put it back in the forum directory, then try running upgrade.php again.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #8 on: October 12, 2016, 01:15:34 PM »
Hi,

>>>However... it sounds like you actually replaced the Settings.php from your old site,

No, I didnt, there wasnt a Settings.php file in the upgrade zip. So it didnt get replaced.

>>>Get the Settings.php from your backup and put it back in the forum directory, then try running upgrade.php again.

I did that anyway, but got the same error message;

Quote
550 Can't change directory to /home/jo******ch/public_html: No such file or directory

>>>path is different from url....you would need to find out the actual path of your forum.

The path is coded in the Settings.php file like this
Code: [Select]
$boarddir = '/home/jo*****ch/public_html'; # The absolute path to the forum's folder. (not just '.'!)
and  I am using
/home/jo*****ch/public_html
in the 'install path' box

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #9 on: October 12, 2016, 01:52:47 PM »
Does the screenshot above;
 upgrade_php01.gif
offer any clues.?
this is what I see when I first run upgrade.php

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #10 on: October 12, 2016, 02:00:25 PM »
basically, it is telling you that the path which you are using is NOT the path that the system is set to use...

I suspect that when you moved the old forum, you did not properly set all of the server settings and theme settings.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #11 on: October 12, 2016, 02:09:37 PM »
I didnt move the old forum.

This was done by someone who rebuilt the persons website, and is no longer in contact.

I believe all they did was move the forum files out of the folder they were in and put them in the public_html folder.

The theme settings were changed to point too the new location, but I dont know if any server settings were changed.

Are you able to advise the best course for trying to sort this out?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #13 on: October 12, 2016, 03:46:38 PM »
thanks should I roll back before attempting this?
Like, should I replace all the files with the pre upgrade attempt versions?

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,983
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #14 on: October 12, 2016, 04:05:49 PM »
try it now, if it does not work put the old files back and try again.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #15 on: October 13, 2016, 08:00:24 AM »
Hi,

Thanks for your continued help.

I tried using the repair_settings tool.

Paths and Urls

Cache Directory : Value not found
However the recommended value was where the cache folder currently is. So I chose that.

However

under Attachment Directory the path path points to the folder I believe the forum used to be located and underneath is the message;

Quote
   
Notice: Undefined index: database_error in /home/jo******h/public_html/Sources/Subs-Db-mysql.php on line 594

Fatal error: Call to undefined function allowedTo() in /home/jo******h/public_html/Sources/Subs-Db-mysql.php on line 595

and there are no 'restore' or 'save settings' buttons available.

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,293
  • Gender: Male
    • i30 Owners Club
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #16 on: October 13, 2016, 08:26:07 AM »
Do you have the file Security.php in your Sources folder?

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #17 on: October 13, 2016, 08:47:46 AM »
yes

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,293
  • Gender: Male
    • i30 Owners Club
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #18 on: October 13, 2016, 09:25:02 AM »
Do you have the following line in your index.php file?

Code: [Select]
require_once($sourcedir . '/Security.php');

If you do, it suggests there's a problem within your Settings.php file.

Check the following lines look ok:

Code: (Settings.php) [Select]
########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = 'xxxxxx'; # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = 'xxxxxx';

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #19 on: October 13, 2016, 09:34:22 AM »
Hi,

Thanks

Yes I have
Code: [Select]
require_once($sourcedir . '/Security.php');in my index.php file

I checked the Settings.php file and it has this

Code: [Select]
########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/jo******h/public_html'; # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/jo****h/public_html/Sources'; # Path to the Sources directory.

amd those are the correct paths.
« Last Edit: October 13, 2016, 10:27:08 AM by MarkArka »

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #20 on: October 13, 2016, 02:28:24 PM »
the save button won't appear if the Settings.php file is not writable...
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #21 on: October 13, 2016, 03:21:10 PM »
Settings.php is writable. See screenshot

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #22 on: October 13, 2016, 03:28:30 PM »
screenshot of repair_settings errors

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,293
  • Gender: Male
    • i30 Owners Club
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #23 on: October 13, 2016, 03:39:32 PM »
Humour me here...

Try calling the upgrade.php file again, appending "?ssi" to the url, so that it looks like upgrade.php?ssi


Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #24 on: October 13, 2016, 03:42:36 PM »
results in white screen with

Quote
Unknown column 'a.attachment_type' in 'field list'

in top left corner

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #25 on: October 13, 2016, 03:44:02 PM »
which is the same as I get when I browse to the forum folder

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #26 on: October 13, 2016, 03:44:47 PM »
I appreciate you guys sticking with this.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #27 on: October 13, 2016, 05:39:02 PM »
so whats my next step?

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #28 on: October 14, 2016, 06:34:04 AM »
If I have exhausted the support this forum can offer.. can anyone suggest my next step?

The server will be upgraded to php7 in 5 days and if I dont have the forum upgraded by then I think the job will be even harder.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,983
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #29 on: October 14, 2016, 06:48:32 AM »
At this time SMF does not support php 7. It will not work correctly on that version.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #30 on: October 14, 2016, 06:59:12 AM »
ok thanks, but I can ask for a lesser upgrade.. whatever it will be it will be more than  5.5 so I need to upgrade.

thats not really the issue.. the issue is upgrading to v2

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #31 on: October 14, 2016, 08:37:05 AM »
I think your issue is related to the directories and themes...   unfortunately, I think the only way to fix it (if it is the issue that some others have described in the past) is to go into the database and manually fix some rows.

Unfortunately (again), I am not the one who fixed it on other sites...  so I am unsure specifically what needs to be fixed, but IIRC, there was something that went wrong when the default theme directory got moved/changed/deleted that basically causes everything to crap out
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #32 on: October 14, 2016, 08:40:54 AM »
well thanks for the reply anyway. sounds like a mountain too big for me.

I rolled back to the previous version and even that is not working now.

I'm banging my head against a wall here and the wall is winning  :(

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #33 on: October 14, 2016, 10:07:32 AM »
when you rolled back, did you reload both the FILES and the DATABASE?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #34 on: October 14, 2016, 10:12:08 AM »
no just the files. Have I cocked up?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,767
  • Gender: Male
    • Kindred-999 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #35 on: October 14, 2016, 10:28:10 AM »
yes...   that is why you can't restore. you need to restore both the backed up database and the files...
it sounds like the upgrade process at least touched the database...

If you don't have a backup yourself, ask your host to restore the full site backup from the day before you started the attempt
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,983
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #36 on: October 14, 2016, 10:29:04 AM »
if you checked the option for the upgrade to do a backup, you may have some backup tables in the databse you can use.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #37 on: October 14, 2016, 11:03:15 AM »
ok thanks Kindred.
I have now restored an old backup and I am back to square 1
I have a working    SMF 1.1.21 forum.

Should I run the repair_settings file on this to see how it looks.
As I said beofre someone else moved the forum into the root directory so it may not be set up right even though it looks ok.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,983
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #38 on: October 14, 2016, 11:27:10 AM »
it cant hurt to run it. then you could make a backup of your files and database load in a new location, fix your paths with repair_settings.php and see how the upgrade goes without effecting your live forum.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #39 on: October 14, 2016, 01:26:21 PM »
I ran the repair tool and there were a few paths that it found that were incorrect.
It corrected them all ok and updated settings.php and I now have a fully working SMF V 1.1.21
So now... deep breath.. I am going to go for the upgrade again.

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #40 on: October 14, 2016, 03:19:21 PM »
Hi Guys,

Rolled back to a perfectly working V1.1.21.
ran repair tool.. all good.

Backed up home dir and database.

Uploaded smf_2-0-12_upgrade files to home dir.

Ran upgrade.php

Looks good

However. Stuck on step1 : login

I enter the server, username, password and path correctly but I get the message;
Quote
550 Can't change directory to /home/jo*******h/public_html: No such file or directory

all permissions on files and folders are as advised.

Quote
Simply enter your connection information below or alternatively click here for a list of files which need to be changed.

If I click that I get the message;

Quote
The following files needs to be made writable to continue:

/home/jo******ch/public_html/Settings_bak.php

However there is no Settings_bak.php file in the homedir?



Offline d3vcho();

  • Sempiterno
  • Lead Localizer
  • SMF Hero
  • *
  • Posts: 4,119
  • Gender: Male
    • frandominguez03 on GitHub
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #41 on: October 14, 2016, 03:32:12 PM »
Hello!

Settings_bak.php is a backup of Settings.php, so you can just create a copy of Settings.php and rename it as Settings_bak.php; then, give it the same chmod as other files. That should solve the problem.

Regards :)

"Greeting Death as an old friend, they departed this life as equals."

Offline MarkArka

  • Semi-Newbie
  • *
  • Posts: 50
Re: Problems upgrading from 1.1.21 to 2.0.12
« Reply #42 on: October 14, 2016, 04:14:06 PM »
SUCCESS!!!!

thanks d3vcho, Kindred and Illori for all the help.

I got there in the end..  :D

Fully working    SMF 2.0.12 yippeeeeee