[freeside] fs-setup issue
Donald L. Greer, Jr.
dgreer at austintx.com
Sun Jan 11 01:26:04 PST 2004
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(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.
>
>
>
More information about the freeside-users
mailing list