Comdev - More PHP Modules For Your Website Think PHP Modules . Think Comdev 
Home
Product
Support
Enquiry
Become Partner
Order Now

Upgrade Instruction
Download Upgrade    Print Version
  1. Make sure your web hosting server meets the system requirements.

  2. Back up your files and MySQL data.
    Please be sure to backup all your original oneadmin files, and current MySQL data before upgrading.

  3. Do not just overwrite all files with the new ones.
    You don’t have to re-install the program, just upload the upgrade files.

  4. Follow the step-by-step upgrade instructions below.

Upgrading From v3.0 to v3.1.7
Step 1: Upload Upgrade Files

Download the oneadupg317.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.

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 oneadupg317 directory.

Then, remove the 'access.log' file from the oneadmin/_files directory.


Step 2: Update MySQL Database, Restore Data

Now, you'll need update the database structure, and restore your current data of each module, one-by-one.
Web Blogger 3.1.7
I. Update Database

Log on to your MySQL database console (phpMyAdmin), browse the database you currently used to store the One Admin data.

Open the blogup1.txt with your text editor. Copy the whole sql statements, and paste it to the SQL section on your MySQL database console. Execute the sql statements. Repeat for blogup2.txt.

* Important: you must follow the file sequences to run the sql queries in the database console.


SQL Files / Location Description
blogup1.txt
oneadmin/blogger/		 - Update records in sys_component, and sys_variable table
blogup2.txt
oneadmin/blogger/		 - Create blogger_category, blogger_links tables.

- Alter table fields of blogger_friend, blogger_blog, blogger_comments

II. Run Upgrade Scripts

You may now proceed to restore your existing data. To do this, navigate to the oneadmin/blogger/blogup3.php with your web browser.

For example: http://your-domain/oneadmin/blogger/blogup3.php. Follow the instructions.

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.
Event Calendar 3.1.7
I. Update Database

Open these sql files with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin). Remember to follow the files' sequence.

SQL Files / Location Description
caleup1.txt
oneadmin/calendar/		 - Updating sys_component, and sys_variable table
caleup2.txt
oneadmin/calendar/		 - Create calendar_date table.

- Alter table fields of calendar_type, calendar_reminder, calendar_event

II. Run Upgrade Scripts

To restore your data, navigate to the oneadmin/calendar/caleup3.php with your web browser.

For example: http://your-domain/oneadmin/calendar/caleup3.php. Follow the instructions.
Contact Form 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
contup1.txt
oneadmin/contactform/		 - Update data of sys_component table

II. Run Upgrade Scripts

To restore your data, navigate to the oneadmin/contactform/contup2.php with your web browser.

For example: http://your-domain/oneadmin/contactform/contup2.php.
Guestbook 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
guesup1.txt
oneadmin/guestbook/		 - Update data of sys_component, and sys_variable table

II. Run Upgrade Scripts

To restore your data, navigate to the oneadmin/guestbook/guesup2.php with your web browser.

For example: http://your-domain/oneadmin/guestbook/guesup2.php.
Vote Caster 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
voteup1.txt
oneadmin/votecaster/		 - Update data of sys_component table

- Add new records to sys_variable table

* There is no need to restore data *


eCommerce 3.1.7
I. Update Database

Open these sql files with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin). Follow the files' sequence.

SQL Files / 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

II. Run Upgrade Scripts

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, navigate to ecomup4.php with your web browser, followed by ecomup5.php, and finally ecomup6.php.

Files / 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

III. Adjust Directory

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.
News Publisher 3.1.7
I. Update Database

Open these sql files with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin). Follow the files' sequence.

SQL Files / Location Description
newsup1.txt
oneadmin/newspublish/		 - Update data of sys_component, and sys_variable table
newsup2.txt
oneadmin/newspublish/		 - Create news_category table.

- Alter the table structure of news_publish

II. Run Upgrade Scripts

To restore your data, navigate to the oneadmin/newspublish/newsup3.php with your web browser.
For example: http://your-domain/oneadmin/newspublish/newsup3.php.
III. Adjust Folders

Access to the oneadmin directory on your web server through FTP connection, and remove the 'newsannounce' folder.

Then, browse to the oneadmin/_files/ directory. Rename the 'newsannounce' folder to 'newspublish'. Ensure the folder is named correctly.
Photo Gallery 3.1.7
I. Update Database

Open the following sql file with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
photoup1.txt
oneadmin/photogallery/		 - Update data of sys_component, sys_variable tables

- Alter table photo_gallery, and photo_category to addon new fields.

* No restoration is required *


Newsletter 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
newsup1.txt
oneadmin/newsletter/		 - Update data of sys_component, sys_variable tables

* There is no need to restore data *


Links Directory 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
linkup1.txt
oneadmin/linksdir/		 - Update record of sys_component table

* There is no need to restore data *


FAQ Support 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
faqsup1.txt
oneadmin/faqsupport/		 - Update sys_component record.

- Alter the structure of faq_support, faq_category tables

* No restoration is required *


Customer Helpdesk 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
helpup1.txt
oneadmin/helpdesk/
 - Update record of sys_component, sys_variable tables

* No restoration is required *


Geo Traffic 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
geotup1.txt
oneadmin/geotraffic/		 - Update record of sys_component table

* There is no need to restore data *


CSV Importer 3.1.7
I. Update Database

Open the sql file below with your text editor. Execute the sql queries in the SQL section on your database console (phpMyAdmin).

SQL Files / Location Description
csviup1.txt
oneadmin/csvimport/		 - Update record of sys_component table

II. Adjust Folders

Access to the oneadmin directory on your web server through FTP connection, and remove the 'csvdatatool' folder.

Then, browse to the oneadmin/_files/ directory. Rename the 'csvdatatool' folder to 'csvimport'. Ensure the folder is named correctly.

Step 4: 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.

For every component, reconfigure the Preference setting if you wish, and prepare your own new language files.


Step 5: Front-end Integration

Finally, you may wish to check out the new integration codes to upgrade your front end interface.

The integration guidelines of each component can be find in the Tutorial section on our knowledge base.



Customer Sales
  Sales Enquiry

Support Center
  Discussion Forum
  Knowledge Base
  Customer Helpdesk
  Installation Support
  Request Trial Download
  Installation
  Upgrade Center
  Activation Key

More Information
• Purchase & Delivery
• Pricing Information
• Payment Methods
• Refund Policy
• License Agreement
• Privacy Policy





Copyright © 2002-2005 by Comdev Software Sdn Bhd. All Rights Reserved. License Agreement Privacy Policy