[freeside] Bug in 1.4.1 and more recent perl modules?

Thu Jan 15 16:45:49 PST 2004

See some helpful information at the end of your message.
----- Original Message ----- 
From: Nicholas Moline
To: ivan-freeside at sisd.com
Sent: Thursday, January 15, 2004 3:24 PM
Subject: [freeside] Bug in 1.4.1 and more recent perl modules?

I recently upgraded packages on my machine and now I'm getting this error
message and cannot use freeside, buth the web interface and the daily bill
crontab is broken, i get this error message:

Cannot specify both sql_type and pg_type at
/usr/local/share/perl/5.8.2/FS/Record.pm line 272.

At first I thought this was an isolated problem but then I attempted to to
setup a new freeside for a new company I'm a part of, and after installing
all the perl modules and such I got the same error during the bin/fs-setup
stage and cannot get 1.4.1 installed at all, can I edit FS/Record.pm somehow
to fix this problem or should I upgrade to 1.5.0pre or should I force
downgrade my perl modules or something?

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