[freeside-users] freeside-setup failure: Unknown table

[Jeff Finucane]

"Jordan Webb" <jordanwebb at dna-communications.com> wrote on
   Tue, 24 Oct 2006 16:49:29 -0500....

+----------
| Message-ID: <7899B5430508724591327703A21F05C10B2D17 at svr-EXCH-rch.dna-communications.office>
| From: "Jordan Webb" <jordanwebb at dna-communications.com>
| To: <freeside-users at sisd.com>
| Subject: [freeside-users] freeside-setup failure: Unknown table
| 	cust_main_county (v1.5.8)
| List-Help: <mailto:freeside-users-request at sisd.com?subject=help>
| 
| I'm trying to install Freeside 1.5.8 using the instructions here:
| http://wavetail.420.am:81/freeside/docs/install.html
+----------

  You should follow the instructions which come with your software.
According to the README file they are in httemplate/docs of your
unpacked tarball.

+----------
| When I run:
| 
| $ freeside-setup jwebb
| 
| I get a bunch of warnings like this:
| 
| NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
| "cust_pay_refund_pkey" for table "cust_pay_refund"
| 
| ...and finally, it dies like this:
| 
| Unknown table cust_main_county at
| /usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 1680
|         FS::Record::real_fields('cust_main_county') called at
| /usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 1643
|         FS::Record::fields('FS::cust_main_county=HASH(0x88d2a00)')
| called at /usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 142
|         FS::Record::new('FS::cust_main_county', 'HASH(0x88d9c48)')
| called at /usr/local/bin/freeside-setup line 133
| 
| I've tried both the 1.5.8 tarball linked on the site and checking out
| FREESIDE_1_5_BRANCH from CVS (pulled today, 2006-10-24).  This is a
| fairly freshly installed Slackware 11.0 machine, with the
| distro-supplied Apache 1.3.37 and Perl 5.8.8.  I built mod_perl 1.29 and
| PostgreSQL 8.1.5 from source.  DBI 1.52, DBD::Pg 1.49, and HTML::Mason
| 1.35 have been installed from CPAN.
+----------

  I am not certain how you got to this point, but it suggests to me that
your database is out of sync with your code.  It is tempting to suggest
'start over freshly' but you might find relief by running 

freeside-upgrade USERNAME

while logged in as user "freeside" you created immediately after you
made certain you had the requisite perl modules.


-- 
jeff at cmh.net

"There is no worse tyranny than to force a man to pay for what he does
 not want merely because you think it would be good for him." 

 Professor Bernardo de le Paz
  [ R.A. Heinlein -- "The Moon is a Harsh Mistress" ]