[freeside] fs-setup issue

ivan ivan at 420.am
Fri Jan 23 17:56:51 PST 2004


On Sun, Jan 11, 2004 at 03:26:05AM -0600, Donald L. Greer, Jr. wrote:
>   Jerry,
>   I just dinked with this.  I found that removing the ",{TYPE => ...} " 
> from those lines hs made the error go away, if not actually solved the 
> problem.
>   Accoding to the DBI man page these are used as "Hints", and so I'm 
> making a completely unfounded supposition that the driver knows what 
> sort of value is held in these fields.
>   We'll see if it explodes.
>   Ivan, any comment (including "you idiot!" ;^) you'ld like to make on 
> this?

Well, when that was originally written, providing the column type was
necessary so that the DBD driver didn't attempt to quote numeric
columns.  Removing the hints would presumably cause search queries on
those columns to fail or not return the correct results.

-- 
_ivan


>   Don
> 
> Jerry Sumpton wrote:
> 
> >Hi, I have run into a new but related error in Record.pm.
> >
> > 
> >
> >Please note that I have both perl 5.6.1 and 5.8.2 installed. I have 
> >modified both copies of Record.pm and doubt that is the problem, but I 
> >am not an expert.
> >
> > 
> >
> >Thanks, Jerry.
> >
> > 
> >
> >http://freeside.connectionfirm.com:800/edit/part_svc.cgi
> >
> > 
> >
> >error:  Cannot specify both sql_type and pg_type at 
> >/usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274.
> >
> > 
> >
> >context:  ...  
> >
> >270:  && $dbdef->table($table)->column($field)->type =~ /(int)/i
> >
> >271:  ) {
> >
> >272:  # $sth->bind_param($bind++, $record->{$field}, { TYPE => 
> >SQL_INTEGER } );
> >
> >273:  $sth->bind_param($bind++, $record->{$field}, { pg_type => 21 } );
> >
> >274:  } else {
> >
> >275:  # $sth->bind_param($bind++, $record->{$field}, { TYPE => 
> >SQL_VARCHAR } );
> >
> >276:  $sth->bind_param($bind++, $record->{$field}, { pg_type => 25 } );
> >
> >277:  }
> >
> >278:  }
> >
> >...  
> >
> > 
> >
> >code stack:  /usr/lib/perl5/site_perl/5.6.1/FS/Record.pm:274
> >
> >g /www/freeside.connectionfirm.com/html/edit/part_svc.cgi:158
> >
> >g /www/freeside.connectionfirm.com/html/edit/part_svc.cgi:249
> >
> >g 
> >
> >raw error
> >
> > 
> >
> >Cannot specify both sql_type and pg_type at 
> >/usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274.
> >
> > 
> >
> > 
> >
> >Trace begun at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Exceptions.pm 
> >line 131
> >
> >HTML::Mason::Exceptions::rethrow_exception('Cannot specify both sql_type 
> >and pg_type at /usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274.^J') 
> >called at /usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274
> >
> >FS::Record::qsearch('part_export', 'HASH(0x90ee118)') called at 
> >/www/freeside.connectionfirm.com/html/edit/part_svc.cgi line 158
> >
> >HTML::Mason::Commands::__ANON__('svc_acct') called at 
> >/usr/lib/perl5/site_perl/5.6.1/HTML/Widgets/SelectLayers.pm line 169
> >
> >HTML::Widgets::SelectLayers::html('HTML::Widgets::SelectLayers=HASH(0x88ade00)') 
> >called at /www/freeside.connectionfirm.com/html/edit/part_svc.cgi line 249
> >
> >HTML::Mason::Commands::__ANON__ at 
> >/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 134
> >
> >HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x90e280c)') 
> >called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 1069
> >
> >eval {...}('HTML::Mason::Component::FileBased=HASH(0x90e280c)') called 
> >at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 1068
> >
> >HTML::Mason::Request::comp(undef, undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 338
> >
> >eval {...}(undef, undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 338
> >
> >eval {...}(undef, undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 297
> >
> >HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x90a373c)') 
> >called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 
> >134
> >
> >eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x90a373c)') called 
> >at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 134
> >
> >HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x90a373c)') 
> >called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 
> >792
> >
> >HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x8e90afc)', 
> >'Apache=SCALAR(0x8e96378)') called at /usr/local/etc/freeside/handler.pl 
> >line 151
> >
> >HTML::Mason::handler('Apache=SCALAR(0x8e96378)') called at /dev/null line 0
> >
> >eval {...}('Apache=SCALAR(0x8e96378)') called at /dev/null line 0
> >
> > 
> >
> > 
> >
> >-----Original Message-----
> >From: Jeremy Davis [mailto:jeremy at manageisp.com]
> >Sent: Tuesday, December 16, 2003 10:41 AM
> >To: ivan-freeside at sisd.com; Jerry at Sumpton.com
> >Subject: RE: [freeside] fs-setup issue
> >
> > 
> >
> >Well I am currently looking into the issue.  I have a new install that 
> >is broken too.  Basically, the DBD::Pg module is broken in the way that 
> >freeside currently uses it.  It was suppose to be fixed before the 
> >release of 1.3 .  I am currently looking into altering freeside to avoid 
> >this.  If I get a fix I will let you know.  
> >
> > 
> >
> >Jeremy
> >
> > 
> >
> >-----Original Message-----
> >From: Jerry Sumpton [mailto:Jerry at Sumpton.com]
> >Sent: Tuesday, December 16, 2003 12:37 PM
> >To: ivan-freeside at sisd.com
> >Subject: Re: [freeside] fs-setup issue
> >
> >Hi again,
> >
> > 
> >
> >Is there anyone on this list that I could employ to help me with this 
> >setup issue?
> >
> > 
> >
> >Thanks, Jerry.
> >
> > 
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> > 
> >
> >Hi,
> >
> > 
> >
> >I am having problems running bin/fs-setup. It looks like this is a 
> >problem others have encountered.
> >
> > 
> >
> >NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
> >'h_svc_acct_pkey' for table 'h_svc_acct'
> >
> >Cannot specify both sql_type and pg_type at 
> >/usr/local/lib/perl5/site_perl/5.8.2/FS/Record.pm line 273.
> >
> > 
> >
> >I used the first patch from Ivan on Nov 19th, and arrived further along 
> >at this point. Can anyone point me in a successful direction?
> >
> > 
> >
> >NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 
> >'h_svc_acct_pkey' for table 'h_svc_acct'
> >
> >DBI::st=HASH(0x852b810)->bind_param(...): attribute parameter '4' is not 
> >a hash ref at /usr/local/lib/perl5/site_perl/5.8.2/FS/Record.pm line 274.
> >
> > 
> >
> >Does the first patch trigger the second error? If so, and I don't know, 
> >would it be possible to make the first patch conditional? (On what, I 
> >don't understand).
> >
> > 
> >
> >My version is perl is newer. I am using freeside 1.4.1, mason 1.24, 
> >postgresql 7.1.2, DBI 1.38, and linux 7.3.
> >
> > 
> >
> >Thanks, Jerry.
> >
> > 
> >
> 

-- 
_ivan



More information about the freeside-users mailing list