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

[Bowen, Peter]

For whatever reason, it sounds like the db definition was deleted,
corrupted or no longer readable.  I would first look in your freeside
config directory for the dbdef file.  Is it there?  Is it
freeside:freeside?  Is it freeside +rw? If yes to all of these, create a
backup of the dbdef file. There is a script in freeside/bin called
dbdef-create that will recreate the definitions.  Try running that.
Good luck.

-Peter

-----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:01 PM
To: 'Freeside users mailing list'
Subject: RE: [freeside-users] Working install now not working? Database?



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(0x
> ac36
> > 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=H
> ASH(
> > 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(0x
> ac05
> > 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(0
> xac0
> > 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::Apach
> eHan
> > 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

_______________________________________________
freeside-users mailing list
freeside-users at sisd.com
http://420.am/cgi-bin/mailman/listinfo/freeside-users