[freeside] New Customer Problems

[ivan]

Yes, the patch below fixes the functionality of the
`hidecancelledcustomers' configuration file.   (You need to reinstall the
Perl modules and restart Apache)

On Fri, Jun 16, 2000 at 11:45:09AM +1200, Colin wrote:
> The problem was using the 'hidecancelledcustomers' file in the configuration, if this file
> existed then none of the customers were listed in the browse or search options, whether they
> were cancelled or not. Seems to work fine as long as this file did not exist.
> I'm not sure whether the following code you have appended addresses this (not too familiar with
> coding) but hopefully it does.
> 
> Col.
> 
> ivan wrote:
> 
> > Hi,
> >
> > I just checked the fix for this into CVS; it's also appended.  Took me a
> > while to track this one down; I had trouble reproducing it.  Sorry about
> > that.
> >
> > --
> > meow
> > _ivan
> >
> > Index: cust_main.pm
> > ===================================================================
> > RCS file: /home/cvs/cvsroot/freeside/FS/FS/cust_main.pm,v
> > retrieving revision 1.4
> > diff -u -r1.4 cust_main.pm
> > --- cust_main.pm        2000/02/02 20:22:18     1.4
> > +++ cust_main.pm        2000/06/15 12:36:18
> > @@ -450,15 +450,16 @@
> >
> >  sub ncancelled_pkgs {
> >    my $self = shift;
> > -  qsearch( 'cust_pkg', {
> > -    'custnum' => $self->custnum,
> > -    'cancel'  => '',
> > -  }),
> > -  qsearch( 'cust_pkg', {
> > -    'custnum' => $self->custnum,
> > -    'cancel'  => 0,
> > -  }),
> > -  ;
> > +  @{ [ # force list context
> > +    qsearch( 'cust_pkg', {
> > +      'custnum' => $self->custnum,
> > +      'cancel'  => '',
> > +    }),
> > +    qsearch( 'cust_pkg', {
> > +      'custnum' => $self->custnum,
> > +      'cancel'  => 0,
> > +    }),
> > +  ] };
> >  }
> >
> >  =item bill OPTIONS
> >
> > On Fri, Feb 04, 2000 at 09:43:25AM +1100, colinc wrote:
> > >
> > >
> > > ivan wrote:
> > >
> > > > On Wed, Feb 02, 2000 at 10:04:08AM +1100, colinc wrote:
> > > > > ivan wrote:
> > > > >
> > > > > > I don't have enough information to diagnose your browse/search problem.
> > > > > > Perhaps you're misunderstanding which tables each option searches?
> > > > >
> > > > > I have now managed to enter in the customer detail in successfully, but the browse
> > > > > options still exists
> > > > >
> > > > > For example, clicking on browse customers (by last name) will give me an error
> > > > >
> > > > >     Error processing your request
> > > > >     Your request could not be processed because of the following error:
> > > > >
> > > > >     No matching customers found!
> > > >
> > > > > This happens with almost all the browse options except for packages (by package
> > > > > number) which will display packages ordered by the customer.
> > > > > The seacrh options produces an error, eg searching by last name, although there are
> > > > > customer details in the database.
> > > >
> > > > How have you verified this?  Is there anything in the cust_main table in
> > > > the database?
> > > >
> > >
> > > Yes, definitely. I can actually see the customer details when in mysql. There are also
> > > data in the other tables which i added via the web browser.
> > > The only browse link that works is the packages (by package number) and via this you can
> > > access the customer details, however, i cannot go straight to the customer details either
> > > by browse or search.
> > >
> > > >
> > > > Do you get anything in the server's error log?
> > > >
> > >
> > > Nope, not a single error in the error log
> > >
> > > >
> > > > What OS, database, versions, etc., are you using?  What method are you
> > > > using to run the scripts as the Freeside user (mod_perl, suExec, setuid)?
> > > >
> > >
> > > linux 2.0.3.4, mysql database 3.22.27, freeside 1.2.2, perl 5.00.53.
> > > i'm using suEXEC. I also changed the user in the httpd.conf for apache which allowed
> > > freeside to run, other wise i get an error regarding the freeside user.
> > >
> > >
> > > >
> > > > Are you sure your browser isn't simply caching old results?  Have you set
> > > > the option to verify documents every time, rather than once per session?
> > > >
> > >
> > > Nope, made sure of that.
> > >
> > >
> > > >
> > > > > Another question, is it necessary to setup the sevice definition?
> > > >
> > > > If you want to offer services (as opposed to offering empty packages),
> > > > then yes.
> > > >
> > > > > > On Tue, Feb 01, 2000 at 12:59:11PM +1100, colinc wrote:
> > > > > > >
> > > > > > > Anyway, another problem is choosing any of the browse options, I have
> > > > > > > customers (manually entered) in the mysql database but it continues to say
> > > > > > > that there are no matching customer, same error occurs when i do a search for
> > > > > > > a customer that is already in the database.
> > > > > > >
> > > > > > > Any suggestion would be appreciated, thanks.
> > > > > > >
> > > > > > > Colin.
> > > > > > >
> > > > > >
> > > > > > --
> > > > > > _ivan
> > > > >
> > > >
> > > > --
> > > > _ivan
> > >
> 

-- 
meow
_ivan