[freeside] Problem with View/Edit service definitions on new install

[Kristian Hoffmann]

It looks like your part_svc table is missing.  Did you run freeside-setup?

-Kristian

On 3 Jan 2003, Fire wrote:

> Problem with View/Edit service definitions on new install
> from the admin link I click on View/Edit service definitions .
>
>
>
> Errors Output
>      1. Error executing "SELECT * FROM part_svc WHERE ( disabled IS NULL
>         OR disabled = '' )": ERROR: Relation "part_svc" does not exist
>         at /usr/local/apache/htdocs/freeside-asp/browse/part_svc.cgi
>         line 12 , /usr/local/lib/perl5/site_perl/5.8.0/Apache/ASP.pm
>         line 1489
> Debug Output
>      1. Error executing "SELECT * FROM part_svc WHERE ( disabled IS NULL
>         OR disabled = '' )": ERROR: Relation "part_svc" does not exist
>         at /usr/local/apache/htdocs/freeside-asp/browse/part_svc.cgi
>         line 12 , /usr/local/lib/perl5/site_perl/5.8.0/Apache/ASP.pm
>         line 1489
>
> ASP to Perl Script
>
>   -: no strict;;use vars qw($Application $Session $Response Server
> $Request);;
>   -: #line 1 /usr/local/apache/htdocs/freeside-asp/browse/part_svc.cgi
>   1: ;;&Apache::ASP::WriteRef($main::Response, \('<!-- mason kludge -->
>   2: '));
>   3:
>   4: my %search;
>   5: if ( $cgi->param('showdisabled') ) {
>   6:   %search = ();
>   7: } else {
>   8:   %search = ( 'disabled' => '' );
>   9: }
>  10:
>  11: my @part_svc =
>  12:   sort { $a->getfield('svcpart') <=> $b->getfield('svcpart') }
>  13:     qsearch('part_svc', \%search );
>
>
>
>
>