[freeside] New Customer Problems

[ivan]

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
>