dferguson
19th October 2006, 01:44 PM
This post will help outline what happens during the upgrade process to the website database - known as store.mdb.
This information may be useful to those that have created custom applications which hook directly into the ezimerchant database.
ezimerchant Professional V4.0 needs to upgrade your websites database. This upgrade process is initiated the first time you attempt to open your website after installing the V4.0 upgrade.
Please note: This upgrade process is IRREVERSIBLE. Make sure you have backups of your site before you proceed. If you attempt to open an upgraded website in an older (v3.x) version of ezimerchant you will recieve an error message.
The Upgrade Process:
Fortunatly the upgrade process is usually fully automated - you need to do nothing except wait for the upgrade procedure to finish. Depending on the size of your website the upgrade process may be so quick you hardly notice it or may take several minutes.
The Upgrade Steps:
Internally ezimerchant Professional will perform the following changes to your website database.
Creates gift voucher tables
Adds meta tag/description/keyword fields to the additional pages table.
Adds plaintextdescription column to the products table.
Adds includeinfeeds field to products table.
Adds availability fields to product table.
For house keeping purposes - Deletes all products with null product codes. (should be zero products deleted)
Increases productcode column to 25 characters.
Splits names in customer table into Salutation/First/Last.
Splits names in orders table into Salutation/First/Last.
Adds country and state ID's to customer table and updates based on textual values where possible.
Adds send and receive buffer columns to FTPSites table.
Once all the above is complete, you should be able to open your website as per normal.
This information may be useful to those that have created custom applications which hook directly into the ezimerchant database.
ezimerchant Professional V4.0 needs to upgrade your websites database. This upgrade process is initiated the first time you attempt to open your website after installing the V4.0 upgrade.
Please note: This upgrade process is IRREVERSIBLE. Make sure you have backups of your site before you proceed. If you attempt to open an upgraded website in an older (v3.x) version of ezimerchant you will recieve an error message.
The Upgrade Process:
Fortunatly the upgrade process is usually fully automated - you need to do nothing except wait for the upgrade procedure to finish. Depending on the size of your website the upgrade process may be so quick you hardly notice it or may take several minutes.
The Upgrade Steps:
Internally ezimerchant Professional will perform the following changes to your website database.
Creates gift voucher tables
Adds meta tag/description/keyword fields to the additional pages table.
Adds plaintextdescription column to the products table.
Adds includeinfeeds field to products table.
Adds availability fields to product table.
For house keeping purposes - Deletes all products with null product codes. (should be zero products deleted)
Increases productcode column to 25 characters.
Splits names in customer table into Salutation/First/Last.
Splits names in orders table into Salutation/First/Last.
Adds country and state ID's to customer table and updates based on textual values where possible.
Adds send and receive buffer columns to FTPSites table.
Once all the above is complete, you should be able to open your website as per normal.