diff options
Diffstat (limited to 'htdocs/docs/upgrade6.html')
-rw-r--r-- | htdocs/docs/upgrade6.html | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index 8e70b5586..807146f89 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -1,8 +1,8 @@ <head> - <title>Upgrading to 1.2.4</title> + <title>Upgrading to 1.3.0</title> </head> <body> -<h1>Upgrading to 1.2.4 from 1.2.3</h1> +<h1>Upgrading to 1.3.0 from 1.2.3</h1> <ul> <li>If migrating from 1.0.0, see these <a href="upgrade.html">instructions</a> first. <li>If migrating from less than 1.1.4, see these <a href="upgrade2.html">instructions</a> first. @@ -10,6 +10,7 @@ <li>If migrating from less than 1.2.2, see these <a href="upgrade4.html">instructions</a> first. <li>If migrating from less than 1.2.3, see these <a href="upgrade5.html">instructions</a> first. <li>Back up your data and current Freeside installation. + <li>As 1.3.0 requires transactions, <b>MySQL's default <a href="http://www.mysql.com/doc/M/y/MyISAM.html">MyISAM</a> and <a href="http://www.mysql.com/doc/I/S/ISAM.html">ISAM</a> table types are no longer supported</b>. Converting to <a href="http://www.postgresql.org/">PostgreSQL</a> is recommended. If you really want to use MySQL, convert your tables to one of the <a href="http://www.mysql.com/doc/T/a/Table_types.html">transaction-safe table types</a> such as <a href="http://www.mysql.com/doc/B/D/BDB.html">BDB</a>. <li>Copy the <i>invoice_template</i> file from the <i>conf/</i> directory in the distribution to your <a href="config.html">configuration directory</a>. <li>Install the <a href="http://www.perl.com/CPAN/modules/by-module/Text/">Text-Template</a> Perl module. <li>Apply the following changes to your database: @@ -40,6 +41,17 @@ ALTER TABLE part_svc ADD svc_acct__seconds_flag char(1) NULL; ALTER TABLE prepay_credit ADD seconds integer NULL; </pre> + <li>If your database supports dropping columns: +<pre> +ALTER TABLE cust_bill DROP owed; +ALTER TABLE cust_credit DROP credited; +</pre> + Or, if your database does not support dropping columns, you can do this: +<pre> +ALTER TABLE cust_bill CHANGE owed depriciated decimal(10,2); +ALTER TABLE cust_credit CHANGE credited depriciated2 decimal(10,2); +</pre> + <li>Copy or symlink htdocs to the new copy. <li>Remove the symlink or directory <i>(your_site_perl_directory)</i>/FS. <li>Change to the FS directory in the new tarball, and build and install the |