X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade6.html;h=dc82975f33bcb68b827ebe4da900e88595b64f10;hp=8e70b5586c4f404ec6e0cefec4b31446988dc1a2;hb=e6cf4af2b9d3ffefebe1a3e358f0674f566b56bc;hpb=d220c8a4bfa1aee8f17ed71c2dba655160dd3595 diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index 8e70b5586..dc82975f3 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -1,8 +1,8 @@ - Upgrading to 1.2.4 + Upgrading to 1.3.0 -

Upgrading to 1.2.4 from 1.2.3

Upgrading to 1.3.0 from 1.2.3

If migrating from 1.0.0, see these instructions first.
If migrating from less than 1.1.4, see these instructions first. @@ -10,8 +10,9 @@
If migrating from less than 1.2.2, see these instructions first.
If migrating from less than 1.2.3, see these instructions first.
Back up your data and current Freeside installation. +
As 1.3.0 requires transactions, MySQL's default MyISAM and ISAM table types are no longer supported. Converting to PostgreSQL is recommended. If you really want to use MySQL, convert your tables to one of the transaction-safe table types such as BDB.
Copy the invoice_template file from the conf/ directory in the distribution to your configuration directory. -
Install the Text-Template Perl module. +
Install the Text-Template, DBIx-DBSchema, Net-SSH, String-ShellQuote and Net-SCP Perl modules.

Apply the following changes to your database:

 CREATE TABLE domain_record (
@@ -40,6 +41,17 @@ ALTER TABLE part_svc ADD svc_acct__seconds_flag char(1) NULL;
 ALTER TABLE prepay_credit ADD seconds integer NULL;

If your database supports dropping columns: +

+ALTER TABLE cust_bill DROP owed;
+ALTER TABLE cust_credit DROP credited;
+

+ Or, if your database does not support dropping columns, you can do this: +

+ALTER TABLE cust_bill CHANGE owed depriciated decimal(10,2);
+ALTER TABLE cust_credit CHANGE credited depriciated2 decimal(10,2);
+

Copy or symlink htdocs to the new copy.
Remove the symlink or directory (your_site_perl_directory)/FS.
Change to the FS directory in the new tarball, and build and install the @@ -50,5 +62,5 @@ $ perl Makefile.PL $ make $ su # make install -
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. +
Run bin/dbdef-create.