[freeside] 1.4.1 Billing Error

[Rick Harby]

Ivan,
  I think I found the issue... The upgrade docs for going from 1.3.1 to
1.4.0 gives the following definition for cust_bill_event:

CREATE TABLE cust_bill_event (
  eventnum int primary key,
  invnum int not null,
  eventpart int not null,
  _date int not null
);

Then nothing in the upgrade docs from 1.4.0 to 1.4.1 about any changes
to that table definition, however a new installation of 1.4.1 shows the
definition as:

CREATE TABLE cust_bill_event (
    eventnum integer NOT NULL,
    invnum integer NOT NULL,
    eventpart integer NOT NULL,
    _date integer,
    status character varying(80) NOT NULL,
    statustext text
);

So did I miss a doc page on schema changes from 1.4.0 to 1.4.1? Just
wondering, as I can correct this definition, but this is a production
environment, so I'd like to know if there are any more then this one.
Thanks.

Rick

-----Original Message-----
From: ivan at 420.am [mailto:ivan at 420.am] 
Sent: Thursday, August 21, 2003 7:04 PM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] 1.4.1 Billing Error

On Thu, Aug 21, 2003 at 12:16:33PM -0400, Rick Harby wrote:
> I have 1.4.1 installed,

You're running the 1.4.1 code, but your database is from (at least)
before 1.4.0pre12, before the 1.4.x schema was finalized.

Only beta / release candidate / stable releases are supported and have
schema upgrade instructions.

If you aren't a developer willing to follow schema changes yourself, you
should not have been running development pre-releases in production.
Start over with a real 1.4.1 installation, or manually check CVS for
differences between the code you created the schema with and the final
1.4.x schema, then apply those changes to your database.

Good luck.

-- 
_ivan


> with Business::OnlinePayment::TCLink, when I
> have a customer who's credit card was declined, then they call to
update
> their credit card information. I replace the info in the Customer edit
> screen, then click 'Bill' again, and it bounces back with this error:
>  
> Your request could not be processed because of the following error: 
> WARNING: Event run but database not updated - error inserting
> cust_bill_event, invnum #24805, eventpart 4: ERROR: Cannot insert a
> duplicate key into unique index cust_bill_event1 
> I see the charge at TrustCommerce, but the invoice remains open. I'm
> guessing because there is an Event which failed to bill. How do I
> correct? I need my call center reps to know real time if the new card
is
> valid. Thanks.
>  
>  

-- 
_ivan