[freeside] fs-setup issue

Jerry Sumpton Jerry at Sumpton.com
Mon Jan 5 14:07:11 PST 2004


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-users/attachments/20040105/d2f49cbc/attachment.htm


More information about the freeside-users mailing list