[freeside-devel] texas tax
Rick Eicher II
rick at pbol.net
Thu Mar 14 08:02:24 PST 2002
freeside=# \d h_part_pkg_historynum_seq
Sequence "h_part_pkg_historynum_seq"
Attribute | Type
---------------+---------
sequence_name | name
last_value | integer
increment_by | integer
max_value | integer
min_value | integer
cache_value | integer
log_cnt | integer
is_cycled | "char"
is_called | "char"
> -----Original Message-----
> From: Rick Eicher II [mailto:rick at pbol.net]
> Sent: Thursday, March 14, 2002 9:55 AM
> To: ivan-freeside-devel at sisd.com
> Subject: RE: [freeside-devel] texas tax
>
>
> freeside=# \d h_part_pkg
> Table "h_part_pkg"
> Attribute | Type | Modifier
> ----------------+-----------------------+----------
> historynum | integer |
> history_date | integer |
> history_user | character varying(80) |
> history_action | character varying(80) |
> pkgpart | integer |
> pkg | character varying(80) |
> comment | character varying(80) |
> setup | text |
> freq | integer |
> recur | text |
> setuptax | character(1) |
> recurtax | character(1) |
> plan | character varying(80) |
> plandata | text |
> disabled | character(1) |
> taxclass | character varying(80) |
>
>
>
> > -----Original Message-----
> > From: ivan [mailto:ivan at 420.am]
> > Sent: Thursday, March 14, 2002 9:49 AM
> > To: ivan-freeside-devel at sisd.com
> > Subject: Re: [freeside-devel] texas tax
> >
> >
> > go into the psql tool and paste the output of
> >
> > \d h_part_pkg
> >
> > On Thu, Mar 14, 2002 at 08:40:38AM -0600, Rick Eicher II wrote:
> > > Here is a tail -30 of error_log.
> > >
> > > [debug][FS::Record] SELECT * FROM part_pkg WHERE pkgpart = ?
> > > setuptax: at part_pkg.cgi line 26.
> > > recurtax: at part_pkg.cgi line 27.
> > > [debug][FS::Record] SELECT * FROM part_svc
> > > [debug][FS::Record] FS::part_pkg=HASH(0x8cedec4) ->replace
> > > FS::part_pkg=HASH(0x8d14a58)
> > > [debug][FS::Record] UPDATE part_pkg SET taxclass = 'access'
> > WHERE pkgpart =
> > > 11 AND pkg = 'Flat Rate Dail-Up' AND comment = 'For Old
> > Customers' AND setup
> > > = 0 AND freq = 1 AND recur = 16.95 AND setuptax IS NULL AND
> > recurtax IS NULL
> > > AND plan = 'flat' AND plandata = 'setup_fee=0
> > > recur_fee=16.95
> > > ' AND disabled IS NULL AND taxclass IS NULL
> > > [debug][FS::Record] INSERT INTO h_part_pkg ( history_date,
> history_user,
> > > history_action, pkgpart, pkg, comment, setup, freq, recur,
> > plan, plandata)
> > > VALUES (1016097258, 'rick', 'replace_old', 11, 'Flat Rate
> > Dail-Up', 'For Old
> > > Customers', 0, 1, 16.95, 'flat', 'setup_fee=0
> > > recur_fee=16.95
> > > ')
> > > [debug][FS::Record] INSERT INTO h_part_pkg ( history_date,
> history_user,
> > > history_action, pkgpart, pkg, comment, setup, freq, recur,
> > plan, plandata,
> > > taxclass) VALUES (1016097258, 'rick', 'replace_new', 11, 'Flat Rate
> > > Dail-Up', 'For Old Customers', 0, 1, 16.95, 'flat', 'setup_fee=0
> > > recur_fee=16.95
> > > ', 'access')
> > > DBD::Pg::st execute failed: ERROR: Unable to identify an
> > operator '=' for
> > > types 'text' and 'int4' at
> > /usr/local/lib/perl5/site_perl/5.6.1/FS/Record.pm
> > > line 662.
> > > [debug][FS::Record] SELECT * FROM part_svc WHERE ( disabled IS NULL OR
> > > disabled = '' )
> > > [debug][FS::Record] SELECT * FROM pkg_svc WHERE pkgpart = ? AND
> > svcpart = ?
> > > [debug][FS::Record] SELECT * FROM pkg_svc WHERE pkgpart = ? AND
> > svcpart = ?
> > > [debug][FS::Record] SELECT * FROM pkg_svc WHERE pkgpart = ? AND
> > svcpart = ?
> > > [debug][FS::Record] SELECT * FROM part_pkg WHERE ( disabled IS NULL OR
> > > disabled = '' )
> > >
> > >
> > ##################################################################
> > ##########
> > > ###########
> > >
> > >
> > > I assume it is haveing a problem with the h_part_pkg table.
> > >
> > > Here is the definition of the h_part_pkg.
> > >
> > > CREATE TABLE "h_part_pkg" (
> > > "historynum" int4,
> > > "history_date" int4,
> > > "history_user" varchar(80),
> > > "history_action" varchar(80),
> > > "pkgpart" int4,
> > > "pkg" varchar(80),
> > > "comment" varchar(80),
> > > "setup" text,
> > > "freq" int4,
> > > "recur" text,
> > > "setuptax" char(1),
> > > "recurtax" char(1),
> > > "plan" varchar(80),
> > > "plandata" text,
> > > "disabled" char(1),
> > > "taxclass" varchar(80)
> > > );
> > >
> > > Nothing jumps out at me. Any have an idea?
> > >
> > > Thanks Ivan,
> > > rick
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: ivan [mailto:ivan at 420.am]
> > > > Sent: Wednesday, March 13, 2002 8:04 PM
> > > > To: ivan-freeside-devel at sisd.com
> > > > Subject: Re: [freeside-devel] texas tax
> > > >
> > > >
> > > > Turn on query debugging:
> > > >
> > > > $FS::Record::DEBUG = 1;
> > > >
> > > > and post the exact statement that's causing the error.
> > > >
> > > > On Wed, Mar 13, 2002 at 05:05:29PM -0600, Rick Eicher II wrote:
> > > > > Having to redo texas tax. Now have a select box on the
> > part_pkg.cgi page
> > > > > that sets the "taxclass" to one of two objects. But when I
> > hit submit
> > > > > changes it says this:
> > > > >
> > > > > DBD::Pg::st execute failed: ERROR: Unable to identify an
> > > > operator '=' for
> > > > > types 'text' and 'int4' at
> > > > /usr/local/lib/perl5/site_perl/5.6.1/FS/Record.pm
> > > > > line 662.
> > > > >
> > > > > Since the new column taxclass is set to varchar I have no idea
> > > > where this
> > > > > error comeing from.
> > > > >
> > > > > Any ideas? Or does any one have any idea how to add a column to
> > > > a table and
> > > > > get freeside to populate it?
> > > > >
> > > > > Ivan I would love to get this working before your deal in
> > > > Dallas. But I have
> > > > > hit a wall.
> > > > >
> > > > > frustrated,
> > > > > rick
> > > > >
> > > > >
> > > >
> > > > --
> > > > _ivan
> > > >
> > > >
> > >
> > >
> >
> > --
> > _ivan
> >
> >
>
>
>
>
More information about the freeside-devel
mailing list