- Make sure your web hosting server meets the system requirements.
- Back up your files and MySQL data.
Please be sure to backup all your original oneadmin files, and current MySQL data before upgrading.
- Do not just overwrite all files with the new ones.
You don’t have to re-install the program, just upload the upgrade files.
- Follow the step-by-step upgrade instructions below.
| Upgrading From v3.0 to v3.1.7 |
Step 1: Upload Upgrade Files
Download the ecommupg317.zip. Unzip the upgrade package onto your local hard drive.
Your upgrade package includes the updated product files / folders, that are required to upgrade your 3.0 version to the latest version. There are 3 folders and 8 files in the ecommupg317 directory.
Using your FTP program, upload all these files and folders into the existing oneadmin directory on your server, overwriting your old files & folders that you have backed up. Do not just upload the ecommupg317 directory.
Then, remove the 'access.log' file from the oneadmin/_files directory.
Step 2: Update MySQL Database
Log on to your MySQL database console (phpMyAdmin), browse the database you currently used to store the eCatalog, eCustomer, eTransaction data.
Open the following sql text files, one-by-one, with your text editor. For each file, copy the whole sql statements, and paste it to the SQL section on your MySQL database console (phpMyAdmin). Execute the sql statements.
* Important: you must follow the file sequences to run the sql queries in the database console.
| SQL Files |
File Location |
Description |
| ecomup1.txt |
oneadmin/ecommerce/ |
- Updating records of sys_component, and sys_variable table |
| ecomup2.txt |
oneadmin/ecommerce/ |
- Alter the following tables' structure:
ecommerce_cart
ecommerce_product
ecommerce_cat_category
ecommerce_cat_price
ecommerce_pricegroup
- Create new tables, as following:
ecommerce_rating
ecommerce_recom
ecommerce_addition_cat
ecommerce_custreview
ecommerce_option
ecommerce_item |
| ecomup3.txt |
oneadmin/ecommerce/ |
- Alter the following tables' structure:
ecommerce_account
ecommerce_cust_category
ecommerce_cust_price
ecommerce_cc
ecommerce_ccitem
ecommerce_po
ecommerce_poitem
ecommerce_rfq
ecommerce_rfqitem |
Step 3: Restore Data
The restoration process is divided into 3 files, as shown in the table below, along with it's respective location and URL.
To restore your existing data, first, you navigate to ecomup4.php with your web browser. Complete the instruction. Then you proceed to the ecomup5.php, and finally ecomup6.php.
* Important: you must follow the file sequences to restore your data.
| Files |
File Location |
Example URL |
| ecomup4.php |
oneadmin/ecommerce/ecomup4.php |
http://your-domain/oneadmin/ecommerce/ecomup4.php |
| ecomup5.php |
oneadmin/ecommerce/ecomup5.php |
http://your-domain/oneadmin/ecommerce/ecomup5.php |
| ecomup6.php |
oneadmin/ecommerce/ecomup6.php |
http://your-domain/oneadmin/ecommerce/ecomup6.php |
Your old data will be restored automatically. The restoration may takes several minutes, depends on the size of your database, and the speed of your network connection. Please do not interrupt the restoration process.
Step 4: Adjust Folders
Access to the oneadmin directory on your web server through FTP connection, and remove the 'eccatalog', 'ecustomer', and 'ectransact' folders.
Then, browse to the oneadmin/_files/ directory. Rename the 'eccatalog' folder to 'ecommerce'. Ensure the folder is named correctly.
Step 5: Setup Options, Preference setting, Translation
Once the upgrade is done, you can now login to your One Admin panel, using the existing username and password.
* Note: If you encounter permission error after login, try to remove the oneadmin/_files/access.log file.
Then go to the admin > Info & Settings section, fill in the admin email address. This is the 'FROM' email address when you send out an email. Choose an email sending option, of either using PHP mail() or SMTP.
Reconfigure the Preference setting if you wish, and prepare your own new language files.
Step 6: Front-end Integration
Finally, you may wish to check out the new integration code to upgrade your front end interface.
For detailed integration guidelines, please refer to http://www.comdevweb.com/knowledgebase.php?faq_id=280&category_id=90&parent_id=37
|
|
|
|
