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

[Ivan Kohler]

On Wed, Oct 25, 2006 at 01:42:55AM -0400, Jeff Finucane wrote:
> "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"

This is expected, it is creating the database tables.

> | ...and finally, it dies like this:
> | 
> | Unknown table cust_main_county at

This is unexpected - it is trying to insert the initial data in the tables 
and dying.  Are the tables actually created in the db?  Are there any 
other errors before this besides the NOTICEs about indices?

-- 
_ivan


> | /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