[freeside] New Customer Problems

[Colin]

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