X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;fp=htdocs%2Fdocs%2Fupgrade3.html;h=0000000000000000000000000000000000000000;hp=0837e0207cac41e94789c76a13f9be2b0c65a6a4;hb=1d758388ce3b17b8de1ae1d3a8ec39c1026baefc;hpb=e6cf4af2b9d3ffefebe1a3e358f0674f566b56bc diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html deleted file mode 100644 index 0837e0207..000000000 --- a/htdocs/docs/upgrade3.html +++ /dev/null @@ -1,40 +0,0 @@ - - Upgrading to 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. -