Re: [SL] Various Problems SL 2.4.11/PGSQL 8.1.3

[Jason K. <ja...@no...>]

Yes, you are absolutely, 100% correct!  Good old grep had no trouble at all
finding it.  Thank you!

I edited the backup file _correctly_ this time and restored.  I made a
couple of invoices which had previously caused me grief and they were fine.
The first new part I entered was fine.  Every subsequent part I enter
'doubles itself' and sets an arbitrary value for stock for just one of
them.  Since I have been using an improperly restored SL since early
October, I think I have created some very large problems!  I compared the
sequence numbers from previous backups and it looks like they should be
continually increasing:

Backup from Jan 29/06:
id -> 11716
invoiceid -> 2056
orderitemsid -> 6


Backup from May 22/06:
id -> 12078
invoiceid -> 2620
orderitemsid -> 10

(last backup before I wrecked things)
Backup from Oct 7/06:
id -> 12445
invoiceid -> 3141
orderitemsid -> 11

Backup from Dec 30/06:
id -> 10151
invoiceid -> 207
orderitemsid -> 2

Uh-oh!  I'll bet my improper restoration in October was using id, invoiceid
and orderitemsid values of 10000, 0 and 0 (respectively).  (Does that mean
I've overwritten 360 other 'transactions'?)

I can see one way to fix this (although I don't like the thought of it):
restore the backup from October 7th and re-enter everything that was entered
since then.  Could I use the Oct 7th id, invoiceid and orderitemsid values
to restore my Dec 30th backup, expecting to have no further trouble, and
knowing that some damage has been done already that I'll fix as time
permits?

Thanks,

Jason Kay.


On 1/6/07, Dieter Simader <dsi...@sq...> wrote:
>
> Trust me, there is a value in the backup file.


<snipped! >

Dieter Simader