1 Upgrading to version 2.4.0
3 1. install SQL-Ledger over top
5 # tar zxvf sql-ledger-2.4.0.tar.gz
8 # chown -hR nobody:nogroup *
9 # chmod 711 templates users spool
11 replace nobody:nogroup with your web server user and group
13 3. install the plpgsql language compiler for PostgreSQL
14 # createlang plpgsql <dataset>
16 4. install plpgsql in template1
17 # createlang plpgsql template1
19 5. Edit your templates! The old address fields are obsolete.
29 The same applies to the "shipto" addresses.
31 Before you log in edit Pg-upgrade-2.3.4-2.3.5.sql and change the
32 way addresses are rewritten if you don't want US style addresses.
34 North-american addresses are usually in the form of
46 addr4 was put into the state field to bring the field forward
47 to the new layout. To check if there is something in the field run
48 a report and sort by the "State" field.
50 Either edit the records or run the SQL queries below to take them apart.
52 If you have anything in the "state" field change the records to match
53 the others before you run the following queries.
55 dbname=# update customer set state = substr(city,strpos(city,' ')+1);
56 dbname=# update customer set zipcode = substr(state,strpos(state,' ')+1);
57 dbname=# update customer set state = substr(state,1,strpos(state,' ')-1);
58 dbname=# update customer set city = substr(city,1,strpos(city,',')-1);
60 do the same with the vendor and shipto table.
62 6. create a new set of templates
64 * load admin.pl and edit one of the user's
65 * in the "New Templates" field enter "new" and save the user
66 * go back in your browser so you have the same screen again
68 * change the template directory back to what it was before
69 the change and save the user
71 * drop into a shell window
72 * cd to sql-ledger/templates/new
73 * copy the additional templates to your private template directory
77 printer setup has changed to multiple printers which allow
78 users to choose a printer. Printers can be defined in sql-ledger.conf
83 There is no upgrade available for Oracle and DB2 yet.