[freeside] fs-setup issue

Garan garan at muttley.net
Sun Jan 11 06:33:36 PST 2004


Don,

Thanks for the info.  It worked for me - but only after I restarted Apache.

Ivan is aware of this - 

http://article.gmane.org/gmane.comp.db.postgresql.dbdpg/632

Regards,

Garan.

-----Original Message-----
From: Donald L. Greer, Jr. [mailto:dgreer at austintx.com] 
Sent: 11 January 2004 09:26
To: ivan-freeside at sisd.com
Subject: Re: [freeside] fs-setup issue

   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?
   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(0x88ade0
0)') 
> 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(0x90e280
c)') 
> 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(0x90a37
3c)') 
> 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::ApacheHandl
er=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.
> 
>  
> 






More information about the freeside-users mailing list