Problems upgrading from 1.1.21 to 2.0.12

[MarkArka]

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

[Kindred]

Make all the files chmod 664 and the directories 775

[MarkArka]

thanks for the reply.
I have done that.
See attached screenshot.
However I am still unable to get the upgrade utility to work.

[MarkArka]

what install path should I try if the files are in the root directory (see screenshot above file directory.gif)

[Kindred]

The full root path...like /home/username/public_html/

[MarkArka]

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

[MarkArka]

could it be that the forum is hosted on a parked domain?    forum.mysite.com

[Kindred]

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.

[MarkArka]

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;

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 Expand


$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

[MarkArka]

Does the screenshot above;
upgrade_php01.gif
offer any clues.?
this is what I see when I first run upgrade.php

[Kindred]

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.

[MarkArka]

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?

[Kindred]

http://wiki.simplemachines.org/smf/Repair_settings.php

[MarkArka]

thanks should I roll back before attempting this?
Like, should I replace all the files with the pre upgrade attempt versions?

[Illori]

try it now, if it does not work put the old files back and try again.

[MarkArka]

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;

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.

[Shambles]

Do you have the file Security.php in your Sources folder?

[MarkArka]

yes

[Shambles]

Do you have the following line in your index.php file?

Code Select Expand

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 Expand

########## 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';

[MarkArka]

Hi,

Thanks

Yes I have

Code Select Expand

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

I checked the Settings.php file and it has this

Code Select Expand

########## 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.

[Kindred]

the save button won't appear if the Settings.php file is not writable...

[MarkArka]

Settings.php is writable. See screenshot

[MarkArka]

screenshot of repair_settings errors

[Shambles]

Humour me here...

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

[MarkArka]

results in white screen with

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

in top left corner

[MarkArka]

which is the same as I get when I browse to the forum folder

[MarkArka]

I appreciate you guys sticking with this.

[MarkArka]

so whats my next step?

[MarkArka]

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.

[Illori]

At this time SMF does not support php 7. It will not work correctly on that version.

[MarkArka]

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

[Kindred]

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

[MarkArka]

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 

[Kindred]

when you rolled back, did you reload both the FILES and the DATABASE?

[MarkArka]

no just the files. Have I cocked up?

[Kindred]

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

[Illori]

if you checked the option for the upgrade to do a backup, you may have some backup tables in the databse you can use.

[MarkArka]

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.

[Illori]

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.

[MarkArka]

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.

[MarkArka]

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;

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.

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;

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?

[d3vcho]

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

[MarkArka]

SUCCESS!!!!

thanks d3vcho, Kindred and Illori for all the help.

I got there in the end.. 

Fully working    SMF 2.0.12 yippeeeeee