[freeside] session_history.cgi

Rich Beams rbeams at storminteractiveinc.com
Tue Dec 16 10:41:48 PST 2003


There you go again Ivan, pointing fingers instead of solving problems. Well,
for those of you that run into this problem here's the workaround that got
my install up and running. I'm building a test environment and just needed
to get it up for some tests. If this workaround has any side effects, Ivan
to chime in, then I would wait for the DBD::Pg bug fix on a production env.
install.

Ok, searches on google groups fixed the problem with a workaround. It may be
a bug in DBD::Pg for sql_types, but you can still use pg_types. Read the
error message.

----------------
Error message when running the "bin/fs-setup <username>' step:

"Cannot specify both sql_type and pg_type at
/usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274."

Workaround: (FYI, not elegant)

    if ( $record->{$field} =~ /^\d+(\.\d+)?$/
         && $dbdef->table($table)->column($field)->type =~ /(int)/i
    ) {
      $sth->bind_param($bind++, $record->{$field}, {pg_type => 21} );
    } else {
      $sth->bind_param($bind++, $record->{$field}, {pg_type => 25} );
    }

----------------






-----Original Message-----
From: ivan [mailto:ivan at 420.am]
Sent: Thursday, December 11, 2003 6:18 PM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] session_history.cgi


This is a DBD::Pg bug, which hopefully will be fixed in DBD::Pg 1.32.
It would be worthwhile to test a current DBD::Pg snapshot from
gborg.postgresql.org and report if the problem has in fact been fixed.

--
_ivan


On Thu, Dec 11, 2003 at 05:32:56PM -0700, Rich Beams wrote:
> I'm installing freeside and get the error below noted in an email post on
> Nov. 21st. Ivan put up a work around but that produced another error also
> noted in an email post. In the CVS it looks like Ivan went back to the
> original syntax. But the current cvs version still throws the original
> error. Is there any solution for this or workaround?
>
> Happens when running 'bin/fs-setup'
>
> "Cannot specify both sql_type and pg_type at
> /usr/lib/perl5/site_perl/5.6.1/FS/Record.pm line 274."
>
> Thanks.
>
>

--
_ivan






More information about the freeside-users mailing list