- 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 basicupg317.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 basicupg317 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 *
|
|
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 *
|
|
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: 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.
|
|
|
|
