Revision [523]

This is an old revision of HOWTOupgrade made by PhilDaintree on 2007-10-12 02:37:00.


Guide to Upgrading

Note there are notes specific to different versions: Upgrading to 3.05 see: to305

General Upgrading

This is an example from 3.0 to latest CVS version of 3.04/05
Assuming your on a linux system and have CVS installed.

mkdir /tmp/weberp-cvs
cvs login
cvs -z3 co -P webERP
cvs -z3 update -d -P

Backup your MySQL database with whichever tool you understand and know how to restore a backup with.
Add the line at the top of each upgrade script

use weberp;

Where weberp is the name of your database.

The command to upgrade the database is as follows:

mysql -uUSER -pPWD < path_to_upgraded_webERP_install/sql/mysql/upgradeXX.X-YY.Y.sql

Repeat the command using each upgrade script in sequence.

There should be no errors, if there are, stop now and investigate as the new scripts will not work if errors were returned.

! Backup the old weberp script directories. !

Now copy the new WebERP scripts over the old scripts, eg.

cp newcvs_erp/* /var/www/html/current_erp/ -Rf

Edit the new config.php file and set the variables.

cp companies/weberp companies/yourdatabase -R

copy from the backup directory, your logo.jpg file into companies/yourdatabase/

cp part_pics/* companies/yourdatabase/part_pics -Rf

Copy over any customised PDF or Report templates from your script backup (ie. invoices, packing slips etc)

chown apache.apache current_erp/* -R

Remove any existing session files ( for example from /tmp/.current_erp_sessions/ )

Log in to your new system

Run the Z_Upgrade_3.01-3.02.php script (as of 28/1/06 the script may not exit cleanly, but the changes are made correctly)

Go to Setup and check your Company Preferences, there will be some changes to options that you may need to update.

Note the Address fields have changed.

If you are in Australia, and had Australian GST setup OK in 3.00, you must go to Tax Group Maintenance, Edit Default Tax Group, and Add the Australian GST to the Assigned Taxes Tax Group.

A bug from CVS versions before 24/1/2006, led that a field needs to be added to the table "config, add field

'SO_AllowSameItemMultipleTimes' with value '1'. Fixed in post 28/1/2006 versions.

! Backup the new database before entering any transactions, if you have made a mistake, then you can fix it and reload the database!
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki