summaryrefslogtreecommitdiff
path: root/httemplate/docs/upgrade9.html
blob: 24d1cce42d0e7fe41f6a9e3e06c97d70d4097cb2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<head>
  <title>Upgrading to 1.4.1</title>
</head>
<body>
<h1>Upgrading to 1.4.1 from 1.4.0</h1>
<ul>
  <li>If migrating from less than 1.4.0, see these <a href="upgrade8.html">instructions</a> first.
  <li>Back up your data and current Freeside installation.
  <li>Run <code>make aspdocs</code> or <code>make masondocs</code>.
  <li>Copy <code>aspdocs/</code> or <code>masondocs/</code> to your web server's document space.
  <li>Run <code>make install-perl-modules</code>.
  <li>Install <a href="http://search.cpan.org/search?dist=Net-SSH">Net::SSH</a> minimum version 0.07
  <li>Apply the following changes to your database:
<pre>
INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 18, 'daytime', 'en_US', 'Day Phone' );
INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 19, 'night', 'en_US', 'Night Phone' );
</pre>
  <li>Optionally, apply the following changes to your database (performance improvements):
<pre>
CREATE INDEX part_pkg1 ON part_pkg ( disabled );
CREATE INDEX part_svc1 ON part_svc ( disabled );
CREATE INDEX cust_bill2 ON cust_bill ( _date );
</pre>
  <li>If you want to use ACH (electronic checks), you will need to make changes to your database.  The easiest way to make these changes is to dump your database (with pg_dump), change the payinfo field in the cust_pay, cust_refund, h_cust_pay and h_cust_refund tables from varchar(16) to varchar(80), reload the database from the dump, and run dbdef-create
  <li>Restart Apache and freeside-queued.
</body>