Upgrade smf 2.01 to 2.02rc2 error in database Unknown column 'mem.pm_receive_fro

[Tony]

I love smf forums but do seem to get stuck with upgrades and databases.
Smf has a database backup routine but not a restore function

I followed these upgrade instructions on the upgrade smf 2.01 to 2.02rc2
These failed due to database errors and decided to do a full install.

We made a few notes for future reference
-------------------------------------------------
As a security make a secure backup to a folder on your hard disk drive.
Backup smf directories and sub directories from your website using your favourite ftp program
In the smf forum backup your database.
Make a note of the database names from smf.
If all fails you can revert to your old smf.
You will get lots of errors and many files will need a chmod to 0777.

  Download the full smf install package *.zip to a folder on your hard disk drive.

   Go to your cpanel
   Backup your mysql smf to a new folder on your hard disk drive.
   Go to mysql take a note of the smf database name
   Go to file manager delete the smf folder.
   While in file manager make a new folder smf
   Upload the smf.zip file
   Extract the zip file.

Open an internet browser enter your url/smf
Commence adding information to the install script


 

When complete test the smf
Check the database names are the same as before the upgrade.
If the database names have been entered incorrectly start the process from the beginning this process only takes a few minutes.

Cpanel
Go to cpanel mysql check the database name is correct.
Delete the smf database
Go to the backup in cpanel and restore the mysql form your hardisk
A text full of information is shown on the screen you need to press escape to exit.
Go into phpadmin
 
Click on the _smf databases
Click on boards check you can recognise some of your posts.
Logout of cpanel
Check your website/smf
Problem:-
Most of the posts work some do not.
While logged in as administrator and trying to view the posts I get an error
Unknown column 'mem.pm_receive_from' in 'field list'
File: /home/wwwsys/public_html/smf/Sources/Load.php
Line: 998

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0 RC2, while your database is at version 2.0 RC1. The above error might possibly go away if you execute the latest version of upgrade.php.
-------------------------------

I am not familiar with phpadmin and don’t know what to do next.
Where did I go wrong?
What do I need to change in the help notes?
I don’t know if the upgrade.php will work?
Also I am not sure which zip file to extract where to locate this script
Will running this script work from a browser?
-----------------------------
Many thanks to all the good work for good done by smf programmers and community
Tony

[hello]

After the problems with the upgrade I decided to delete the forum
And did full install to smf_2-0-rc3_    and restore my old mysql unfortunately the data base structure has extra fields.

I finally resolved the problem with the database.
 
I went into http://download.simplemachines.org/

Selected large upgrade smf 2.0 rc3
Downloaded this to my computer.
smf_2-0-rc3_upgrade zip file.

From cpanel I went into filemanager
Uploaded this to my  website/smf folder
From file manager I selected extract this unzipped the smf_2-0-rc3_upgrade file.
From my internet web browser I typed upgrade.php

This updated the changes to my database
All tests form smf administrator reported ok.

Just to tidy up

Ran another backup of the modified database. From smf  admin.
Went into cpanel deleted the /smf/upgrade.php
Went to cpanel backup and created a new security backup of my smf mysql data .

Systems-edge.co.uk/smf