[freeside] 1.4.1 Billing Error

[Rick Harby]

Ivan,
  I'll go back and check the differences in the schema, however my
current database was originally a 1.3.0 schema, I followed ALL the
documentation on upgrading to 1.3.1 then to 1.4.0, and then to 1.4.1, so
the current documentation must be missing some schema modifications
along the upgrade path. I'll report back what I find missing, 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