[freeside-users] Working install now not working? Database?

Sun Dec 11 16:00:41 PST 2005

I also just verified the database is fine. I can goto the sysadmin section
and query the database just fine. I just did a * FROM CUST_MAIN and got the
complete list of customers. I can query all tables in the database using the
query tool in freeside, but freeside can not access the info? I am confused
what happened?

I just tried to click on the list customer by last name and still got this
error:

error:  Can't call method "table" on an undefined value at
/usr/lib/perl5/site_perl/5.8.6/FS/Record.pm line 221.

context:  ...   
217:  $select ||= '*'; 
218:  my $dbh = dbh; 
219:   
220:  my $table = $cache ? $cache->table : $stable; 
221:  my $dbdef_table = $dbdef->table($table) 
222:  or die "No schema for table $table found - ". 
223:  "do you need to create it or run dbdef-create?"; 
224:  my $pkey = $dbdef_table->primary_key; 
225:   
...   

code stack:  /usr/lib/perl5/site_perl/5.8.6/FS/Record.pm:221
/var/www/html/freeside/search/cust_main.cgi:157
/var/www/html/freeside/autohandler:1

Help anyone?

Thanks,
John

> -----Original Message-----
> From: freeside-users-bounces at sisd.com [mailto:freeside-users-
> bounces at sisd.com] On Behalf Of Sales at michianawireless.com
> Sent: Sunday, December 11, 2005 6:01 PM
> To: 'Freeside users mailing list'
> Subject: RE: [freeside-users] Working install now not working? Database?
> 
> 
> 
> Correction we are running (PostgreSQL) 8.0.4
> 
> John
> 
> > -----Original Message-----
> > From: freeside-users-bounces at sisd.com [mailto:freeside-users-
> > bounces at sisd.com] On Behalf Of Sales at michianawireless.com
> > Sent: Sunday, December 11, 2005 5:49 PM
> > To: 'Freeside users mailing list'
> > Subject: [freeside-users] Working install now not working? Database?
> >
> >
> > Hello,
> >
> > We HAD a working install of Freeside for quite awhile now. However when
> I
> > went to log in to the freeside today to post a payment, I got the normal
> > login prompt and then menu. But anytime I try to access the database of
> > clients or post a payment etc, I get this error:
> >
> > Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm
> > line
> > 129
> > HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "table"
> on
> > an
> > undefined value at /usr/lib/perl5/site_perl/5.8.6/FS/Record.pm line
> > 221.^J')
> > called at /usr/lib/perl5/site_perl/5.8.6/FS/Record.pm line 221
> > FS::Record::qsearch('cust_main', 'HASH(0xabbb38c)', '*', ' ORDER BY
> > LOWER(last || \' \' || first) LIMIT 100') called at
> > /var/www/html/freeside/search/cust_main.cgi line 157
> > HTML::Mason::Commands::__ANON__('browse', 'last') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 135
> >
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xac36
> > 09
> > 0)', 'browse', 'last') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1255
> > eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
> > 1249
> > HTML::Mason::Request::comp(undef, undef, 'browse', 'last') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 916
> >
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(
> > 0x
> > ac0a098)') called at /var/www/html/freeside/autohandler line 1
> > HTML::Mason::Commands::__ANON__('browse', 'last') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 135
> >
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xac05
> > 0e
> > c)', 'browse', 'last') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1250
> > eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
> > 1249
> > HTML::Mason::Request::comp(undef, undef, undef, 'browse', 'last') called
> > at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 461
> > eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
> > 461
> > eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
> > 413
> >
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xac0
> > a0
> > 98)') called at
> /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm
> > line 167
> >
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHan
> > dl
> > er=HASH(0xac0a098)') called at
> > /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line 817
> >
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HAS
> > H(
> > 0x90caf90)', 'Apache2::RequestRec=SCALAR(0xaa338f0)') called at
> > /usr/local/etc/freeside/handler.pl line 305
> > eval {...} at /usr/local/etc/freeside/handler.pl line 305
> > HTML::Mason::handler('Apache2::RequestRec=SCALAR(0xaa338f0)') called at
> -e
> > line 0
> > eval {...} at -e line 0
> >
> > I tried to restart freeside and keep getting the error during start like
> > the
> > one below:
> >
> > can't load database schema from
> > /usr/local/etc/freeside/dbdef.DBI:Pg:dbname=freeside at
> > /usr/lib/perl5/site_perl/5.8.6/FS/Record.pm line 1615.
> >
> > I reloaded postgres to make sure it was up and running. Any ideas please
> > anyone??
> >
> > Thanks,
> > John
> >
> > System info:
> >
> > > > > Freeside version: 1.5.7
> > > > >
> > > > > Using HTML::Mason (version 1.3101)
> > > > >
> > > > > OS Fedora 4
> > > > >
> > > > > Perl V 5.8.5
> > > > >
> > > > > Apache-DBI-0.94
> > > > >
> > > > > MLDBM-2.01
> > > > >
> > > > > postgresql-7.4.8o
> >
> > _______________________________________________
> > freeside-users mailing list
> > freeside-users at sisd.com
> > http://420.am/cgi-bin/mailman/listinfo/freeside-users
> 
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users