Code:
X-CART DATABASE 4.3.2 -> 4.4.0 UPGRADE NOTES
=============================================
!!! PLEASE CLOSE YOUR STORE AND BACK UP YOUR OLD X-CART DATABASE BEFORE STARTING UPGRADE !!!
HOW TO UPGRADE
--------------
For a successful upgrade, please follow these steps:
1. Close your store for customers:
- Log in to your store as administrator.
- Go to General settings->General options.
- Select the check box for the option 'Check this to close your shop temporarily'.
- Click the 'Save' button.
2. Back up your X-Cart database. You can do it using one of the following methods:
a) Backing up via X-Cart's administration interface.
To be able to use this method, you must be logged in as administrator.
Do the following:
- Go to the 'DB Backup/Restore' section of your store's administration back-end.
- Click the 'Generate SQL dump' button.
b) Backing up via the command line interface.
This method is good if your store database is very big or if, for some reason, your attempt to back it up via your store's administration interface failed.
To use this method, you need to issue the following command from the command line:
> mysqldump -h <YOUR_HOST> -u <YOUR_USERNAME> -p -r <BACKUP_FILE> <YOUR_DATABASE_NAME>
Enter password: <YOUR_PASSWORD>
Actual values should be given for the following:
<YOUR_HOST> - hostname of the MySQL server used by your X-Cart,
<YOUR_USERNAME> - username for logging in to the MySQL server used by X-Cart,
<YOUR_DATABASE_NAME> - name of the database used by X-Cart,
<BACKUP_FILE> - name of the file to which you wish the SQL dump to be saved,
<YOUR_PASSWORD> - password for access to the MySQL server.
If you do not remember your MySQL server access info, you can look it up in your store's config.php file.
To learn about these backup methods, please follow an article from
the Qualiteam knowledge base at
http://help.qtmsoft.com/index.php?title=X-Cart:Backup_and_Restore#Backing_up_Store_Database
3. If you haven't yet done so, upload the database upgrader TGZ archive to the store server and unpack it to the directory where your X-Cart is installed. You will get the following files:
UPGRADE.NOTES_4.3.2-4.4.0 - file with upgrade instructions
upgrade_sql.php - main upgrade script
SQL dump files:
upgrade/4.4.0_sql/diff.sql
upgrade/4.4.0_sql/data.sql
upgrade/4.4.0_sql/init_aff.sql
upgrade/4.4.0_sql/init_fcomp.sql
upgrade/4.4.0_sql/init_giftreg.sql
upgrade/4.4.0_sql/init_magnifier.sql
upgrade/4.4.0_sql/init_offers.sql
upgrade/4.4.0_sql/init_pconf.sql
upgrade/4.4.0_sql/init_survey.sql
upgrade/4.4.0_sql/tables.sql
4. Enter the URL http://<your_domain>/<xcart_dir>/upgrade_sql.php into the address bar of your browser.
Wait for the upgrade script to convert your database to X-Cart 4.4.0 compatible format.
5. Install a fresh X-Cart 4.4.0 in the place of your 4.3.2 store.
5.1. Download an X-Cart 4.4.0 distribution file from File area/X-Cart/X-Cart 4.4.0 section of your HelpDesk account.
5.2. Prepare to install a fresh 4.4.0 store:
- Rename the directory where your 4.3.2 store is installed to something else (For example, if your 4.3.2 store is in the directory /xcart, rename this directory to /xcart_old).
- Create a directory of the same name as the directory where your old store was installed before the renaming (/xcart).
- Upload the distribution of X-Cart 4.4.0 to the server and unpack it to this directory.
5.4. Run the installation script to install X-Cart 4.4.0: enter the URL http://<your_domain>/<xcart_4.4.0_dir>/install.php into the address bar of your browser.
At step 2 of the installation wizard ('Preparing to install X-Cart database'), specify the database you have just upgraded as the database to be used with the new store. (You can look up the required database access info in the config.php file of your X-Cart 4.3.2 store).
At step 3, select the option 'Update config.php only'. It is very important that you select this option, because otherwise the upgraded database will be deleted and re-created at the same location from the 4.4.0 SQL dump, which means that all your data from the old 4.3.2 store will be lost (You do not want this to happen).
>From now on, your X-Cart 4.4.0 will use the upgraded database.
6. Do the following:
1) Log in to your X-Cart 4.4.0 store as administrator.
2) Click on the link 'Tools'.
3) Click on the link 'Maintenance'.
4) Click the button 'Force cache generation' to generate cache data.
5) Click the button 'Regenerate' under the section 'Re-generating the Blowfish encryption key' to ensure uniqueness of your Blowfish encryption key.
7. Make sure that your root and embedded static pages exist: check the 'Static pages' page in the admin area.
8. Make sure that your payment method settings are correct.
9. Make sure that your shipping method settings are correct.
10. Make sure that all the needed modules are enabled on the 'Modules' page.
11. Make sure that your User Profiles Options settings are correct.
Now the upgrade from 4.3.2 to 4.4.0 is successfully completed.
This is the supplied text with the DBMS upgrade.
I follow this process. But the only difference from my original install is i now have.
www.site.com.au/x_cart/xcart as my initial install directory not
www.site.com.au/x_cart/
I have changed my index.htm file to point to the appropriate directory.
I can access everything except checkout on the site.