X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=0837e0207cac41e94789c76a13f9be2b0c65a6a4;hb=b58d8054d384ac50989bda5851c9c3a80d5d05b3;hp=181cf2a42ad62a278fabf384b2d112c7d862bb96;hpb=d8bb43c4735c6faab56eba98459d8732eb45fa68;p=freeside.git diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 181cf2a42..0837e0207 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -2,12 +2,39 @@ Upgrading to 1.2.x -

Upgrading to 1.1.x from 1.2.x

Upgrading to 1.2.x from 1.1.x

If migrating from 1.0.0, see these instructions first.
If migrating from less than 1.1.4, see these instructions first.
Back up your data and current Freeside installation.
Install the Perl module String-Approx
Configuration file location has changed! +
Move /var/spool/freeside/dbdef.datasrc to /usr/local/etc/freeside/dbdef.datasrc. +
Move /var/spool/freeside/counters to /usr/local/etc/freeside/counters.datasrc. +
Move /var/spool/freeside/export to /usr/local/etc/freeside/export.datasrc. +

Apply the following changes to your database: +

+ALTER TABLE cust_main CHANGE state state varchar(80) NULL;
+ALTER TABLE cust_main_county CHANGE state state varchar(80) NULL;
+ALTER TABLE cust_main_county ADD country char(2);
+ALTER TABLE cust_main CHANGE paydate paydate varchar(10);
+UPDATE cust_main SET country = "US" where country IS NULL OR country = '';
+UPDATE cust_main_county SET country = "US" where country IS NULL OR country = "";
+CREATE TABLE cust_main_invoice (
+   destnum int NOT NULL,
+   custnum int NOT NULL,
+   dest varchar(80) NOT NULL,
+   PRIMARY KEY (destnum),
+   INDEX ( custnum )
+);
+

Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are running a different database engine you will need to modify it slightly.
Copy or symlink htdocs and site_perl to the new copies.