diff options
author | christopherm <christopherm@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-01 01:16:38 +0000 |
---|---|---|
committer | christopherm <christopherm@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-01 01:16:38 +0000 |
commit | ac5b087ea2d9ba7428d367aaeb288534158fee9a (patch) | |
tree | 2dbe0bdea0b653a215ba9ddfdf627cb57855050d /doc/UPGRADE-2.2.7-2.4.0 |
Initial Import
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/ledger-smb@1 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'doc/UPGRADE-2.2.7-2.4.0')
-rwxr-xr-x | doc/UPGRADE-2.2.7-2.4.0 | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/doc/UPGRADE-2.2.7-2.4.0 b/doc/UPGRADE-2.2.7-2.4.0 new file mode 100755 index 00000000..b5c317b2 --- /dev/null +++ b/doc/UPGRADE-2.2.7-2.4.0 @@ -0,0 +1,84 @@ +Upgrading to version 2.4.0 + +1. install LedgerSMB over top + # cd /usr/local + # tar zxvf sql-ledger-2.4.0.tar.gz + +2. fix permissions + # chown -hR nobody:nogroup * + # chmod 711 templates users spool + +replace nobody:nogroup with your web server user and group + +3. install the plpgsql language compiler for PostgreSQL + # createlang plpgsql <dataset> + +4. install plpgsql in template1 + # createlang plpgsql template1 + +5. Edit your templates! The old address fields are obsolete. + +The new fields are: + address1 + address2 + city + state + zipcode + country + +The same applies to the "shipto" addresses. + +Before you log in edit Pg-upgrade-2.3.4-2.3.5.sql and change the +way addresses are rewritten if you don't want US style addresses. + +North-american addresses are usually in the form of + +Five Star Stables +123 Horsehoe Blvd. +Sweetgrass, MT 19867 +U.S.A + +addr1 --> address1 +addr2 --> city +addr3 --> country +addr4 --> state + +addr4 was put into the state field to bring the field forward +to the new layout. To check if there is something in the field run +a report and sort by the "State" field. + +Either edit the records or run the SQL queries below to take them apart. + +If you have anything in the "state" field change the records to match +the others before you run the following queries. + +dbname=# update customer set state = substr(city,strpos(city,' ')+1); +dbname=# update customer set zipcode = substr(state,strpos(state,' ')+1); +dbname=# update customer set state = substr(state,1,strpos(state,' ')-1); +dbname=# update customer set city = substr(city,1,strpos(city,',')-1); + +do the same with the vendor and shipto table. + +6. create a new set of templates + + * load admin.pl and edit one of the user's + * in the "New Templates" field enter "new" and save the user + * go back in your browser so you have the same screen again + as before + * change the template directory back to what it was before + the change and save the user + + * drop into a shell window + * cd to sql-ledger/templates/new + * copy the additional templates to your private template directory + +7. Printers + +printer setup has changed to multiple printers which allow +users to choose a printer. Printers can be defined in ledger-smb.conf + + +Oracle and DB2: +=============== +There is no upgrade available for Oracle and DB2 yet. + |