Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Topic started by: MarkArka on October 11, 2016, 07:45:59 PM

Title: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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



Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred on October 11, 2016, 07:49:22 PM
Make all the files chmod 664 and the directories 775
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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)
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred on October 11, 2016, 09:04:50 PM
The full root path...like /home/username/public_html/
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 12, 2016, 05:42:35 AM
could it be that the forum is hosted on a parked domain?    forum.mysite.com
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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;

Quote550 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

$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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred on October 12, 2016, 03:44:15 PM
http://wiki.simplemachines.org/smf/Repair_settings.php
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Illori on October 12, 2016, 04:05:49 PM
try it now, if it does not work put the old files back and try again.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Shambles on October 13, 2016, 08:26:07 AM
Do you have the file Security.php in your Sources folder?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 08:47:46 AM
yes
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Shambles on October 13, 2016, 09:25:02 AM
Do you have the following line in your index.php file?

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';
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 09:34:22 AM
Hi,

Thanks

Yes I have
require_once($sourcedir . '/Security.php');
in my index.php file

I checked the Settings.php file and it has this

########## 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred on October 13, 2016, 02:28:24 PM
the save button won't appear if the Settings.php file is not writable...
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 03:21:10 PM
Settings.php is writable. See screenshot
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 03:28:30 PM
screenshot of repair_settings errors
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Shambles 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

Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 03:42:36 PM
results in white screen with

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

in top left corner
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 03:44:02 PM
which is the same as I get when I browse to the forum folder
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 03:44:47 PM
I appreciate you guys sticking with this.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 13, 2016, 05:39:02 PM
so whats my next step?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Illori 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred 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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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  :(
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred on October 14, 2016, 10:07:32 AM
when you rolled back, did you reload both the FILES and the DATABASE?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka on October 14, 2016, 10:12:08 AM
no just the files. Have I cocked up?
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Kindred 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
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Illori 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: Illori 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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.

QuoteSimply 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;

QuoteThe 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?


Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: d3vcho 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 :)
Title: Re: Problems upgrading from 1.1.21 to 2.0.12
Post by: MarkArka 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