Re: Fw: [Emerald] Invoice problems

Dale E. Reed Jr. ( (no email) )
Wed, 24 Mar 1999 09:46:14 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Geoffrey L. Scully: "[Emerald] Lost packets problems"
Next message: Jody Mason: "[Emerald] Serv-u"
Maybe in reply to: Ed Miller: "Fw: [Emerald] Invoice problems"

Ed Miller wrote:
>
> Any help from IEA-Software? Re-submit this problem. I really need to get
> this fixed. :-)
>
> This morning I tried to run renewal and was getting a Primary Key error on
> Invoices. I then went to Emerald Admin. and ran the check database and I
> could then generate new invoices.
> Life is good.
> I ran ICVerfy and tried to import the paid invoices back into Emerald and
> got errors on every one. When I go to pay any invoice and I get 'SQL Error
> Couldn't Insert Payment. Account and Invoices Not updated! ' This does not
> make since I have been using 2.5 for months. Did the check database mess
> things up in Emerald?
> What gives?
> Any ideas out there?

The Emerald Admin Check Database only does a consistency
check. Run the checkdb.sql script, which also includes checking
the identities. You probably have an identity problem on your
payments table.

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html

Previous message: Geoffrey L. Scully: "[Emerald] Lost packets problems"
Next message: Jody Mason: "[Emerald] Serv-u"
Maybe in reply to: Ed Miller: "Fw: [Emerald] Invoice problems"